web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Insert Columns into SS...
Microsoft Dynamics AX (Archived)

Insert Columns into SSRS Report Dynamically

(0) ShareShare
ReportReport
Posted on by Community Member

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.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

    Regards.

  • Community Member Profile Picture
    Community Member on at

    Yes, but how do you insert the new columns?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

    Regards.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans