Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Add Date Parameter for Sub Report Post Reply Post New Topic
Author Message
thummel1
Senior Member
Senior Member
Avatar

Joined: 27 Apr 2012
Location: United States
Online Status: Offline
Posts: 140
Quote thummel1 Replybullet Topic: Add Date Parameter for Sub Report
    Posted: 07 Sep 2016 at 2:43am
I am using CR11.

I have a report that contains a subreport. The main report pulls deductions, and has a date range parameter based on "Check Date". The subreport contains voids that are pulled based on "Date Stamp". The main report needs to pull in only the voids when the "Date Stamp" falls between the "Check Dates" of the main report.

How to I accomplish this? Do I add another date range parameter into my main report meant to capture date stamps of my sub report? Currently, parameter prompts like this:
Enter Min Check Date
Enter Max Check Date
Should it be set up like this:
Enter Min Check Date
Enter Max Check Date
Enter Min Void Date Stamp
Enter Max Void Date Stamp

If that's a correct approach, steps on how to do that are appreciated!
"Press any key to continue. Where's the 'Any' Key?" ~Homer Simpson
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 07 Sep 2016 at 4:44am
Here is the approach I would take.  Pass the Enter Min Check Date and Enter Max Check Date to the sub-report.  Use those passed dates to filter the Date Stamp in the sub-report (it is best that you set up parameters in the sub-report with the same names).   I hope this helps.
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.015 seconds.