Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Passing stored prod parameters to sub reports Post Reply Post New Topic
Author Message
pqtiii
Newbie
Newbie


Joined: 22 May 2012
Online Status: Offline
Posts: 2
Quote pqtiii Replybullet Topic: Passing stored prod parameters to sub reports
     Posted: 22 May 2012 at 1:25pm
I'm using XI, trying to pass the same parameters that drive the Stored Procedure in the main to two other sub reports that use other Stored Procedures, but filter by same parameters.
 
1. @startd (start index position for a date/shift)
2. @endd (end index position for a date/shift)
3. @whichoper (operator id)
 
I envision only entering the parameters once to drive the two other sub reports.
 
How can this be done?
 
Thanks
pt
 
 
IP IP Logged
Gurbs
Senior Member
Senior Member
Avatar

Joined: 16 Feb 2012
Location: Ireland
Online Status: Offline
Posts: 216
Quote Gurbs Replybullet Posted: 22 May 2012 at 11:12pm
What you could do, is create the parameters in the main report and the subreport, and just link the subreport on these parameters. And, instead of selecting the standard parameter ({?pm_start_date} out of the top of my head), just select the parameter {Startd}
IP IP Logged
pqtiii
Newbie
Newbie


Joined: 22 May 2012
Online Status: Offline
Posts: 2
Quote pqtiii Replybullet Posted: 23 May 2012 at 4:32am
That worked!  Thank you
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum