question

ChuckSalerno-4276 avatar image
0 Votes"
ChuckSalerno-4276 asked Joyzhao-MSFT edited

Dynamic Columns

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

This is the output I'm creating now. [1]: /answers/storage/attachments/77845-current1.png

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
current1.png (28.3 KiB)
target.png (20.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ChuckSalerno-4276 avatar image
0 Votes"
ChuckSalerno-4276 answered Joyzhao-MSFT edited

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

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

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

78244-current2.png



current2.png (23.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ChuckSalerno-4276 ,
Thanks for your feedback.
If the issue in this case has been resolved, please mark "Accepted Answer" below my answer so that more people in need can see it. And I think this is an affirmation of my test results.Thank you for understanding.
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 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @ChuckSalerno-4276 ,
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.



table.jpg (49.1 KiB)
design.jpg (11.9 KiB)
preview.jpg (62.3 KiB)
06.gif (951.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.