Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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)+ " "
like image 854
Irfan Avatar asked Nov 07 '22 23:11

Irfan


1 Answers

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.

like image 194
Irfan Avatar answered Nov 12 '22 14:11

Irfan