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:
Use of Table for RDLC Reports: We typically use tables to create RDLC reports, but this approach is not sufficient for our current requirements.
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.
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.
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.