Gross multiple lines into one line in SSRS report

(0) Share

Report

Posted on by Community Member

I want to combine multiple data row into a one row similar to display on the report. My mean is not that data row group by group, but mulitple data row into one row and add up the number of data fields together.

7827.12_2D00_8_2D00_2016-3_2D00_06_2D00_02-PM.png

Become:

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Mea_ 60,284 on at

Like (1)

Report

Hi Nguyen Van Tai ,

You have 2 options here:

1) If you have data provider class in AX you can group data there and send to SSRS already grouped rows.

2) Add group by expression to "Details" group and use sum() function for quantities you want to sum.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

HI ievgen,

How can I group data in DP class?

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report

It really depends from what you have there. If you have while select there you can group it msdn.microsoft.com/.../aa848113.aspx

If you have query there you can group it as well msdn.microsoft.com/.../hh745337.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you so much.

Was this reply helpful? Yes No