tablix grouping - having several detailed rows...

arkiboys 9,701 Reputation points
2020-11-20T12:09:14.867+00:00

Hello,
I would like to have the below requirement in the tablix to call each sub-report for every Code but I am unable to do this.
Any suggestions please?
Thank you

Requirement
:
Code --> Tablix is grouped on this field
Title_1 --> Title as the header for the following subreport
subreport_1 --> Detailed row
Title_2 --> Title as the header for the following subreport
subreport_2 --> Detailed row
Title_3 --> Title as the header for the following subreport
subreport_3 --> Detailed row
...

WHAT I HAVE DONE SO FAR:

It looks like, when I try to create a tablix with the above grouping, it allows me to have the following but not any of the detailed rows after.

Code --> Tablix is grouped on this field
Title_1 --> Title as the header for the following subreport
subreport_1 --> Detailed row
Title_2 --> Title as the header for the following subreport
subreport_2 --> DOES NOT ALLOW Detailed row

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,009 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,286 Reputation points
    2020-11-23T07:08:57.187+00:00

    Hi @arkiboys ,

    Couldn't fully understand your requirement, could you describe with more information?

    You may share the design image with us for better understand.

    DOES NOT ALLOW Detailed row

    Do you mean that you don't want show the subreport's detail?

    Regards,
    Zoe


    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.

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November


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.