SSRS AX 2012 Error: Element ':PurchPurchaseOrder.Parameters.IsPurchConfirmationRequestJournal' has already been defined. To correct this, rename one or more of the model elements so that they have a unique name.

When we customize PurchPurchaseOrderReport to add a field on PurchPurchaseOrder Dataset in AOT and refresh dataset in Visual Studio.

We will get following error message:
Element':PurchPurchaseOrder.Parameters.IsPurchConfirmationRequestJournal’ has already been defined. To correct this, rename one or more of the model elements so that they have a unique name.


This is very common error and we can fix it by doing following steps: 

1. Prior to refreshing Dataset, we have to rename the parameter IsPurchConfirmationRequestJournal to IsPurchConfirmationRequestJournalDelete
2. Change the following properties:
   1. nullable – True
   2. allow blank – True
3. Now refresh the dataset you should not see any errors and a new parameter IsPurchConfirmationRequestJournal will be created. Now set the below properties of new parameter:
   1. allow blank – True
   2. Nullable – True
4. Once the properties are set, now delete the parameter ‘IsPurchConfirmationRequestJournalDelete’.
5. Rebuild the solution and deploy the report.

SSRS Report - Can't see changes after deploying SSRS report AX 2012

Follow the following steps: If you are on R3, you have the Tools -> Caches -> Refresh report server; Also, do a Tools -> Caches -> Refresh elements and Tools -> Caches -> Refresh dictionary; If you have an AOT query, you can do a Restore on the query; Open the report in Visual Studio, and perform a Refresh on your dataset in the Datasets node; Also in Visual Studio perform a rebuild and a deploy of the report; Before step 5. you can check that the parameters you have for your report are the proper ones (if you've changed the data contract or the query); Depending on the decision to load the last values (controller.parmLoadFromSysLastValue) you want to do a Reset usage data; And last but not least, you want to do a Restore and then also a Deploy element on the report in the AOT. If your still facing the issue then finally restart your SQL Server Reporting Services in service and run the report. OR sometimes you need to delete the report in the report document folder, then deploy again to get the latest version published. After that restart the SSRS service instance. I hope that one of these helps.

SRSS - How To Append 'st', 'nd', 'rd' or 'th' To Day Numbers in Dates

Microsoft Dynamics AX ERP systems in it is a large and completed ERP Solution of all Time, but different user have different sets of requirement to achieve his/her business goal. A common example among all is to append Day number with  'st', 'nd', 'rd' or 'th'. Which is not possible in SSRS Report, because there are a lots of format available for date but you will not found any solution regarding this problem.

The available format in SSRS Reports are as following:

Formatting Date and Time in SQL Server Reporting Services (SSRS) is a very common need. And in some cases customers look for a very specific format, so it is important to understand the basic components of date and time formats.

SSRS offers many in-built Date and Time formats. Below are some of the in-built Date formats available in SSRS:

For appending all the above suffix you need to follow following steps:

1. Open any Report in Visual Studio and insert a textbox contain Data Field of Date Type,

2. Right Click on Textbox, Go To Text Box Properties

3. Click on Number tab, click on custom format option then click on fx button in black.

4. A form will open, copy the below text and paste there to need to change following text with your database date field.

Fields!FieldName.Value, "Dataset"

1. Replace FieldName with your Date Field

2. Replace Dataset       with your Dateset Name

="d" + switch(int(Day((Fields!FieldName.Value, "Dataset"))) mod 10=1,"'st'",int(Day((Fields!FieldName.Value, "Dataset"))) mod 10 = 2,"'nd'",int(Day((Fields!FieldName.Value, "Dataset"))) mod 10 = 3,"'rd'",true,"'th'") + " MMMM, yyyy"

5. Press ok, Again ok. Deploy your report and check it on AX. Enjoy!!