Adding Totals from SubReports

Hello...
Does anyone know why this expression is not working?
=Reports![Sub Lay Out for Approval].Controls!TotalJobs
+ Reports!Backlog!Controls!TotalJobs
Here is the error I am getting... It is asking me to declare an object
which is part of the object model right?
The value expression for the textbox â'textbox67â' contains an error:
[BC30451] Name 'Reports' is not declared.
--
Thank You, LeoAs indicated by Chris Hays in this previous related posting, returning
values from a subreport (or accessing values inside the subreport) is not
supported:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=768c8ca9-04e7-4949-8300-c7666c5a6803&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"TrussworksLeo" <Leo@.noemail.noemail> wrote in message
news:9E37EE65-4DD3-4F2B-911A-E176ADCA32FB@.microsoft.com...
> Hello...
> Does anyone know why this expression is not working?
> =Reports![Sub Lay Out for Approval].Controls!TotalJobs
> + Reports!Backlog!Controls!TotalJobs
> Here is the error I am getting... It is asking me to declare an object
> which is part of the object model right?
> The value expression for the textbox 'textbox67' contains an error:
> [BC30451] Name 'Reports' is not declared.
> --
> Thank You, Leo

adding subreports to master report at runtime

Hi guys,

Is it possible at runtime to decide what subreports you want in your master report. Is this possible in RS?. Many Thanks in advance.

It is possible to add or remove remove reports from reporting services at runtime. Though you can have all of them in your main report and controls its visibility using expressions.

Shyam

|||Many thanks for your response, but is there a way of dynamically adding multiple subreports to a master report without placing them all in a master and controlling visibility?|||

There was a typo in my earlier message. I actually meant that it is NOT possible to add or remove subreports from a main report at runtime. I'm afraid I may have to repeat it now.

Shyam

|||

Ok thanks, setting the visibilty does work, and is a current solution to the problem for now. Maybe the next version can deal with this. Many thanks for your response.

Kenny

|||Can you please mark this post as answered? Just click on Mark as Answer buttonsql