Friday, January 04, 2013 4:59 PMI know my way around reporting services pretty well but just recently asked to create a chart for the first time. I am using the same query from another report that display about 50 pages of data. When I put it in the chart it should have about 30 labels across the horizontal axis each with 3 points of data. Instead I get only 3 of the 30 labels with 3 data points for each of those. They were originally displayed in a reasonable format when I created the chart on 8X11. Then I expanded the page to 20 inches wide and stretched out the chart to see the rest of the data. Instead of adding more data it took those three labels and grew them to font size 20 or so and displayed the same amount of data. I've checked the all the autofit settings are enabled but the chart is not showing any more data. I'm sure I'm missing something simple that just isn't well documented. Any ideas?
Friday, January 04, 2013 6:42 PM
Can you paste a picture of what you are trying to see? Also, can you tell what you need to show on the x-axis, what on the y axis, etc? And what chart?
Also see this link on how to build a chart- http://msdn.microsoft.com/en-us/library/dd239351.aspx
Jason | www.SqlJason.com
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Friday, January 04, 2013 6:50 PMI discovered that it works better to aggregate the values in the chart rather than in the stored procedure by specifying the field to calculate. When I specified a value that was already calculated I guess it might have been having a problem creating the Y-axis. When I added a series group then it displayed a lot more data points.
Friday, January 04, 2013 7:03 PMAlso discovered that setting the interval to 1 causes the chart to display all axis labels. That is actually what I needed.