Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2010-04-25 : 23:18:12
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-26 : 00:49:18
|
| apply a grouping over state. place expression to get state name in group detail part. drag and drop a new table inside group footer and show other fields in it (record type, status category, sector)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
|
|
formatting options in SSRS 2008