Shared Variable in crystal report and filter data in subreport based on this value

[DV1983]

Hi All,
In the crystal report that I have designed, has a main report and a subreport.
A date value from main report has to be passed to the subreport and based on that date, the records should be filtered.
What I have done is created a shared variable for this date value in the main report,like below. The value is pulled to report and is showing the correct value in main report.

WhilePrintingRecords;
shared datevar shdtvlu;
shdtvlu:={@dtvlu1};

Same has been created in subreport and is showing the date value, correctly,in the subreport.

shared datevar shdtvlu;
shdtvlu;

Now the result in the subreport ,should be filtered ,based on this value.
Records should be selected , which are less than this date value.

Can anyone please guide me on this regard?

Thanks to all the helping hands out there..

[jggtz]

Try using that shared variable in the "RecordSelectionFormula" of the subreport

[DV1983]

Try using that shared variable in the "RecordSelectionFormula" of the subreport

Hi JG,
Thanks for the help.
In Subreport the shared variable is not shown in the record selection formula.

[jggtz]

Well, then it's time to use Linked variables
--- Linked Variables are easier than shared variables to select records
--- because shared variables only work to select records in a subreport in WhilePrintingRecords

see next link
http://scn.sap.com/people/ashish.bam...l-reports-2008