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: SSRS
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
How do I set AX 2012 SSRS report to a specific language?
by Bo Jensen •
set the current session language and set the rendering language of the report in Controller . Check if this works controllerobj.parmReportContract().parmRdlCOntract().parmLanguageID(‘Language ID you want ‘) before calling the report ‘s start operation method. this is actually passed to your report from the client during the execution. You need to create labels used in the report…
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 Server Data Tools for SQL Server 2014 is available – SQL Server Data Tools Team Blog
by Bo Jensen •
See more here: SQL Server Data Tools for SQL Server 2014 is available – SQL Server Data Tools Team Blog – Site Home – MSDN Blogs
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:
Ikke-kategoriseret
How to embed Barcodes in your SSRS report – CodeProject
by Bo Jensen •
Introduction The following excerpts will show how to embed successfully barcodes in your SSRS reports (similar to Crystal Reports but somewhat different). Using Barcode fonts is nice, however won’t work on the reports published on a the SSRS Reports server. Furthermore Barcode Fonts can be quite expensive. Thankfully to Brad Barnhill, who published an excellent…
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 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…