Introduction To Report In D365 Business Central!
Overview :
Reports in Dynamics 365 Business Central, is a document that presents information in an organized format. Reports are used to print or display information from database, for example-Sales Invoices. It provides information on various aspects of business and is easy and efficient and play a major role in streamlining the progress of business.
So how to develop a report?
Create a report object and design a dataset, Datasets decide which record from the Dynamic 365 Business Central database used to generate report output.
Types of Report Layouts:
- Word Layout
- Report Definition Language (RDL) Layout
- Excel Layout
Request Page:
Request page runs before the report starts to execute, which in turn allows the end-user to specify filters for a report.
Types of Report:
- Simple list report
- Grouping list report
- Document report
- Document with Header/Footer report
- Process only report
- Chart report
- Fixed format report or Pre-printed report
- Barcode and QR code report
Report Triggers:
OnInitreport: This trigger runs before the request page in addition it initialize the global variable.
OnPreReport: This trigger runs after the execution of request page before the report runs.
OnPostReport: This trigger runs after all the data item processed, in a simple way that this trigger runs at last.
DataItem Triggers:
OnPreDataItem: This trigger filters the value before the dataitem is processed.
OnAfterGetRecord: For each and every record this will trigger, until reaches to the final record this trigger will run multiple times.
OnPostDataItem: This trigger run after the last record in data item but before the OnPostReport.
SetData and GetData: To change the Header information according to the body part SetData and GetData is used.
Steps:
- Change the Code in Report Properties
- Create List
- Inside list insert new table
- Right click one of the textbox under visibility section show or hide add SetData code
Ex: Code.SetData(Cstr(Field!field_name.Value), 1)
Here 1 indicates first group
- In the Header Section inside the textbox write GetData by passing parameters under the Expression section.
Ex: Code.GetData(1,1)
Here first number indicates the filed value, and second number indicates the group value.
For more details kindly visit our LinkedIn page:
https://www.linkedin.com/company/allgrow-technologies-pvt-ltd/mycompany/
or you can write us on contact@allgrowtech.com
DO YOU WANT TO TURN YOUR IDEA INTO REALITY
Services we offer
Consulting Services
Software and Web Development
Development
Frontend
Backend
DevOps
SAAS
Locate us at
Karnataka
My Office Space, No 22/B, 2nd Floor,
BM Habitat Mall, Gokulam Main Road,
Jalakashmipuram, Mysore-570012,
Karnataka, India.
+91 9538770892
Uttar Pradesh
4th Floor, Bhavya Corporate Tower,
Vibhuti Khand, Gomti Nagar, Lucknow,
Uttar Pradesh 226010
+91 726-804-5173
Get in Touch
+1 646-432-0784
+91 9538770892
For Business – contact@allgrowtech.com
For Career – hr@allgrowtech.com
ALLGROW TECHNOLOGIES
We are here to provide quality technical solutions that perfectly align with your business requirements.