Headers and details in SSRS report

Finance and Operations/AX Developer Forum
1

Hi,

I have requirement to print multiple sections in SSRS report. Suppose there are the 3 tables, sales table, sales line and on child table(SalesLineDetails) of salesline that stores linewise information for each sales line. I have to print like as follws:

  1. Sales ID 1

Sales Line 1_1

SalesLineDetails 1_1_1

SalesLineDetails 1_1_2

SalesLineDetails 1_1_3

Sales Line 2

SalesLineDetails 1_2_1

SalesLineDetails 1_2_2

SalesLineDetails 1_2_3

  1. Sales ID 2

Sales Line 2_1

SalesLineDetails 2_1_1

SalesLineDetails 2_1_2

SalesLineDetails 2_1_3

Sales Line 2

SalesLineDetails 2_2_1

SalesLineDetails 2_2_2

SalesLineDetails 2_2_3

…and so on

Please advise how it is possible.

Best Regards,

Nagesh

2

Hi,

Anyone has any ideas, please help.

Best Regards,

Nagesh

3

Hi Nagesh,

You can achieve this by applying the concept of grouping inside your tablix.

You can browse to understand the concept of grouping.
You can refer: msdn.microsoft.com/…/ms170712.aspx

Sincerely,
Muneeb

4

I assumed you are using AX 2012.

Always make sure to mention the AX version in the question itself to make it easy for anyone to respond.

Sincerely,
Muneeb

5

Hi Muneeb,

Yes, I am using AX 2012 R3. Anyways thanks for your reply. I will go through the link and will try if it helps.

Thanks once again.

Best Regards,

Nagesh