Can i set a Crystal Parameter to be the Paramter of a storedprc which is the source
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
Re: Can i set a Crystal Parameter to be the Paramter of a storedprc which is the source
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.