April 23, 2009 at 10:57 am
I have the following table (PROGRAM, SCHOOL, ACCOUNT, AGE)
Programs such as AA, AB, AC, AD etc.
Schools such as Evans Middle School etc.
Account = student ID
Age - age of the student
---
I need to create a report with the PROGRAMS across the top and The SCHOOL by AGE RANGE down the side.
School by age range would look something like this:
EVANS MIDDLE SCHOOL
0-5
6-12
13-17
and so on for each school.
Any ideas? Thanks in advance.
April 23, 2009 at 11:09 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 23, 2009 at 11:11 am
From what you're describing, you can achieve that pretty easily with a pivot table, either in SSRS or in Excel.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 23, 2009 at 11:49 am
true, pivot table may be the way to go. thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply