locked
SQL Reporting Services Column Merging RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

              we have a report requirement in a way to merge a column. For ex: there are list of employees will be in different departments. For Department A, number of employees A1,A2,A3....etc.. For Department B, number of Employees B1, B2, B3....etc. My report has Department column, Emp Name and Emp Details columns. 

           I need to display Department A only once in the center and other columns to display (A1, A2, A3.....) in each row. for all these rows Department should display only once like

                  Department   Emp Name        ENo

                                          A1                666
                                          A2                555
                         A               A3                444
                                          A4                215
                                          A5                845

    Please let me know how to do this.

    Regards,
    Sundarrajan.
               

    Wednesday, August 19, 2009 10:21 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    I am not sure how you could display the Department in the middle, or centered to the left of the Emp Name, but you could create a row group and set the grouping expression to =Fields!Department.Value, and then set the first text box value in the grouping to =Fields!Department.Value and the details row text values  to the Emp Name and ENo.  This would give you a sinlge departement to the left, although not centered:


                  Department   Emp Name        ENo

                         A               
                                          A1                666
                                          A2                555
                                          A3                444
                                          A4                215
                                          A5                845

    Hope this helps
    David Dye
    • Proposed as answer by Raymond-Lee Thursday, August 20, 2009 8:54 AM
    • Marked as answer by Jerry Nee Friday, August 28, 2009 9:47 AM
    Wednesday, August 19, 2009 10:55 AM