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

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Community member 36 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Saud Jalil 34 on at

Like (0)

Report
Copy link

Link copied!

You should group your data in Data Provider class,

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

Was this reply helpful? Yes No