Grouping Report

[mohit]

Hi,

I want to develop a pdf report using Telerik Report.  Below is my problem statement:

Problem Statement:

I have to develop a report in which I have 4 data sections(Actually Table) say

Section 1

Section 2

Section 3

Section 4

All the sections are releated in such a way that the re can be multiplle section1 and under Section1 there can be multiple section2 and under each section 2 there can be multiple section3 & section4.

Data Source would be a list of anonymous type which would be a result of linq query.Below is the pattern in which I have the data soure:

List of  {Department, Gender, EmpId, Employee Name}

Data:                                       {D1, M, 1, AAA}

{D1, M, 2, SSS}

{D1, F, 3, XXX}

{D1, F, 4, UUU}

{D2, M, 5, PPP}

{D2, M, 6, RRR}

{D2, F, 7, BBB}

{D3, M, 8, MMM}

{D4, F, 9, JJJ}

{D4, F, 10, LLL}

{D4, M, 11, RRR}

{D4, M, 12, QQQ}

Desired Output:

                                                Report Header

Section1                                 D1

                                              

Section2                                 M

                                               

Section3,4                              1,AAA   

Section3,4                              2,SSS

                                              

Section2                                 F

                                               

Section3,4                              3,XXX   

Section3,4                              4,UUU   

again the same way the data is repeated. So Could you please provide me the help in implementing this.

                                                                                               

Thanks!

Regards,

Mohit

 

[Peter]

Hello mohit,

You can achieve the desired layout with report groups. You will need two report groups the first one for grouping should have Department, the second one should have for grouping the Gender field. For the other two fields  EmpId, Employee Name you have to add two TextBoxes to the reports detail section.

You may find useful Grouping Data and Report Wizard help articles.

All the best,
Peter
the Telerik team