PDA

Click to See Complete Forum and Search --> : [Resolved]Pass a parameter to subreport


naruponk
Feb 9th, 2005, 02:48 AM
Hi all,

My Report1 is composed by subreport1 and report2.
I need to pass a parameter to subreport1 and subreport2,
How can i pass a parameter to a subreport? :sick:


Thanks for all help

RobDog888
Feb 9th, 2005, 08:05 PM
You need to create a parameter at the main report level. Then link the parameter to the subreport
by reimporting the sub report. This will allow you to pass a parameter to the report which
will inturn go to the sub report.

:thumb:

naruponk
Feb 10th, 2005, 06:49 AM
Thanks RobDog888 :thumb:
Right now i can solved this problem, do you know how to suppress
a blank sub-report?

I have checked "suppress blank report" but the report shows
a blank page on 2nd page how to assign the report to show only 1 page?

RobDog888
Feb 10th, 2005, 12:50 PM
You can add your subreport to its own detail section (create a second) and add code to the
selection expert of the subreports detail section so its visibility will be false if there are no records for it,
else leave it visible.

naruponk
Feb 11th, 2005, 08:36 PM
Thanks man! :bigyello: :thumb:

RobDog888
Feb 11th, 2005, 09:14 PM
No prob. :thumb: I just wanted to mention that you could create a duplicate section where
ever your subreport is currently located. Then do the eval to see if you want
to suppress it or not. There is a "TotalPageCount" under Print State section.

naruponk
Feb 12th, 2005, 01:05 AM
Thanks for your help :wave: