Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Understanding RDLC Report grouping /Layout

(1) ShareShare
ReportReport
Posted on by 47

Hello Business Central Community,

We are working on developing a custom RDLC report and have encountered several issues that we need help with. Below is the basic outline of our report requirements and the challenges we are facing:

  1. Use of Table for RDLC Reports: We typically use tables to create RDLC reports, but this approach is not sufficient for our current requirements.

  2. Opening and Closing Balances: We need to display the opening balance for each name, followed by the related entries between the posting dates, and finally, the ending balance. The opening balance and closing balance for each entry should be shown only once.

  3. Grouping in Reports: We need to add groups to the report to accommodate this kind of requirement, but we are struggling with how to implement this.

  4. Suggested RDLC Report Layout: We are seeking suggestions for an appropriate RDLC report layout that meets our needs.

    here is the basic outline of the report 

    For this kind of requirement In RDLC which will be efficient List, Table  



Technical Issue with Balances: When we attempt to add the opening balance, it does not work as expected. We have tried using captions in text boxes and adding data fields in a list, but we are still unable to display the opening balance correctly.

here how it looks 
 



Any tips for creating complex RDLC reports in Business Central.



We have gone through the Microsoft learn doc wasn't that helpful.

 
  • RK-29050523-0 Profile Picture
    47 on at
    Understanding RDLC Report grouping /Layout
    CU04060602-1 on 04 Jun 2024 at 11:44:05
     
     
    Understanding RDLC Report grouping /Layout


    Hi Tanya, 

    he report layout to display the opening balance, followed by the related entries and their closing balance, and then the rest of the entries. However, when we include the opening balance below and group it by name, the report shows all the opening balances followed by the related entries, which is not our intended format.

    Our goal is to display the opening balance for a particular entry, then its related entries and their closing balance, followed by the rest of the entries. here is the RDLC with grouping we done but its not working as expected 


    we have gone through the base reports Customer detail trail balance have similar but when the RDLC looks complex its grouped by PageGroupNo we implemented it but still not working 

    give me suggestions how make a report Most dev used when to make rdlc for business central 

  • CU04060602-1 Profile Picture
    2 on at
    Understanding RDLC Report grouping /Layout


    Hi Tanya, 

    he report layout to display the opening balance, followed by the related entries and their closing balance, and then the rest of the entries. However, when we include the opening balance below and group it by name, the report shows all the opening balances followed by the related entries, which is not our intended format.

    Our goal is to display the opening balance for a particular entry, then its related entries and their closing balance, followed by the rest of the entries. here is the RDLC with grouping we done but its not working as expected 


    we have gone through the base reports Customer detail trail balance have similar but when the RDLC looks complex its grouped by PageGroupNo we implemented it but still not working 

    give me suggestions how make a report Most dev used when to make rdlc for business central 

  • Suggested answer
    YUN ZHU Profile Picture
    85,629 Super User 2025 Season 1 on at
    Understanding RDLC Report grouping /Layout
    I think it's good practice to refer to standard layout files.
    In addition, since your report looks like a statistical report, you can consider Excel Layout, or In-client Analysis mode may be much simpler.
     
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    tanya07 Profile Picture
    1,636 on at
    Understanding RDLC Report grouping /Layout
    Hello,
     
    can you show us the grouping you have used ?
     
    Regards,
    Tanya Kharbanda
  • Gerardo Rentería García Profile Picture
    20,640 Most Valuable Professional on at
    Understanding RDLC Report grouping /Layout
    Hi
    Around the topics you have mentioned, I share some links with you.
    BR
    GR

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans