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 |
|
Primaryracer
Starting Member
2 Posts |
 Posted - 2009-05-14 : 10:28:50
|
| SQL 2005 has brilliant Pivot function and this helped me a lot in solvin my problems. Now when i can display my data in a very nice and tiday way, I'm havin problem displayin the same data in Charts, here is the code and outputSelect * From (Select FinYear, FinMonthNm, LoS From Surgery) BS PIVOT (avg(LoS) For FinMonthNm IN ([Apr],[May],[Jun],[Jul],[Aug],[Sep],[Oct],[Nov],[Dec],[Jan],[Feb],[Mar]))P This display data as below which is great, but when i add these months in my Chart i get this error "RowIndex Property Value Should be in range from 0 to 10".. I there anyway i could group these months as one series in this function Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar2007/08 8 8 7 8 15 8 18 9 8 7 7 82008/09 17 11 8 12 10 14 15 12 38 8 12 162009/10 9 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-14 : 10:31:32
|
| are you using the chart control in sql reporting services? what all are categories and series you choe? |
 |
|
|
|
|
|
|
|
Help with SQL Pivit Function values to Design Char