Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure Parameters and Subreports

Status
Not open for further replies.

jrhine

Programmer
Feb 15, 2001
3
US
I've created a Crystal Report in VB using a stored procedure as the datasource. This stored procedure requires two input parameters and I've been able to successfully provide these parameters to the report from the user interface.

MY PROBLEM, occurs when I try to add a subreport that ALSO contains parameters (different parameters) that I need to supply from the user interface. Each attempt has resulted in the main report returning data, but the subreports coming back blank.

In the main report, I'm providing the parameters to the stored procedure during the actual stored procedure call.

Example of my main report's datasource call:
Code:
deDataEnvironment.dbo_StoredProcedure
Code:
Param1, Param2
Code:
curReport.Database.SetDataSource = deDataEnvironment.rsdbo_StoredProcedure
Any thoughts on how I can pass parameters to the subreports BESIDES the "subreport linked fields?"

Thanks,
Jeff Rhine
Houston, TX.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top