Small and medium business | Business Central, N...

SSRS report only showing first row of record

(0) Share

Report

Posted on by jdrco

481

On Excel this is what the data looks like:

But when I try to display this as a table using Report Builder, it only shows the first row of data:

Here is what my RDL report design looks like:

I want to display all rows of data. I am grouping by BillToCustomerPostalCode since that is what should remain constant for each row. What am I doing wrong here?

Thanks,
J

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, This seems to be a Group problem. Hope the followings helps.

https://archerpoint.com/grouping-rdlc-report-microsoft-dynamics-nav-or-business-central/

https://www.youtube.com/watch?v=bZLkjQwQlPw

And you can also refer to the RDLC file of standard reports.

[View:/cfs-file/__key/communityserver-discussions-components-files/758/Sales-_2D00_-Confirmation.rdl:320:240]

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

This is doing because you had put your Text into Group Rows Cell, not Details rows cell, and check your grouping as well.

Was this reply helpful? Yes No