I am using VB6 and CR 9 to access data.
I have places a text box on CR report and i want to pass a variable's value
to the text box on report.
What command I have to use?
Ashwin Chandarana
(Baroda-India)
1. Passing parameters by ref between Vb.NET COM & VB COM
2. When trying to do an Export CR9 generated the Bug- Error: Missing parameter field current value
Can anybody help how to fight with the CR9 (.NET) bug? It appear when I am trying to make export into PDF. It gave me the error: ...ParameterFieldCurrentValueException: Missing parameter field current value. Actually I do not use any parameters there... Thanks. Eugene
3. CR9, SQL Stored Procedures & 'null' parameters - VB Crystal Report
4. How to programming VB6 with CR9 ussing parameter fields
Vlad, In your code, you wrote: varParam.SetCurrentValue lngJobIDForOrder When I look at the Object Browser, there is no method or property called SetCurrentValue belonging to the class ParameterFieldDefinition. Can you explain what I'm missing? I'm trying to implement parameters and am having difficulty. Thanks, Larry >the value for parameter On Tue, 30 Mar 2004 22:52:14 -0500, "Vlad" < XXXX@XXXXX.COM > wrote: >If your report based on SP with no parameters works then for reports on SP >with parameter add this code > >Dim varParams As CRAXDRT.ParameterFieldDefinitions >Dim varParam As CRAXDRT.ParameterFieldDefinition > > Set varParams = varReport.ParameterFields 'varReport is report >object which you know how to set and open, right? > Set varParam = varParams.Item(1) > varParam.SetCurrentValue lngJobIDForOrder 'lngCurrentJobID is >the value for parameter > >HTH >Vlad > >"Carlo Villagarcia" < XXXX@XXXXX.COM > wrote in message >news:# XXXX@XXXXX.COM ... >> Hi every one: >> >> I'm using VB 6.0 and CR 9, and I need to use some stored procedure (on a >DB >> with SQL Sever 7.0 or higher), if the stored proc has no parmeters, the >code >> works fine, but when I'm tring to use a different example with another >> stored proc wich handles even one Parameter, then my code fails, I can't >> make it work, never less I found some extra code on CR developers help, >but >> it doesn work either. >> >> I'd be sincerelly thankful if any one could please help me with some code >or >> even better, a little example. >> >> Thank a lot. >> Carlo >> >> >
5. CR9 Trouble prompting SOME rpt parameters - VB Crystal Report
6. Passing paramter to CR9 report
I am using VB6 with CR9 and an Access MDB and a prefabricated report.
In the report, I go to Report/Selection formulas/Record.
The apropriate dialog opens. In the work area where the user types in the
selection criteria, I have this:
{tblSales.StartDate} in "200401240001" to "200401312359"
tblSales is an Access mdb table. StartDate uses the format yyymmddhhmm.
Basically, from what I understand, the report simply lists names of people
that had some event between the given begin and end dates. This report is
working fine, but now I have been given the task to include this report
within
a VB6 app, letting the user select the begin date. So far I have this:
Dim Appl As New CRAXDRT.Application
Dim Report As New CRAXDRT.Report
Set Report = Appl.OpenReport("c:\develop\prjs\Test\Schedule.rpt")
CRV9.ReportSource = Report
CRV9.ViewReport
I have ticked the corresponding entries in the References and Components
dialogs. The report comes up just fine.
My question is, how do I get the strings representing the dates into the
Crystal Report. What modifications, if any, are required to the above
selection formula?
Although my professional career spans many technologies, I have never had
the pleasure to work with CR (at all!!). For some strange reason, I can't
quite seem to get anything useful out of Google with respect to parameter
passing. If some one knows where I can go, or what steps I need to take
to accomplish this, I would be grateful. I did not find any manual that
describes this, and I get "No help available" when I press F1 in the VB
development environment (with respect to the CR component).
Thank you for your time and assistance.
Saga
7. Passing parameters to a pass-through query running on a remote machine
8. Passing parameters to an Append query using Access VB
I am building a very simple quote builder, and need direction on dealing with the following... I need to pass a parameter to an append query. Not from a form, but from Access VB. The reason is that my Part Number, (my key for price lookups) is is derived based upon the user selecting a couple of resposnes on a form. All help is appreciated!