Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Understanding RDLC Report grouping /Layout

Posted on by 8

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.

 
Categories:
  • RK-29050523-0 Profile Picture
    RK-29050523-0 8 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
    CU04060602-1 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
    YUN ZHU 64,237 Super User 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
    tanya07 1,535 on at
    Understanding RDLC Report grouping /Layout
    Hello,
     
    can you show us the grouping you have used ?
     
    Regards,
    Tanya Kharbanda
  • gdrenteria Profile Picture
    gdrenteria 5,108 Super User on at
    Understanding RDLC Report grouping /Layout
    Hi
    Around the topics you have mentioned, I share some links with you.
    BR
    GR

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans