Monday, March 12, 2012

How to call subreports from a main report

HI there,
I want to know if someone know how to call subreports that depends from one
main report.
Could you help me?
Regards,
Oscar.On Nov 9, 10:48 am, Remigio Oscar Iglesias - Argentina
<RemigioOscarIglesiasArgent...@.discussions.microsoft.com> wrote:
> I want to know if someone know how to call subreports that depends from one
> main report.
Create a Main Report (named "Report A").
Create a second report (the Subreport named "Report B") that receives
a Parameter. Use the Parameter in the Data query.
Add a Subreport object to the Main Report, and open the object's
Property window. Set the object's "Subreport" Property to the name of
the Sub Report (Report B). Go to the Parameters Tab. Set Report B's
Parameter to a value calculated in Report A. Now query that is made
in Report B depends on data provided in Report A.
-- Scott|||Note that your subreport is just a regular report you are embedding into
your main report. The subreport should be designed with parameters. Test the
subreport fully and then Drag and drop your subreport onto the main report.
Right mouse click on subreport, parameters. Map the parameter of the
subreport to whatever you want from the main report (it can be a field if
you are doing something like a master-detail report, you can base it on the
parameters for the main report).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Remigio Oscar Iglesias - Argentina"
<RemigioOscarIglesiasArgentina@.discussions.microsoft.com> wrote in message
news:BDD3CE41-8B8B-48BD-92A1-0C0BA75FE5EB@.microsoft.com...
> HI there,
> I want to know if someone know how to call subreports that depends from
> one
> main report.
> Could you help me?
> Regards,
> Oscar.
>

No comments:

Post a Comment