Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
I have a report that will have a variable number of monthly columns, based on date range. This will normally be three-to-four monthly columns, but will occasionally span a year or two, and could potentially span several years.
How do you do that from AX to SSRS? Creating a report with 48-60 columns and then hiding the unused ones is not a desirable approach.
Also, the column headings will change based on date range as well.
For that, you can use only a Matrix instead of a table that you gonna get that result.
Example: A report that show the customer and their open transactions with due dates.
Yes, but how do you insert the new columns?
I don't know how to explain, but let me try.
Drag and drop the matrix object to your report;
Right click on design node and choose editing using design;
Locate the matrix object and you gonna see four cells;
first cell of first line leave empty;
second cell of first line drag and drop due date field;
first cell of second line put cust account field;
second cell of second line put amount field;
If it didn't work, take a look at youtube, there're a lot of videos teaching how to use matrix in SSRS that use the same concept.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics