Passing Parameters to an RPT from VB

[jonnymadill]

Hi,

I'm still quite new to Crystal Reports, so my question has probably been posted loads of times.

I want to call an RPT file with some input parameters using VB 6 and I'm not sure how to go about this. I'm connecting to an ORACLE database, and the RPT is connected to a stored procedure.

Any help would be great.

Thanks again,
Jonny.

 

[synapsevampire]

Try:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/apps_rdc.pdf

Search for: Parameter Fields

This is CR version dependent, which you hadn't shared.

-k

 

[jonnymadill]

Thanks for that. I'll have a look now.

I'm using Crystal Reports 8.5 and VB 6. I have to come up with a way of generating a list of values from an ORACLE database and then passing these into a Crystal Report. I have written the stored procedures and created the RPT file for this, but the report has to be run loads of times with these params which isnt really practical for the user to sit and do.

And I've never used VB before!

Thanks again.

 

[jonnymadill]

I now have a new problem! I have managed to connect to the database and pass parameters to the report, but the RPT contains a subreport which also has parameters. These parameters are linked to fields within the 'housing' RPT, and I was hoping that once the first RPT was invoked it would pass these values down into the subreport. Unfortuneatly this doesnt happen and the subreport appears blank.

Any ideas?

I cant use the 'Subreport' object in VB as some of the parameter values are determined by the 'housing' RPT.

 

[SurfingGecko]

You are going to need to create a code loop to iterate thorugh your report sections and identify if there are any subreports and then log this on and pass in any parameters.

This will be fun for ya. ;-)

Have a look in the Developer help file on your system for some syntax on how to do this. You coudl also have a look at some of the VB samples that ship with CR from some code.

Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease