SQL Server Performance

formatting subsections

Discussion in 'SQL Server 2008 Reporting Services' started by jassie, Apr 25, 2010.

  1. jassie New Member

    In a sql server report 2008, I want a report to show subcategory values as a grouping, but I want not certain how to set it up. The value for state will show up on its own line. The rest of the values under the state, with appear on separate lines,
    The report would look something like the following:
    state, record type, status category, sector
    Nebraksa
    15 cat2 ,NE
    28 cator5 ,SW
    63 statusgo ,N1
    Iowa
    16 statcat ,DE
    28 statblue ,N2
    Florida
    17 bluegree ,N4
    90 staton ,JH
  2. FrankKalis Moderator

    Is this question still open?
  3. Madhivanan Moderator

    Have you grouped the report using the feild state?

Share This Page