Parameters at runtime...

[markinro]

I need to use a stored procedure as a datasource for a report. The sp has 3 parameters and I set these values when I select the report at design-time. My question: How can I pass these parameters at run-time ? The stored procedure is not static. If it was, I could use a view.

 

[FVTrainer]

Assuming a recent version of Crystal, the parameters should be passed in the same way that you pass Crystal parameters. Which version of Crystal are you using? How are you deploying your report (please be as specific as possible; i.e., if you are deploying on the web, describe the methodology you are using; if vb/c/delphi, describe which method you are using to access the report.)? Have you ever passed parm values to Crystal at runtime before?

 

[markinro]

This is a third party package (desktop) where I can create reports and supply the software with the report file and criteria. I don't know what they used to write the software (probably vb or c)

Never tried to pass parameters at runtime. Crystal would prompt me at design-time. I am using crystal 9.

 

[FVTrainer]

Ok, you're asking how to pass stored procedures at runtime, but you don't have control over how it is deployed. Will the 3rd-Party package allow you to create a Crystal report with Crystal Parameters? If it does, then it should allow you to create a Crystal report with stored procedure parameters. For all intents and purposes, they are the same.

If the 3rd-Party package doesn't have a way for you to indicate the paramters, then most likely the Crystal runtime engine will ask you for the parameter values when the 3rd-Party package launches the report.