Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Business Central forum
Under review by Community Managers

Under review

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

Opening Balance in RDLC report

Posted on by
Hi 
We are trying to make a custom report to show the opening balance at the top and then related entries just like in  Customer - Detail Trial Bal.

here I inserted a table and added the dataset fields by 
1. inserting table later I inserted a row below and added the No and Opening balance 
2. Clicked on Opening balance and added Row group on no (Adjacent below) [Here have a look in RDLC]




Here is the layout 
this is how I made grouping
1. Click on the Opening balance and Add a Row Group  against the Name
This is the result, it gives all entry balance and next their entries 



Here are my requirements
1. Need to show the opening balance at the top and follow by related entries [like in Customer detail trail balance ]
2. Grouping that fulfills my requirment 
3. New page for the customer (when this boolean is true in the request page in the report each customer  a new page )

thanks.. :)

 

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,983 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans