Passing report value to Stored Procedure parameter.

[Zarobi]

Crystal Reports 9.0.

I am writing a month end summary report for accounts with activity during the month of February. My database is SQL ODBC. The base report includes an account ID with the account's physical information (address, contact, phone, etc). The month end summary figures have been calculated for me by our IT staff in a SQL Stored Procedure.

I need to pass each of the account IDs in my report to the Stored Procedure for it to produce the numbers for my report. I thought I might be able to store the ID as a shared variable and pass that to a sub-report with the stored procedure. My problem is, I don't know how to tell Crystal to use my variable for the stored procedure's parameter.

Or I could be going about this all wrong.

 

[bdreed35]

I would look at moving the SQL that your report is generating into a Stored Procedure. You could then call the SP that your IT staff created and join the recordsets there. This could allow for one recordset to be returned that would include all your data, and eliminate the need fo that subreport.

~Brian

 

[IdoMillet]

See:

http://support.businessobjects.com/library/kbase/articles/c2002084.asp

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com