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 |
|
gameort
Starting Member
4 Posts |
 Posted - 2009-04-07 : 11:35:05
|
| Hi I am trying to draw a line chart to show share prices for a company over a period of time. In the category axis properties i've set the interval to 1 and interval type to months. But when i run the report if it is only showing a period of a few months then only 1 of the months will show on the x axis. For longer periods, every so often it will skip a month on the x axis. Is there a way to make it show every month on the x axis. cheers |
|
|
gameort
Starting Member
4 Posts |
Posted - 2009-04-07 : 11:37:59
|
| I am currently using SSRS 2008 with BIDS 2008 |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-07 : 11:42:45
|
| do you have data for all the months? |
|
|
|
gameort
Starting Member
4 Posts |
Posted - 2009-04-07 : 12:37:55
|
| it misses out on weekends, but the problem is i get the data from the internet |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-07 : 13:01:29
|
| ok...but dont you have a standard calendar table to compare against and plot the values regarless of presence of data? |
|
|
|
gameort
Starting Member
4 Posts |
Posted - 2009-04-07 : 14:05:14
|
| im not sure how you mean. I just get the values from the database using a select query. then use the date for the x axis and price for the y axis. |
|
|
|
|
|
|
x axis on charts