Visual Studio SSRS Report design with AX Classes and TMP table

-
Hello, I will try to explain how to design SSRS reports in Visual Studio and deploy to Axapta 2012 system...

You need to have a Visual Studio installation with the Dynamics Ax 2012 visual studio tools installed. To open the visual studio as connected to your AOS; you can use a modified shortcut.
To achieve this;
-          Go to your Visual Studio folder (standard is “C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\”)
-          Find “devenv.exe” and send a shortcut to your desktop.

-          Right click on shortcut è  properties and add the following command at the end of the “Target” field after leaving a space; “/AxConfig AXC file path”.  AXC file is the configuration file of the AOS you are using.

After this, open Visual Studio and select “New Project è Microsoft Dynamics AX è Report Model.”



On the right pane, you will see “Solution Explorer”. Right click on the solution and select “Add è Report”

You will see that a Report design will be open on the main screen. There is “DataSets” section that you will select your DP class and so your TMP table fields. Right click on Datasets and select “Add Dataset”.

Open the properties of your new Dataset and select “Data Source Type” è “Report Data Provider”. Then click on the three dots right end of the “Query”  row and selet your DP class and follow the instructions to add your return fields to your new design.




Now right click on the “Designs” tab and select add. Here you have 2 choices; you can select an AutoDesign or Precision Design. AutoDesign can be useful for fast debugging your code because you will just drag and drop your fields into a grid and your report is ready, but if you need a better looking report, Precision Design will be a better choice.

When you are done with the report designs just right click on the solution and select “Deploy Solution” to send the report to AX. Also, to send the VS solution to AX, again right click on the solution and select “Add report to AOT”. This will send the solution to AX system.

After all, you can use this report name and design name in your Controller class as to specifiy which report will be called.

Comments

Post a Comment

Popular posts from this blog

How to find Company Logo (X++)

-
In this blog i will tell you how to take company logo with X++ code. Below code returns Company logo as image file. Write this code in a new method in your white paper report and just drag and drop it to create the related object as a bitmap object. display Bitmap companyLogo () { CompanyInfo companyInfo; companyInfo = companyInfo::find(); return CompanyImage::findByRecord(companyInfo).image; }
Read more

How to find MainAccount with LedgerDimension (X++)

-
Hi, i will show you how to get the MainAccount record with the LedgerDimension. You can use "DimensionStorage" class to achieve this. Below code finds the whole Main Account record with a ledgerDimension RecId. DimensionStorage dimStorage; MainAccount mainAccount; MainAccount = DimensionStorage::getMainAccountFromLedgerDimension(ledgerDimension); //Parameter as the LedgerDimension RecId
Read more

How to do barcode in SSRS (X++)

-
Image
In ths post, i will explain how to do barcode in SSRS reports. - First of all you need to install barcode fonts into your reporting server and AOS server. Search for barcode fonts over internet and install them both of the servers and restart the machines. - After you return the dataset and started to your report design in Visual Studio; you need to write the field expression of the field with stars, that you want to be seen as a barcode. - Create a textbox and select your returning data. - Right click on the textbox and select TextBox Properties. In the properties menu, select Font and select "BC C39 3 to 1 HD Wide"  (You can select other barcode types also but this works for me generally). - After this, right click the TextBox and select "Expression" and write the field expression like below.
Read more