Dynamic Columns

InspiredUser33157 216 Reputation points
2021-03-15T16:36:31.78+00:00

![77845-current1.png][1] 77827-target.png

This is the output I'm creating now. [1]: /api/attachments/77845-current1.png?platform=QnA

I need it to look like this. I have a Matrix embedded into a List and need it to flow Left to Right and not vertically.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments No comments
{count} votes

Accepted answer
  1. InspiredUser33157 216 Reputation points
    2021-03-16T12:35:52.757+00:00

    Very Well Done! Thank you. It worked as expected.

    Just need to resolve the converting the heading into the Monday of each week.

    https://learn.microsoft.com/en-us/answers/questions/311908/ssrs-dateadd-expression-failing.html

    78244-current2.png


1 additional answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,631 Reputation points
    2021-03-16T02:39:19.517+00:00

    Hi @InspiredUser33157 ,
    I picked some data to test locally, please refer to the following steps:

    • Suppose I have a table in the database, as shown below:

    77989-table.jpg

    • Create a matrix in SSRS:

    77999-design.jpg

    • Preview:

    77990-preview.jpg
    The following gif file contains detailed steps, please check carefully:

    78081-06.gif

    If you have any questions, please feel free to let me know.
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.