SQL Server Performance

Supressing Group Headerwithout supressing detail

Discussion in 'SQL Server Reporting Services' started by mamikel, Apr 19, 2004.

  1. mamikel New Member

    Hi,

    in crystal, if you hid the group header, the detail would still show.

    In SQL reporting services table with one group and one detail line, hiding the group header also hides the detail. Is there a way of making sure the detail is shown even when the group header is hidden?

    thanks

    Matt
  2. ssp320 New Member

    check off Include group header in properties
    Thanks
  3. mamikel New Member

    Hi,

    thanks for the reply. Obviously I need to supply more information (or perhaps I'm misunderstanding what you meant).

    The group header is to be shown conditionally - depending on what the user supplies to an input parameter named ShowGroupHeading. I set the group header visibility to an expression which inspects this variable.

    The problem is, when the header is hidden, the detail is hidden and vice versa. I need the report to always show the detail irrespective of whether the group header is visible or not.

    thanks again

    Matt

  4. mamikel New Member

    I thought I'd post this in case other users have the same issue.

    Right-clicking a row on the table to bring up the properties dialog and putting an expression against the group visibility shows/hides the group accordingly. However, to affect just a single row (or in my case the group header) - the row needs to be selected and the visibility set in the standard properties box. I.E. two different places. Hope that's clear

Share This Page