Display grand total only once in a matrix report

0
votes

I have a matrix report designed as shown in below image

enter image description here

Tablix1 with Product Row Grouping:

enter image description here

Tablix2 with SubTotal and GrandTotal:

enter image description here

I added a matrix with Column grouping CategoryId and 2 tablixes in the matrix. One tablix has the Product Row grouping and the other Tablix to display Sub Total and Grand Total.

SubTotal should be displayed under each Category but the GrandTotal should be displayed only once. But, as per my design GrandTotal is showing under each category. Is there a solution to hide the Grandtotal keeping only the first column set? or any other alternate to fix the issue?

Current Result:

  1. Grand Total is shown under each category.
  2. Border Lines in the report is not displaying for the rows which does not have any data.

enter image description here Expected Result:

  1. Grand Total should be displayed only once in the report.
  2. Border lines should be covered even if there is no data in the row.

enter image description here

Note: CategoryId is used only in the grouping and not displayed in the report.

Thank you in Advance!

1
matrixreporting-servicesssrs-2012

1 Answers

0
votes

As I can't see the full design I'm not sure if there is a way to simplify it, I feel like the design is not quite right...

However, you should be able to set the hidden property of the textbox to something like

=Fields!CategoryID.Value = FIRST(Fields!CategoryID.Value, "myDataset")

Change myDataset to be the name of you actual dataset, This is case sensitive and must be enclosed in quotes.