locked
Chart only displays 3 data points RRS feed

  • Question

  • I 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 4, 2013 4:59 PM

Answers

  • I 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.
    • Proposed as answer by Charlie Liao Tuesday, January 8, 2013 1:37 AM
    • Marked as answer by Charlie Liao Monday, January 14, 2013 2:53 AM
    Friday, January 4, 2013 6:50 PM
  • Also discovered that setting the interval to 1 causes the chart to display all axis labels.  That is actually what I needed.
    • Proposed as answer by Charlie Liao Tuesday, January 8, 2013 1:37 AM
    • Marked as answer by Charlie Liao Monday, January 14, 2013 2:53 AM
    Friday, January 4, 2013 7:03 PM

All replies

  • 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


    Cheers,
    Jason | www.SqlJason.com
    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

    Some Random Thoughts

    Follow me on Twitter

    Friday, January 4, 2013 6:42 PM
  • I 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.
    • Proposed as answer by Charlie Liao Tuesday, January 8, 2013 1:37 AM
    • Marked as answer by Charlie Liao Monday, January 14, 2013 2:53 AM
    Friday, January 4, 2013 6:50 PM
  • Also discovered that setting the interval to 1 causes the chart to display all axis labels.  That is actually what I needed.
    • Proposed as answer by Charlie Liao Tuesday, January 8, 2013 1:37 AM
    • Marked as answer by Charlie Liao Monday, January 14, 2013 2:53 AM
    Friday, January 4, 2013 7:03 PM