How to use the sum the value of 2 totals in different table (Reporting Services)?
- by dewacorp.alliances
Hi there
In report design, I have 2 tables (Current and Proposed) the structure like this:
Current
Parameter | Value | Rate | Total
Value ...
Proposed
Parameter | Value | Rate | Total
Value ...
Each bottom of the table (Table Footer), I have something called: "Total: " which is a sum of Total field. I called these textboxes are txtbxCurrent and txtbxProposed and the format is in currency already.
This thing is running well.
But now I need to get a total of these txtbxCurrent and txtbxProposed. How do I do this? Can I take the value of this or not?
BTW .. I am using Ms SQL Server 2005 (ReportViewer - client)
Also here my dataset looks like:
RecID | Type | Parameter | Value | Rate | Total
1, CURRENT, 'Param1', 100, 0.1, 10
1, CURRENT, 'Param2', 200, 0.2, 10
1, PROPOSED, 'Param1', 100, 0.2, 20
1, PROPOSED, 'Param2', 200, 0.2, 20
Thanks
