Click to See Complete Forum and Search --> : Stored procedures and parameters in reports


Dman
March 20th, 2001, 01:51 PM
I'm fairly new to VB and have had a problem for nearly two weeks trying to get a report (Crystal and a report created from the data report designer) to accept information from a stored procedure. I'm willing to use the data report designer's SQL option but can't get the SQL statement to accept any parameters. Any help in integrating a SQL Server stored procedure with crystal (or data report designer) or ANYTHING to get this reporting process done would be of great service to me. Even pointing me in the direction of a less than vague book about the subject would be great also. Thanks.

Dman
March 26th, 2001, 08:27 AM
The Answer is:

'Send the params via the data environment's command method
deReport.AllOut_Grouping gdatDate1, gdatDate2 rptOutAll.Show