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

SSRS report only showing first row of record

(0) Share

Report

Posted on by jdrco

485

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)

Sort by

Suggested answer

YUN ZHU 101,126 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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