August 27, 2014 at 11:12 am
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.
August 28, 2014 at 7:57 pm
Bump.
Curious if no one's responding because the request is not possible or because I'm not clear.
August 28, 2014 at 9:57 pm
Quick thought, isn't Merge Cells what you are after here?
😎
August 28, 2014 at 11:16 pm
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.
August 29, 2014 at 2:36 pm
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."
September 16, 2014 at 8:11 pm
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?
September 16, 2014 at 9:29 pm
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.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply