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).
Tag: SSRS
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 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
AX2012 Sales Invoice SSRS Reporting Error identified
by Bo Jensen •
While working and testing modifications to the Layout of the “Sales Invoice“ report in AX 2012, I have found a rather annoying error with language translation of the SSRS report. When you are printing a Sales Invoice, the report prints all labels according to the Language set in the Sales Invoice Header. (Found under…
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
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.
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 Reporting Services
15 Seconds : Business Intelligence with Microsoft SQL Server Reporting Services
by Bo Jensen •
15 Seconds : Business Intelligence with Microsoft SQL Server Reporting Services – Part 1
SQL Reporting Services
Designing Reports with Custom MDX Queries « Paul Turley's SQL Server BI Blog
by Bo Jensen •
https://sqlserverbiblog.wordpress.com/2011/03/27/designing-reports-with-custom-mdx-queries-part-1/ https://sqlserverbiblog.wordpress.com/2011/05/04/designing-reports-with-custom-mdx-queries-part-2/ https://sqlserverbiblog.wordpress.com/2011/05/04/designing-reports-with-custom-mdx-queries-part-3/
Webdevelopment
Building ASP.NET Reporting OLAP-Based Application – CodeProject
by Bo Jensen •
http://www.codeproject.com/KB/reporting-services/SSRS-ASPNET.aspx http://www.codeproject.com/KB/reporting-services/SSRS-ASPNET2.aspx http://www.codeproject.com/KB/reporting-services/SSRS-ASPNET3.aspx
Webdevelopment
Creating Reports with SQL Reporting Service and Visual Studio .NET – CodeProject
by Bo Jensen •
Creating Reports with SQL Reporting Service and Visual Studio .NET – CodeProject
Microsoft Dynamics Ax, SQL Analysis Services, SQL Reporting Services, Business Intelligence
Dynamics AX 2009: SSRS Reports and the role of Business Logic & Data Methods
by Bo Jensen •
Dynamics AX 2009: SSRS Reports and the role of Business Logic & Data Methods – Saveen Reddy’s blog – Site Home – MSDN Blogs