Cell from table within each row

  • 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.

  • Bump.

    Curious if no one's responding because the request is not possible or because I'm not clear.

  • Quick thought, isn't Merge Cells what you are after here?

    😎

  • 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.

  • 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."

  • 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?

  • 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