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…
Kategori: SQL Reporting Services
SQL Reporting Services
How to move SSRS reports to new server
by Bo Jensen •
Here are the steps I used to move SQL Reporting Services reports from one server to another:
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: Calling a Custom Dynamics AX 2009 SSRS report and passing parameters – From X++
by Bo Jensen •
I found this great example on http://dynamics-ax.blogspot.dk/ on how to create a simple custom SSRS Report for Microsoft Dynamics AX.
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, SQL Reporting Services
Walkthrough: Creating a Report Bound to a Report Data Provider Class (X++ Business Logic) [AX 2012]
by Bo Jensen •
In this walkthrough, you use a report data provider (RDP) class with business logic to process data and then display the outcome of the business logic on a report.
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).
Business Intelligence, Microsoft Dynamics Ax, SQL Reporting Services
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.
SQL Reporting Services
Move Reporting Services Reports form One SQL Server to Another
by Bo Jensen •
Here are the steps I used to move SQL Reporting Services reports from one server to another:
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
Get list of printers in Dynamics AX 2012 for SSRS reports using Using X++
by Bo Jensen •
Get list of printers in Dynamics AX 2012 for SSRS reports [Using X++] « Sreenath Reddy G – Dynamics AX Consultant’s Blog
Microsoft Dynamics Ax, SQL Reporting Services
Display Barcode in SSRS report for Dynamics AX 2012
by Bo Jensen •
Display Barcode in SSRS report [Dynamics AX 2012, X++] « Sreenath Reddy G – Dynamics AX Consultant’s Blog
Microsoft Dynamics Ax, SQL Reporting Services
How to deploy the default SSRS reports in AX 2012
by Bo Jensen •
Commands taken from MSDN on how to manage SSRS reports in AX using Windows PowerShell
Microsoft Dynamics Ax, SQL Reporting Services
Some reports in Dynamics AX 2012 do not fit to page properly when printed | ERP Technician
by Bo Jensen •
With the release of Microsoft Dynamics AX 2012, the report design and delivery platform changed significantly from the previous version. Reporting has shifted away from native X++ reports designed in MorphX to SSRS reports designed in Visual Studio. While working with AX 2012, some of the new SSRS reports will not render as expected when…
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…