Query reports have restrictions in their design compared to RDP reports.
We generally use query reports for simpler design and does not include complex data manipulation.
One such complex scenario is displaying barcode for the item in the report. But reporting in AX has enough flexibility so that we can display the barcode using a query report. We'll see below how to do that.
Step1 : Write a display method.
Write a display method which returns the barcode string.
Update the reportDS by selecting the display method.
We generally use query reports for simpler design and does not include complex data manipulation.
One such complex scenario is displaying barcode for the item in the report. But reporting in AX has enough flexibility so that we can display the barcode using a query report. We'll see below how to do that.
Step1 : Write a display method.
Write a display method which returns the barcode string.
Step2: Refer this field in the report design.
Step3: To make the font name dynamic, add references of the setup tables in your AOT query.
Here barcodeSetupId in my parameter form has a reference from barcodeSetup table.
Font name from barcodeSetup has been fetched.
Step4 : Create a report parameter and refer the fontName.
The fontName is coming from barcodeSetup table. The parameter visibility is hidden as we don't want to show it to the user when the dialog opens.
Step5 : Refer the fontName field dynamically.
Comments
Post a Comment