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 |
|
ste_pie87
Starting Member
2 Posts |
 Posted - 2008-06-21 : 11:11:10
|
| HiI have developed some line charts in reporting services with some parametrs On the bottom axis is the month and the upper is no. hours.The problem is that when i select certain parametrs becaus there is no data for that month the line just ends and then starts at a new month. Does anyone know anyway of telling it to go to zero if there is no data for it so there is a continous lineThanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-21 : 11:34:04
|
| If you have no data for those months you need to use a generic month table and left join it to your current query and use that data for oplotting, so that it returns the missing months also with 0 value. If you need more help, please post your current query. |
 |
|
|
ste_pie87
Starting Member
2 Posts |
Posted - 2008-06-22 : 18:02:54
|
| I do have data for those months its just that there are fiv/six series on the chart and twenty different parameters. Some of these parameters when selecetd do not have data for all months so some of the lines come to an abrupt holt and then pick up again when there is data. If i join this with the month table then it will have to do it 120 times (20*6) and *12 for months and it will create uneccessary dat in my tableI know there is a way in Excel for showing 0 values in a pivot table/chart. I was just wondering if there was something similar in RS so that if there is no data then the line will drop to 0.Thanks for your help |
|
|
|
|
|
|
Line Charts