Share via

SSRS Column Group layouts

Ben F 26 Reputation points
2020-11-02T15:36:04.703+00:00

SSRS 2016

I have a report with column grouping as follows.

[Quarter]
[Month]
[Category]

So I see
36891-image.png

I would like to see that Category column group under the Quarter group total. Other then creating a seperate tablix with out month, I can't seem to figure it out. Appreciate the help

Image of what I would like
36780-image.png

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.
2,915 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 36,116 Reputation points
    2020-11-03T02:36:44.063+00:00

    Hi @Ben F ，

    It's hard to meet your needs from SSRS side.

    The way I could only find is creating a new Matrix and put the two Matrixes together like shown which you have mentioned.

    ![36927-screenshot-2020-11-03-102328.jpg][1]

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our [documentation][3] to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    [1]: /api/attachments/36927-screenshot-2020-11-03-102328.jpg?platform=QnA [3]: https://learn.microsoft.com/en-us/answers/articles/67444/email-notifications.html

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.