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

Illegal Reference on Purchase Order line creation

If there is a issue while creating Purchase order line in Dynamics Ax 2009, which throws up error 'Illegal Reference', it might be due to mess up in number sequence, revisit the number sequence and change it with last number in the respective table (inventtrans) to next num field of number sequence.

CheckBox on forms / Grids

Had a serious problem today with enum field on table, but a simple solution for it.

Issue:

Had created a Enum field on a table and Attached EDT NOYesId to it, expectations was to check/uncheck the fields on grid and it was not working, but when updated from backend its fine and through code also it's been updated as required. But its a simple enum field which has to Check / Uncheck based on user selection on form.

Solution:

Create a new enum field to the same table rename the old one and use this with initially created enum field. Now check/ uncheck on forms works well and good.

Reason:

Unknown

Time consumed:

2 Hrs

ProdComReport_BE

4.431.123.118 is the sample number that can be used as branch number for companyinfo table branch number to generate report ProdComReport_BE.

This will return validation true : considers last two characters for validation against all other characters excluding '.'

Object 'FormRun' could not be created

Issue & Cause:
When opening report from Ax, if you are coming across this error, the main reson might be args are not getting passed from Form or to formfrom classes.

Solution:

Check the main method , it should be using client keyword, since args were passed from client.

Example : Public client static void main(Args _args)