How to Remove 「Total」 row in SSRS report?

5
votes

I am new to SSRS.

In report, I have One table layout result where its first row (there is a bug in total) and last row is having total of all the fields. (Like shown in below image)

enter image description here

Given 「Total」 in first row, which I want to remove from the Report simply. I have its source file and I tried already so many ways but I am not getting its solution.

Edited

Design View of the same is here

enter image description here

Row Groups Panel is looking like:

enter image description here

Group Properties: enter image description here

Expression 1(top left most):

=Iif(Fields!LineCaption.Value="","TOTAL", Fields!DispOrder.Value & ". " & Fields!LineName.Value)

Expression 2(below of top left):

=Iif(Fields!LineCaption.Value="","　", Fields!AddupInfo.Value)+ "　"
2
sql-serverreporting-servicesssrs-2012
Show the design of the report , not the preview! - PrathapG
@PrathapG: Yes, I have edited question. Please have a look - Irfan
Can you post your grouping panels too, It's in the bottom panel - PrathapG
What are the properties of your group? - Larnu
For a Workaround, You can right click the required row and then go the Row visibility and then select Hide and then Click OK, Design is already in he report. But once it run user no longer cannot see that row. May be this will help you - Anusha Subashini

2 Answers

1
votes

Thank you to All Commentators for commenting and giving your precious time in my problem with suggestions.

But I have found my own way solution. By creating condition on Row_Group Visibility option while it loads the data from server.

As「Total」field was getting calculated in Row_Group only. So in Visibility option, I checked for first Row that "If first row is not Line_Name(My field name) then Hide that Row". Maybe this is not the accurate answer but this was the only option for me to add.

0
votes

You can do it via the context menu in the matrix view, not in the "Row Group" are:

enter image description here