The dataset Attribution looks like this exec pGetFullAttribAttribution @AttributionDate The output of this looks like this They want the report to look like this: lcerni

Let me try to explain what I am trying to do. (I am having so much trouble trying to post today.) This is how I have my layout setup. lcerni

But this is how the output looks: lcerni

Hi There Thanks for your posting. The easiest way to achieve this to create the dummy group inside your report and delete/hide that group while displaying. Please do the following Right click on your current group/details and Create parent group by putting expression something like this =iif(Fields!RowLabel.Value="Underhedge","B","A") This will create a group and place all your values other then Underhedge to group A and will put Underhedge under group B Now you can add total based on first group and all the total other then Underhedge will be sub total as group A and Underhedge as subtotal A One thing more you can hide the subtotal for Underhedge (Group B)which I thin you would like to for your put putting this expression on the "Sub Totals" row by right click on the row and go to row visibility and put this expression =iif(Fields!RowLabel.Value="Underhedge","true,false) =iif(Fields!RowLabel.Value="Underhedge","true,false) Now you can get the desired gross total based on that. I am putting screenshot for your help Many thanks Syed Qazafi Anjum

Hi There Thanks for your posting. The easiest way to achieve this to create the dummy group inside your report and delete/hide that group while displaying. Please do the following Right click on your current group/details and Create parent group by putting expression something like this =iif(Fields!RowLabel.Value="Underhedge","B","A") This will create a group and place all your values other then Underhedge to group A and will put Underhedge under group B Now you can add total based on first group and all the total other then Underhedge will be sub total as group A and Underhedge as subtotal A One thing more you can hide the subtotal for Underhedge (Group B)which I thin you would like to for your put putting this expression on the "Sub Totals" row by right click on the row and go to row visibility and put this expression =iif(Fields!RowLabel.Value="Underhedge","true,false) =iif(Fields!RowLabel.Value="Underhedge","true,false) Now you can get the desired gross total based on that. I am putting screenshot for your help Many thanks Syed Qazafi Anjum

So are you saying that I should add a column to the left of the Attribution column, call it Group1 and then in the text box under the Group1 label place =iif(Fields!RowLabel.Value="Underhedge","B","A") lcerni

Please, I do not understand your example. I do not understand how to create the dummy group inside my report and delete/hide that group while displaying.lcerni

Please, I do not understand your example. I do not understand how to create the dummy group inside my report and delete/hide that group while displaying.lcerni

Hi Icerni ! You need to create 2 row groups. 1) Create your first row group on "Group" Field. 2) Create your second row group on "rowLabel" Field. Click on your First group, click create Child Group on "rowLabel", your second row group will be child group of your first group "Group". 3) Click on your second group "rowLabel" , click Add Total -> After. Please let me know if this helps. Hopefully i have answered you correctly. Thanks, Hasham

Hi Icerni ! You need to create 2 row groups. 1) Create your first row group on "Group" Field. 2) Create your second row group on "rowLabel" Field. Click on your First group, click create Child Group on "rowLabel", your second row group will be child group of your first group "Group". 3) Click on your second group "rowLabel" , click Add Total -> After. Please let me know if this helps. Hopefully i have answered you correctly. Thanks, Hasham

I really don't understand. I wish I could send you the rdl. Or attach it to this post.lcerni

I really don't understand. I wish I could send you the rdl. Or attach it to this post.lcerni

ok lets send it to me at; Please mention your name in the Email. Thanks, Hasham Niaz

ok lets send it to me at; Please mention your name in the Email. Thanks, Hasham Niaz

It is sent. Thank you!!!!!!!!!!!!!!lcerni

It is sent. Thank you!!!!!!!!!!!!!!lcerni

Hi Icerni ! Okay, did you get the fixed rdl. Thanks, Hasham Niaz

Hi Icerni ! Okay, did you get the fixed rdl. Thanks, Hasham Niaz

Closing my thread as it has been now answered offline. I will try tomorrow to document everything so that everyone can learn what I have learned today. lcerni

Closing my thread as it has been now answered offline. I will try tomorrow to document everything so that everyone can learn what I have learned today. lcerni

This is how the table box is set up... This is how the rows are grouped...... Column Attribution, 2nd row the expression set up is =IIF(First(Fields!Group.Value)=2, "Underhedge", "Sub Results") Column Asset, here are how the expressions are set up........ =IIF(ISNOTHING(Fields!Asset.Value),"-",Fields!Asset.Value) =IIF(ISNOTHING(Sum(Fields!Asset.Value)), "-", Sum(Fields!Asset.Value)) =IIF(ISNOTHING(Sum(Fields!Asset.Value)), "-", Sum(Fields!Asset.Value)) Column Liab, here are how the expressions are set up........ =IIF(ISNOTHING(Fields!Liab.Value),"-",Fields!Liab.Value) =IIF(ISNOTHING(Sum(Fields!Liab.Value)), "-", Sum(Fields!Liab.Value)) =IIF(ISNOTHING(Sum(Fields!Liab.Value)), "-", Sum(Fields!Liab.Value)) Column Net, here are how the expressions are set up........ =IIF(ISNOTHING(Fields!Net.Value),"-",Fields!Net.Value) =IIF(ISNOTHING(Sum(Fields!Net.Value)), "-", Sum(Fields!Net.Value)) =IIF(ISNOTHING(Sum(Fields!Net.Value)), "-", Sum(Fields!Net.Value)) lcerni

This is how the table box is set up... This is how the rows are grouped...... Column Attribution, 2nd row the expression set up is =IIF(First(Fields!Group.Value)=2, "Underhedge", "Sub Results") Column Asset, here are how the expressions are set up........ =IIF(ISNOTHING(Fields!Asset.Value),"-",Fields!Asset.Value) =IIF(ISNOTHING(Sum(Fields!Asset.Value)), "-", Sum(Fields!Asset.Value)) =IIF(ISNOTHING(Sum(Fields!Asset.Value)), "-", Sum(Fields!Asset.Value)) Column Liab, here are how the expressions are set up........ =IIF(ISNOTHING(Fields!Liab.Value),"-",Fields!Liab.Value) =IIF(ISNOTHING(Sum(Fields!Liab.Value)), "-", Sum(Fields!Liab.Value)) =IIF(ISNOTHING(Sum(Fields!Liab.Value)), "-", Sum(Fields!Liab.Value)) Column Net, here are how the expressions are set up........ =IIF(ISNOTHING(Fields!Net.Value),"-",Fields!Net.Value) =IIF(ISNOTHING(Sum(Fields!Net.Value)), "-", Sum(Fields!Net.Value)) =IIF(ISNOTHING(Sum(Fields!Net.Value)), "-", Sum(Fields!Net.Value)) lcerni

It produces this report lcerni

It produces this report lcerni

To get the Gross Results this shade of blue you highlight the row and change the background color to pale turquoise. To get the Sub Results as pale green you highlight the row and for the background color you type in the expression =IIF(First(Fields!Group.Value)=2, "White", "PaleGreen") I want to thank Hasham so much for all his help. lcerni

To get the Gross Results this shade of blue you highlight the row and change the background color to pale turquoise. To get the Sub Results as pale green you highlight the row and for the background color you type in the expression =IIF(First(Fields!Group.Value)=2, "White", "PaleGreen") I want to thank Hasham so much for all his help. lcerni