Button to open morphx dynamics ax6/5/2023 ![]() ![]() ![]() This opens up the SSRS Designer (same as standard SSRS).Now right click on new Design and select “Edit Using Designer”.This creates a new Precision Design and name it as PrecisionReport Now Right click on the designs node, select Add and then “Precision Design”.Expand Node “All Display Methods” and select “name” and “openBalanceMST”.Expand All Fields nodes under the CustTable node to select “AccountNum”.Either you can select all fields or a subset From the list select “SKL_SampleCustomer” and click Next.This opens up the query selection box to select a Microsoft Dynamics AX Query.In the query property, click the button.Now in the report, go to the Datasets section and create new Dataset using the name Customer.Set the report title to “Customer balance”.Name the report SKL_SampleReportPrecision Right click on report model, select Add –> Report. ![]() Open the previously created Report Model.Here we will use the same AOT query created in previous example Build and Deploy Simple Report–Queries : SKL_SampleCustomer I will also show how we can use some inbuilt parameters to display some generic information like page number, execution date and time etc. We will again use the same example of printing Customer Id, Customer name and Balance but this time instead of creating an Auto Design we will use Precision Design. A precision design is like a pre-printed format where the placing of report controls, the design and the spacing matters a lot.Ī precision design is the standard SSRS report designer following the same principles, rules and requirements as are found in a SQL Server Business Intelligence Studio SSRS designer. In this post, we will see how we can build a report using precision design. Click on the link and the customer form opens up.Save report, go to AX, deploy the report and run it.Set Expression “=CustDrillDown(Parameters!AX_ReportContext.Value, Fields!AccountNum.Value)”.Select option “Go to URL” and click button “ fx”.Now right click on this text box and select “Text Box Properties…”, Switch to Tab “Action”.Select the AccountNum text box, underline the text and set font color to Blue.Right click on Precision Design and open the designer.ToCustomerForm(reportContext, custAccount) Public static string CustDrillDown( string reportContext, string custAccount) Public partial class SKL_SampleReportPrecision Double click the data method this opens the Code editor.Go to “Projects” tab and select “SRSDrillThroughCommon” and click Ok.In Solution Explorer, right-click the business logic project and then click Add Reference.You will also notice that a Business Logic Project is automatically added.Right click on the Data Methods node and create a new DataMethod.Open the report SKL_SampleReportPrecision project.This adds the SRSDrillThroughCommon project to our current solution In Application Explorer, right-click Visual Studio Projects > C Sharp Projects > SRSDrillThroughCommon and then click Edit.Open the SKL_SampleReportProject (refer to link above).To achieve this first we will add the reference to SRSDrillThroughCommon project. What I will try and demonstrate here is how to add links in AX reports (to open the corresponding forms). This means, data methods can only return strings. What I have also noticed is the data methods have return type only as System.String and you will not be able to change this return type. Net Business Connector from next version hence the usage of data methods for many things will be redundant. But with much better integration, and Reporting framework in AX improving, Data Methods in AX SSRS are reduced to minimal use.Īlso the reason is that MS is soon going to do away with. In AX 2009, AX SSRS had good use of these data methods. We will use the same Report model and report that we created in Building a Simple Report–Precision Design. In this post, I will explain how to use data methods in Reports. ![]()
0 Comments
Leave a Reply. |