PDA

Click to See Complete Forum and Search --> : Can i set a Crystal Parameter to be the Paramter of a storedprc which is the source


ragstta
Mar 9th, 2007, 10:12 AM
hi all:wave:

Can i set a Crystal Parameter to be the Paramter of a storedprc which is the data source?

Using a SQL Server Stored Procedure to populate a crystal report. the stored prc requires parameters. Im running the crystal report via VB automation.. how can i tell crsytal to use parameters im passing to it as the parameters for the storedprc call??

thanks

brucevde
Mar 9th, 2007, 04:02 PM
It should be automatic. Crystal creates a report parameter for every parameter in the sproc, at least it does for me... The parameter's value is then automatically passed to the sproc when the report executes.