I am converting a few reports from Crystal reports to RDL. I need one of my reports in SQL Server 2008 to do the following:
- Pass a value to a sub report (zero)
- the sub report evaluates data in the sub report and changes the value (example from 0 to 3)
- the value (3) is passed back to the main report
- the main report totals up the sum of what is passed back from all of the subreports and prints the total in a group (21)
Is there a way i can do this in RDL? Any help is appreciated...I'm a bit of a hack!