Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Other Development Tools
 Using SQL stored procs with Crystal Reports

Author  Topic 

vivianand
Starting Member

1 Post

Posted - 2004-06-22 : 11:01:49
I am trying to used a stored proc that has an input parameter for a Crystal Reports sub-report. I am having difficulty figuring out how to pass the input parameter
Thanks

nr
SQLTeam MVY

12543 Posts

Posted - 2004-06-22 : 12:26:57
When you add the sp to the report it will ask for sample parameters to get the data.
How you assign them at run time depends on how you rn the report.
When you do a refresh it wil prompt or if you run it from VB you can use the object model to set the params.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -