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: Friday, September 12, 2014 12:49 PM
Points: 16, Visits: 38
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: Friday, September 12, 2014 12:49 PM
Points: 16, Visits: 38
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:55 AM
Points: 1,952, Visits: 5,081
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: Today @ 6:53 AM
Points: 86, Visits: 2,355
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: Friday, September 12, 2014 12:49 PM
Points: 16, Visits: 38
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse