İsmail Ozcan

Microsoft SQL Server Reporting Services periodically restarts, and each restart clears the Reporting Services cache. After this cache has been cleared, it may take some time for the next report that is run to display. For example, you may have noticed that it takes a really long time for the first report that is run each morning to display. To minimize the effect of Reporting Services restarts, a new class that is named  SRSReportServerWarmup  is included with cumulative update 7 for Microsoft Dynamics AX 2012 R2. When the SRSReportServerWarmup class runs, it prepares the report server for use by performing the following tasks: Loads Microsoft Dynamics AX business logic assemblies. Connects to Reporting Services. Runs a sample report that is named SRSReportServerWarmup. As a best practice, you should schedule the batch job that runs the SRSReportServerWarmup class to run immediately after Reporting Services restarts. For more information about how to configure the ba...

SrsReportRun srsReportRun;     // initiate the report.     srsReportRun = new SrsReportRun ( "InventTruckTransactionReport.PrecisionDesign1" );     srsReportRun.init();     srsReportRun.reportCaption( "InventTruckTransactionReport.PrecisionDesign1" );     // set parameters name, value.     srsReportRun.reportParameter( "TruckTransDS_JournalId" ).value( "000161_070" );     // suppress the dialog     srsReportRun.showDialog( false );     if ( srsReportRun )     {         // run the report         srsReportRun.executeReport();     }

AX 2012 SSRS Report: Multiple design under Print management If new formats for Sales order confirmation/Picking/Packing/Invoice Purchase order postings etc. are needs to be added. Following steps needs to be performed. Step1. Create new Design for report under visual studio Step2. Add code to method: \Data Dictionary\Tables\PrintMgmtReportFormat\Methods\populate Add Code in the before TTSCOMMIT: addOther(PrintMgmtDocumentType::SalesOrderPackingSlip, ‘SalesPackingSlip.Report_XYZ,’SalesPackingSlip.Report_XYZ’ ,’XYZ’); Step 3. Setup the Format under: AR -> setup -> form setup -> Print management -> Sales order Packing slip original -> report format to SalesPackingslip.Report_XYZ Step 4. New Report design can be executed from use Print management from Inquiry journal forms or during posting by selecting Print management destination.

Czesława Langowska Vliegen   18 Sep 2013 3:12 AM  0 There are some tips we can use to improve performance of reports for Dynamics AX 2012. Use static reports. The deployment of static reports is described here:  http://technet.microsoft.com/en-us/library/hh496446.aspx  In this way we will safe several calls to Metadata service to get labels values and correct formatting of dates and numbers. Install application hotfix KB 2879661 which fix the situation when first generation of a report after Dynamics AX client restart takes long. This happens for each user. Newest kernel . Hotfixes for performance improvement are included in new kernels that are released; sometimes there is a dramatic impact on performance. In the morning a first report generation takes a lot of time SSRS uses session pooling. The first request that comes in from a user – a session will be created for them within the AOS services. Each user gets a session cached on the AOS service...

I have made some of the reports and now I want to call this report one from the main navigation area of account receivable that i have done by using menu item . Also I want to show the same report from the tab   on the form for which I want to show the report for the same Invoice Account which I have selected  by just clicking the mouse button on the same invoice Account. I mean to say is the report should get open for the same Invoice account which I have selected at that time ... Also I want to mention that I have use the rdp class as the data source in Ax 2012. I hope I got it right...  do you want to print the report for the selected (highlighted) record? Since you are using RDP classes, it is not a big issue, you just have to overwrite the prePromptModifyContract() method on the report controller class. Here is an example of code for prePromptModifyContract() method which checks if there were any args passed through the menu item bu...

In this example I have created a custom SSRS report for Dynamics AX 2009 instance. In this you will see I have a Query, that was used for my report, and also a report library I created using Visual Studio 2008 Dynamics AX 2009 Reporting template. The query, has a Range of SalesId, and in doing that, this was auto added to the report parameters, in the VS2008 projects. (see below image) This is the name of the parameter in the report def., and therefore important to note for our exercise. So the task was to take and pass values to reports from X++. I took and create a job that does exactly that. It takes and call my custom reports, output menu item, and pass it a value for the SalesId parameter. The code follows.: MenuFunction CustRptMI; Args Args; ; CustRptMI = new MenuFunction(menuItemOutputStr(srsCustomRpt),MenuItemType::Output) Args = new Args(); Args.parm("qryCustomSSRS_SalesId=*SO-100004*"); CustRptMI.run(Args); CustRptMI.wait(); Notice the name of the parameter is exact...