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: Microsoft SQL Server
Microsoft Dynamics Ax, SQL Analysis Services, Business Intelligence
Dynamics AX: Implementing the prebuilt BI solution [AX 2012]
by Bo Jensen •
Traditionally, BI solutions are implemented during the second or third phase of an Enterprise Resource Planning (ERP) implementation project. Needless to say, project fatigue sets in (and the budget gets exhausted), and subsequent phases are postponed or delayed. BI implementation is complex and involves the integration of many components. Also, the skill set required to…
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.
SQL Analysis Services
How to Default to ALL in an SSRS Multi-select Parameter » The Data Queen
by Bo Jensen •
This seems like it should be easy, but SSRS has nothing built in to allow you to do this. I searched an couldn’t come up with a solution that fit all my requirements for a report. There are ways to default the selection list to every value in the list, but I needed to add…
SQL Analysis Services
Reports in SSRS with Multi Value Parameters and NULL Values
by Bo Jensen •
If you are creating a SSRS report in Visual Studio 2008 and would like a parameter to display multiple values including NULL values, you will get a message saying, “A multi-value parameter cannot include null values”.
SQL Analysis Services
SSRS optional parameters settings
by Bo Jensen •
Recently I had to create couple SQL Server Reports (SSRS) with optional parameters built in. It took me a while to refresh memory how this can be done. It was very simple to create reports and processes behind, but connecting these two were are little bit challenging – stored procedure was tested and worked fine,…
SQL Analysis Services
Optional filter in SSRS | Musings by Generator
by Bo Jensen •
I am astonished that this is not a feature in SSRS. How can you expect business users to create expressions to handle an optional filter. So for those looking how to do an optional filter on a parameter, here is how to do it:
SQL Analysis Services
Using the .NET Business Connector to read/write data to Axapta
by Bo Jensen •
In the next example, we create a new project in Visual Studio and add the reference to the project. You can skip this step if you already have a project where you would like to use the .NET Business Connector.
SQL Analysis Services
Using Dynamics ‘AX .NET Business Connector’ to access Dynamics AX 4.0 from .NET world
by Bo Jensen •
So, this is a really interesting integration aspect between AX and .NET apps. We want to access AX business logic (or data, transactions, etc.) from the .NET world. 🙂
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 SQL Server
How to Track Down Deadlocks Using SQL Server 2005 Profiler
by Bo Jensen •
A Quick Introduction to Deadlocks Deadlocking occurs when two or more SQL Server processes have locks on separate database objects and each process is trying to acquire a lock on an object that the other processes have previously locked. For example, process one has an exclusive lock on object one, process two has an…
Microsoft Dynamics Ax, SQL Analysis Services, Business Intelligence
Setting up scheduled processing of cubes in AX2012
by Bo Jensen •
Here is a quick guide on how you can easily and quickly setup scheduled processing of the cubes for Microsoft Dynamics AX 2012. The same approach works for other Analysis Databases, but sometimes it helps to put things in context in order to make it easier for you AX geeks out there.
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.