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).
Kategori: Microsoft SQL Server
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.
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 Analysis Services
Cube and KPI reference for Microsoft Dynamics AX [AX 2012]
by Bo Jensen •
Cube and KPI reference for Microsoft Dynamics AX [AX 2012] Cube and KPI reference for Microsoft Dynamics AX [AX 2012] R2 and R3
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 SQL Server
How to remove database locks in SQL-Server
by Bo Jensen •
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…
SQL Reporting Services, Microsoft Dynamics Ax
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
Microsoft Dynamics Ax, SQL Analysis Services
Dynamics AX: AX 2012 – Process Cubes Error: translations in Standard Edition
by Bo Jensen •
Dynamics AX: AX 2012 – Process Cubes Error: translations in Standard Edition
Microsoft Dynamics Ax, SQL Reporting Services
Create Quick first SSRS report in Dynamics AX 2012
by Bo Jensen •
Today, let us learn how to quickly create report models and report in Visual studio and add to AOT[Dynamics AX 2012] and see a running report.
Microsoft SQL Server, Application Integration Framework
Info: AifResourceLock Table « Santosh Ramamurthy AX Blog
by Bo Jensen •
When debugging X++ code the developer tends to press (Shift+F5) to stop the execution of program. This symbolizes that either the issue is figured out (or) may be he needs more data to understand the issue which is going on. This type of debugging usually has a side effect on AIF.
Microsoft SQL Server
Check for database locks in SQL Server
by Bo Jensen •
SQL Reporting Services, Business Intelligence
How to Enable Remote Errors for SQL Server Reporting Services « Amir's Microsoft Dynamics AX space
by Bo Jensen •
How to Enable Remote Errors for SQL Server Reporting Services « Amir’s Microsoft Dynamics AX space
SQL Analysis Services
Processing an OLAP cube with a T-SQL Stored Procedure
by Bo Jensen •
Processing an OLAP cube with a T-SQL Stored Procedure