no report data table with name exists in report schema for data provider

I was getting the following error message when I move my already running report from Test Server to the Live Server.

After running the report on live server the error message was:

"No report data table with name MZK_ProductPriceHeaderTmp exists in report schema for data provider MZK_ProductPriceDP."

The Solution to this issue is that restart the reporting services running on this server and than clear cache and the usage data and than try to run the report again.

Thanks

Muhammad Zahid.

Changes in InventTrans Data Model in Microsoft Dynamics AX 2012 Version

After the upgrade from AX 2009 to AX 2012.My client has raised an issue that he was not able to select the delivery note and physical date from Stock Transactions table in selection criteria on the SalesEditLines Form.

After some research I found out that there is same change in InventTransData Model and thats why query associated to the SalesEditLines Form is also modified that's why user was not able to see the two fields as they were in AX 2009.

Below is the Screen Shot taken from AX 2009 of the form SalesEditLines Form:

Above form can be access through the below navigation path:

Account Receivable -> Periodic -> Sales update -> invoice

As you can see in the above image Stock Transactions table was available in selection criteria in AX 2009 but in AX 2012 it is change in the query associated to this form due to change in the data model of InventTrans.

Below is the link that contains the description of change in InventTrans Data model in AX 2012.

http://www.axpulse.com/changes-in-microsoft-dynamics-ax-2012-inventtrans-data-model/

Dynamics AX 2012 SSRS Report Parameter Label Truncate Issue

I was having an issue on SSRS report that label of my parameter was truncating.

The issue was that I was not using any Label Id for the parameter text.

Below are the steps to resolve this issue.

1. Creating a label with label id
2. Prefixing "literalstr()" around the label - e.g. SysOperationLabelAttribute(literalstr("@lbl001"))

Below is the link for more detail on this issue:

https://community.dynamics.com/ax/f/33/t/119603.aspx

Thanks

Muhammad Zahid.