SSRS Ax 2012 new Purchase Order Design not reflecting

5 steps to follow when customizing Purchase Order report

1. Have created a new design to existing report model PSA









2. Right click to edit design, build, deploy, add it to AOT.

3. Change the report menu item with new design as illustrated


4. Open PrintMgmtReportFormat Table and change the report name to new reportname.newdesign
Example : PSAPurchaseOrder.TFGReport


 5. Open \Classes\FormLetterReport\loadPrintSettings

find setSettingDetail, and change the report design to fetch it from table based on document type



 6. Open the report from PO confirmation Inquiries, which will fetch you new report design.

 

To include line breaks on SSRS Report Ax 2012 Expressions

keyword to use : vbCrLf

Example 1 : = "Say hi to " + vbCrLf + "People"
Example 1 : = "Say hi to " + vbCrLf + "People" + vbCrLf + "of Antartica"

SSRS Report Troubleshooting tips

Issue:

Make sure that Microsoft Dynamics AX Business Intelligence Components are installed on the SQL Server Reporting machine and verify that SQL Server Reporting Services is configured correctly matching the report server configuration in the Microsoft Dynamics AX client.

Resolution:
















  


Issue:
Error while setting server report parameters. Error message: An error occurred while executing OnInit: The report execution failed to start. Verify that Report Extensions have been installed or are configured correctly.
Please consult your administrator or the documentation. (rsErrorInOnInit)

Resolution:

http://technet.microsoft.com/EN-US/library/hh389762.aspx

Database Log on table data - Steps to follow

Administration -- Setup -- Database Log

Administration -- Reports -- Database Log