all groups > sql server reporting services > may 2007 >
You're in the

sql server reporting services

group:

Referring to subreport fields from main (container) report....


Referring to subreport fields from main (container) report.... mattyseltz
5/7/2007 11:24:00 AM
sql server reporting services:
All--
Is it possible, from within the context of a main report that contains
several subreports, to write code in the main report that refers to field
values within one or more of the contained subreports? (I would like to
display totals in the main report that are sums of quantities displayed in
several subreports.)

TIA,

mattyseltz in Queens, NY
Re: Referring to subreport fields from main (container) report.... EMartinez
5/7/2007 6:31:55 PM
On May 7, 1:24 pm, mattyseltz <mattyse...@discussions.microsoft.com>
[quoted text, click to view]


The closest you can get to that is to include the same datasets in the
main report that exist in the subreports and use an expression similar
to the following:
=Sum(Fields!Quantity.Value, "SameDataSetAsUsedInSubReport")
Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant
Re: Referring to subreport fields from main (container) report.... mattyseltz
5/8/2007 6:16:01 AM
Hi, Enrique,
Thanks for your reply. I see that you answered a similar question on
April 18, sorry to make you repeat yourself.

Best,

Matt

[quoted text, click to view]
Re: Referring to subreport fields from main (container) report.... EMartinez
5/8/2007 10:51:55 AM
On May 8, 8:16 am, mattyseltz <mattyse...@discussions.microsoft.com>
[quoted text, click to view]


You're welcome. No problem. Glad I could be of assistance.

Regards,

Enrique Martinez
Sr. Software Consultant
AddThis Social Bookmark Button