Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Use main report parameter in sp of subreport Post Reply Post New Topic
Author Message
kvwielink
Newbie
Newbie


Joined: 09 Oct 2008
Location: Thailand
Online Status: Offline
Posts: 8
Quote kvwielink Replybullet Topic: Use main report parameter in sp of subreport
     Posted: 09 Oct 2008 at 1:33am
Hi All,

I've got a problem with a subreport. I created a main report that retrieves data from a stored procedure with 2 parameters: company_code and a date. SP selects records for that company with date <= parameter date.
One of the fields retrieved in the main report is a batch number in the detail section. I would like to use this batch number, pass it to a subreport which then retrieves details for each batch. The subreport also retrieves its data from a second stored procedure, and the batch number from the main report should be one of the input parameters of the stored procedure.
Can anyone explain to me how to do this? Can provide more info if necessary.
Thanks.

Rgds,

KvW

IP IP Logged
kvwielink
Newbie
Newbie


Joined: 09 Oct 2008
Location: Thailand
Online Status: Offline
Posts: 8
Quote kvwielink Replybullet Posted: 09 Oct 2008 at 3:27am
Never mind, figured it out already.
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