Reporting Services: Two Tables One Sum

Posted by Neomoon on Stack Overflow See other posts from Stack Overflow or by Neomoon
Published on 2009-06-18T16:35:22Z Indexed on 2010/03/12 5:07 UTC
Read the original article Hit count: 542

Filed under:

My report is as follows:

One table provides financial information with sums at the group footer (Grouping is called "StockTable_Shipped"). The group is controlled by a boolean value (1=shows shipped data, 0 = shows received data)

The second table is a variance report for data that has been shipped (boolean value of 1) and has a sum at the bottom of the table.

My ultimate goal is to take the sum from table1 where shipped=1 and subtract it from the variance sum from table2.

This will be placed in a textbox at the bottom of the report.

I understand if this sounds confusing but I would be more then happy to provide more information.

© Stack Overflow or respective owner

Related posts about ssrs

Related posts about reporting-services