CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2012
Irfan
Irfan

Reputation: 695

How to Remove 「Total」 row in SSRS report?

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)+ "　"

Upvotes: 5

Views: 1711

Answers (2)

ice1e0
ice1e0

Reputation: 1016

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

enter image description here

Upvotes: 0

Irfan
Irfan

Reputation: 695

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.

Upvotes: 1

Related Questions