Stored Procedure

[sinclairgf]

I am new to crystal reports and was wondering how you use a stored procedure as a data source to use with crystal reports. I am writing my code in ASP. I want to allow users to create and modify reports based off stored procedures I have previously written. Using the RAS server so I can allow the users to create the reports using the web based application. Going to modify the sample application.

Thanks,
George

 

[FVTrainer]

In Crystal Reports, go to File | Options | Database and make sure that the Show Stored Procedures option is checked. Then, when you log onto a datasource in Crystal, you'll see the stored procedures listed along with tables and views. You should be able to select a stored procedure as a datasource at that point. Stored procedure parameters will show up in Crystal as if they were Crystal parameters (although sp param are, I believe, all nullable, as opposed to Crystal params which for the most part aren't). Just one other comment: don't use more than one sp as a datasource; you'll get incredibly bad performance if you do (and it doesn't make logical sense to do so).