Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Group Column Headers Expand / Collapse
Author
Message
Posted Thursday, March 14, 2013 1:57 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 12:14 PM
Points: 228, Visits: 800
I'm trying to create a report structure in a Table with data a group as follows:


-Column Headers
-Main Data Row 1
---Group Header 1
---Group Data Row 1
---Group Data Row 2
---Group Data Row 3
-Main Data Row 2
---Group Header 2
---Group Data Row 1
-Main Data Row 3
---Group Header 3
---Group Data Row 1
---Group Data Row 2
---Group Data Row 3
---Group Data Row 4


I can't figure out how to get it to look like this. Instead it always comes out like this:


-Column Headers
-Main Data Row 1
---Group Header 1
---Group Data Row 1
---Group Header 2
---Group Data Row 2
---Group Header 3
---Group Data Row 3
-Main Data Row 2
---Group Header 1
---Group Data Row 1
-Main Data Row 3
---Group Header 1
---Group Data Row 1
---Group Header 2
---Group Data Row 2
---Group Header 3
---Group Data Row 3
---Group Header 4
---Group Data Row 4


I tried putting the Group Column headers with the Main Data Row, but it appears even if the drill down is hiding the rest of the data. I feel like this is report creation 101 but i'm struggling to figure this out or find any documentation that addresses the issue.
Post #1431240
Posted Friday, March 15, 2013 5:41 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 12:14 PM
Points: 228, Visits: 800
I figured out the problem, I had to recreate the Parent/Child group relationship, then add the headers there.
Post #1431851
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse