Finance | Project Operations, Human Resources, ...

Add group by in ssrs report expression

(1) Share

Report

Posted on by Menna Allah Ahmed

163

I have 4 lines of this job 2 lines in position and 2 lines in customize table , so now I am creating ssrs report and I added group by job so I get in report 2 lines also in this table I have contarct column and I added 10 , 70 value on it .

I need to get sum of this contract as 80 not 160 How can I do it ? I need column to see only rows in group not all rows

I tried this way but I got an error

All responses (3)

Answers (0)

Saud Jalil 34 on at

Like (0)

Report

Add group by in ssrs report expression

You should group your data in Data Provider class,

in X++ you can add group by after Where clause
Suggested answer

Mohit Rampal 12,558 Moderator on at

Like (0)

Report

Add group by in ssrs report expression

Hi Menna, Since its showing double value, the easy work around would be to display half of sum value by dividing by 2. Try below formula in SSRS textbox expression. Otherwise,as Girish mentioned you can handle it in code level as well

SUM(MAX(Fields!ContractNumber.Value),"JobID")/2

Thanks,

Mohit
Suggested answer

Community member 36 on at

Like (0)

Report

Add group by in ssrs report expression

Hi Menna,

Instead of changing it in report design - You can control it from the code (Dp class) - Change report table type as regular - Add validation to restrict duplicate records before inserting into a report table.

At starting of the processReport method use delete_from table to delete the previous records.

Thanks,

Girish S.