How can I carry a value over from a subreport to a main report?
If I have a total in a sub report, I want to use that total in expression on the main report.
Any ideas?
You can't. You can only pass parameters from the main report to the subreport.|||IS there any way around this? some other method perhaps?|||Here is something you can try. Create a NET assembly referenced by both reports (master and subreport). In the assembly, define a static collection to store values on per user and report basis (so users can't overwrite each other values), e.g. collection key consists of the user name (User!UserID) and report name (Globals!ReportName(. Next, try adding/changing values from the subreport and see if the master can get them. SSRS 2005 changed the order in which expressions are evaluated so I don't know what will happen but you asked for another way...
If you decide to try this, please share the results here.
No comments:
Post a Comment