How to use the sum the value of 2 totals in different table (Reporting Services)?

Posted by dewacorp.alliances on Stack Overflow See other posts from Stack Overflow or by dewacorp.alliances
Published on 2010-06-03T03:57:11Z Indexed on 2010/06/03 4:04 UTC
Read the original article Hit count: 143

Filed under:

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

© Stack Overflow or respective owner

Related posts about reporting-services