Hi Folks, I got one requirement to get invoices of a customer on the particular month range in SSRS Report Dialog. I have achieved that and want share. Here we go…..
Tag: Reporting
Microsoft Dynamics Ax
There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs.
by Bo Jensen •
There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs. The InnerException message was ‘Element ‘http://tempuri.org/:queryBuilderArgs’ contains data from a type that maps to the name ‘http://schemas.datacontract.org/2004/07/XppClasses:SRSQueryBuilderArgs’………………………………….Some times we get the above error while running reports in Axapta 2012. To resolve this issue we need to delete usage data in the AOSserver.
Microsoft Dynamics Ax, SQL Reporting Services
Use a Dynamics AX display method in SSRS report | Arjen Stolk
by Bo Jensen •
There are a lot of display methods that I would like to use in a SSRS report. Here is an example of the use of the display method ‘reservedPhysicalInSalesUnit()’ from the sales line. In order to use this method, you need to be able to identify the sales line. For this you need the SalesId…
SQL Analysis Services
Dynamics AX 2012 – Report labels does not show up in report
by Bo Jensen •
Sometimes the report labels do not show in reports or the report shows label IDs like Labels!@SYS2123 instead of label values.
Microsoft Dynamics Ax, SQL Reporting Services
How to: Add a Drill Through Action on a Report [AX 2012]
by Bo Jensen •
MSDN does document how to add a drill through action on a report. http://msdn.microsoft.com/EN-US/library/cc582049.aspx However I feel it is quite invasive and it could be done a lot cleaner without touching too many standard objects.
Microsoft Dynamics Ax, SQL Reporting Services
SRS report does not reflect the new query changes – cache issue [AX 2012]
by Bo Jensen •
In some scenarios you may see that your query changes doe not reflect in the report. This is due to some caching that is done. The obvious thing is to delete the AUC files and clear out your data usage. But there is a new table that we need to be aware of in this…
SQL Reporting Services
SSRS Page Break After X Number of Records « Jeff Prom's SQL Server Blog
by Bo Jensen •
In SQL Server Reporting Services you can add a page break after a desired amount of records. Here is how you do it.
Microsoft Dynamics Ax, SQL Reporting Services
Dynamics Ax Internals: Quick walk-through of developing a report in Ax2012
by Bo Jensen •
The following is a quick-and-dirty approach to building a basic SSRS report in Ax2012. This uses an Ax query as the primary datasource, and uses display methods on the table(s) to retrieve additional information. This is not an approach you should take for all reports, particularly those that require more complex calculations or parameters, but…
Microsoft Dynamics Ax, SQL Reporting Services
Simple SSRS report example by using Ax-Query and Ranges
by Bo Jensen •
In this report I am going to use the Ax-Query in the SSRS business logic and report will be generated by using SSRS Business logic.
Microsoft Dynamics Ax, SQL Reporting Services
Use a Dynamics AX display method in SSRS report | Arjen Stolk
by Bo Jensen •
There are a lot of display methods that I would like to use in a SSRS report. Here is an example of the use of the display method ‘reservedPhysicalInSalesUnit()’ from the sales line. In order to use this method, you need to be able to identify the sales line. For this you need the SalesId…
Microsoft Dynamics Ax
How to Set the Query Range on a SSRS Report | Amir's Microsoft Dynamics AX space
by Bo Jensen •
I found a couple of examples on how to set the QueryRange on SSRS reports on Amir’s AX Space
Microsoft Dynamics Ax
Report Data provider [RDP] as data source type in data set – SSRS reports [Dynamics ax 2012] | Sreenath Reddy G – Dynamics AX Consultant's Blog
by Bo Jensen •
Friends, I am excited to share this new source of data[RDP] for the dataset..We all know in the older version, for a dataset we had only Query and Business logic as a dataset source in SSRS reports. Now in the current version, we have actually 4 options : Query, Business Logic, Report data provider…
Microsoft Dynamics Ax
How to print a report in AX 2009
by Bo Jensen •
Microsoft Dynamics Ax, SQL Reporting Services, Business Intelligence
Dynamics AX 2012 error when running SSRS-reports just after deleting a table field from report's temporary table – Addicted2AX / Addicted2SQL
by Bo Jensen •
When designing reports I sometimes faced a strange problem. After testing a new SSRS-report successfully I am always checking the SSRS-report’s temporary tables for table fields which were created by me during design-process but which are not used at the end (e.g. because of design-changes).
Microsoft Dynamics Ax, SQL Reporting Services, Business Intelligence
Blank, last page in SSRS-Report Addicted2AX / Addicted2SQL
by Bo Jensen •
Ok, it took some time but here is a new entry. A short one.
Microsoft Dynamics Ax, SQL Reporting Services
Dynamics AX 2009: Creating a simple SSRS Report
by Bo Jensen •
Here is a great blog from Saveen Reddy covering how to create SSRS reports for AX 2009 in a quick and simple manner.
Microsoft Dynamics Ax, SQL Reporting Services
Create Quick first SSRS report in Dynamics AX 2012
by Bo Jensen •
In a Visual Studio reporting project for Microsoft Dynamics AX, you can define a report in a report model. A report consists of a collection of items, such as datasets, parameters, images, and report designs. A model can contain more than one report. Also, for this post I am assuming that all report services are…
Microsoft Dynamics Ax, SQL Reporting Services
Playing with SSRS report in dynamics ax 2012
by Bo Jensen •
How to print the SSRS report in dynamics ax 2012 from code. 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(); } How to save the SSRS report…
Microsoft Dynamics Ax, SQL Reporting Services
Creating SSRS-Reports in Dynamics AX 2012 – What’s no longer possible in AX-reports
by Bo Jensen •
Microsoft Dynamics Ax, SQL Reporting Services
Ax 2012 Deploy reports through code « Shashi's Ax.Net Space
by Bo Jensen •
These lines deploys SSRS Reports with X++ Code – Remember not to run this code in CIL or you will get runtime error. SRSReportManager srsRptMgr = new SRSReportManager(); SSRSReportConceptNode node = new SSRSReportConceptNode(); node = TreeNode::findNode(@"SSRS ReportsReportsSalesInvoice"); srsRptMgr.deploymentStart(); srsRptMgr.deployReport(node); srsRptMgr.deploymentEnd(); Ax 2012 Deploy reports through code « Shashi’s Ax.Net Space