Quering the same date in a Report and its sub reports 2

[francis2299]

Hi All,

I created a report and in it I included sub reports which I put Parameters which require to query From To Date in all reports. But when I try to print a report it prompt to me to put From date and To date for all report and its sub-reports. i.e. I am required to put dates in 3 times. Is there a way I can just put a parameter to query in a report and get a result from its sub-reports by just the same date?

Your help is highly appreciated.

Warm Regards,
Francis

 

[ettienne]

Yes, you pass the main report's parameters to the subreports.

Sage 300 Certified Consultant

 

[francis2299]

Thanks ettienne,

Can you give me the hint how to do it please!

Regards
Francis

 

[Jay Converse]

1. Add the parameter to the subreport
2. Add the parameter to the main report
3. Link them

 

[francis2299]

Thank you tuba, I tried but still the same problem. Can you direct me how to do it!

Thanks once again your help is highly appreciated.
Francis

 

[ettienne]

http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9894

https://scn.sap.com/thread/2131933

http://www.bofocus.com/how-to-pass-a-date-range-to-a-subreport-using-a-parameter/

Just google it, there are many examples.

Sage 300 Certified Consultant

 

[francis2299]

Thank you guys it now works perfectly.

Regards
Francis