Hi Mark, Based on your information, I think you could utilize the tablix data region in reporting service to achieve this similar layout, sometime you might need to merge several tablixes into one tablix. For more information about Tablix Data Regions, please see: http://msdn.microsoft.com/en-us/library/bb934258(v=SQL.100).aspx Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

I am tying to create a Profit and Loss report with SSRS 2008 and I need some advice. I started creatng the report and I have all the data working fine. I am trying to add rows with values that are calculated based on various other rows in the report. This is where I am having problems. To show what I am trying to achieve, I exported the report to Excel and manually added the rows in yellow. These are the formulas that I need. http://img15.imageshack.us/i/sampleprofitandlossrepo.png/ So, I am just looking for some ideas on 1) can I even do this kind of report in SSRS, and 2) some general ideas on how to do it. Any ideas would be greatly appreciated. Thanks, Mark