Groups | Blog | Home
all groups > sql server reporting services > july 2004 >

sql server reporting services : Reference Sub-Report Value on Main Report


L Anthony Johnson
7/7/2004 4:29:14 PM
I have values on 2 Sub- Reports that I need to do reference on the main
report to do a particular calculation.

I was wondering if there is anyway that I can reference the sub-report
values from the main-report without making a specific call to the database
just to obtain the one value that I need.

--
L Anthony Johnson

Bruce Loehle-Conger
7/7/2004 4:43:03 PM
Sometimes what you can do is reference first( )of the dataset. Doesn't
always work it depends on where you are doing it.
=first(Fields!fieldname.Value,"datasetname")

of course, if you want something besides the first value then this will not
work for you.

Bruce L-C

[quoted text, click to view]

L Anthony Johnson
7/8/2004 10:14:49 AM


The Sub-Reports have their own datasets.

How would I reference the sub-reports dataset in the main report?

Landry

--
L Anthony Johnson
Newbie
[quoted text, click to view]

Kevin Buchanan
7/9/2004 12:23:01 PM
This is a good question, as I have the same problem. Does anyone know how
to access a data/value in a subreport?



[quoted text, click to view]

AddThis Social Bookmark Button