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

Cell from table within each row Expand / Collapse
Author
Message
Posted Wednesday, August 27, 2014 11:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, November 16, 2014 7:27 PM
Points: 20, Visits: 60
I have a query with the top 25 records that I need to display and I can create a table in SSRS and display these but the problem is I need to display one of the fields from each row underneath each ssrs table row.

so a normal table looks something like this:
__________________________
| Val1 | Val2 | Val3 | Val4 | Val5 |
__________________________
| Val1 | Val2 | Val3 | Val4 | Val5 |
__________________________
| Val1 | Val2 | Val3 | Val4 | Val5 |
__________________________


And I'm trying to get it to look more like this:


_____________________
| Val1 | Val2 | Val3 | Val4 |
-----------------------------------
|- - - - - - - Val5 - - - - - - - -|
_____________________

_____________________
| Val1 | Val2 | Val3 | Val4 |
-----------------------------------
|- - - - - - - Val5 - - - - - - - -|
_____________________

_____________________
| Val1 | Val2 | Val3 | Val4 |
-----------------------------------
|- - - - - - - Val5 - - - - - - - -|
_____________________


***** EDIT: added the dashes by Val5 to keep the width of the column.
Post #1607948
Posted Thursday, August 28, 2014 7:57 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, November 16, 2014 7:27 PM
Points: 20, Visits: 60
Bump.
Curious if no one's responding because the request is not possible or because I'm not clear.
Post #1608471
Posted Thursday, August 28, 2014 9:57 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:33 PM
Points: 2,533, Visits: 7,097
Quick thought, isn't Merge Cells what you are after here?

Post #1608483
Posted Thursday, August 28, 2014 11:16 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 10:04 PM
Points: 99, Visits: 2,620
If I understand you correctly this should be quite easy.
I understood that you want to have second detail row for val5 for each detail row. If this is correct then you just need to insert row inside detail group below current detail row. Then just merge cells you want. You might also need to move group below detail group to make some room for extra row.
Post #1608492
Posted Friday, August 29, 2014 2:36 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, November 16, 2014 7:27 PM
Points: 20, Visits: 60
Ville-Pekka Vahteala (8/28/2014)
If I understand you correctly this should be quite easy.
I understood that you want to have second detail row for val5 for each detail row. If this is correct then you just need to insert row inside detail group below current detail row. Then just merge cells you want. You might also need to move group below detail group to make some room for extra row.


That's exactly what I'm looking for Ville-Pekka. Is there a way to repeat the headers of the table for every Group?

And I'm not sure exactly what this means "You might also need to move group below detail group to make some room for extra row."
Post #1608748
Posted Tuesday, September 16, 2014 8:11 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, November 16, 2014 7:27 PM
Points: 20, Visits: 60
Bump
I'm still looking to see if there's a way to repeat the headers of the table for every Group? Is this possible?
Post #1614284
Posted Tuesday, September 16, 2014 9:29 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 10:04 PM
Points: 99, Visits: 2,620
Do you have any groups in report yet?
If so then you just need to set group header section visible.
If you don't then just add ROW_NUMBER to your query and group by that field in the report.

Or then you can just add one more detail section above earlier two and put headers there so headers will be shown for each detail row. But I would prefer using groups.
Post #1614287
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse