Prev: Plot line on chart
Next: error from subreport
From: Wendy Elizabeth on 25 Apr 2010 23:11
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
From: Uri Dimant on 26 Apr 2010 01:36
Wendy

http://www.simple-talk.com/sql/reporting-services/beginning-sql-server-2005-reporting-services-part-2/



"Wendy Elizabeth" <WendyElizabeth(a)discussions.microsoft.com> wrote in
message news:9DBD0E6F-45F6-48B8-B653-56F2F419411C(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: Plot line on chart
Next: error from subreport