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 |
|
roy mm
Yak Posting Veteran
62 Posts |
 Posted - 2008-08-04 : 10:28:59
|
| Hello, I have a matrix with year and month as column headers.I'm sure you know the problem that when I don't have data to one of the month, I have a "jump" in my matrix (from April its jump to June).Is there a trick in RS to handle this except by changing my sql query and union it with all the month?Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-04 : 13:47:41
|
| nope. the trick is in your back end query you just need to bring a row with no data for each month along with your current data. then automatically matrix will show all the months. If you want more help post your query |
 |
|
|
roy mm
Yak Posting Veteran
62 Posts |
Posted - 2008-08-05 : 06:11:10
|
| Hi,Thanks for the reply.I was afraid that this will be the answer.Thats the way I know but I hoped that there is a better way in RS to do that with out adding lots of waste rows.Thank,Roy. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-05 : 13:35:54
|
quote:
Originally posted by roy mm
Hi,Thanks for the reply.I was afraid that this will be the answer.Thats the way I know but I hoped that there is a better way in RS to do that with out adding lots of waste rows.Thank,Roy.
Nope. not anything as far as i know. As what matrix does is to basically form groups out of data provided based on column specified and then show them as columns. |
|
|
|
|
|
|
fill all month in matrix