SSRS 2008 R2 Line Chart (any kind): line jumps/skips data points and then loops back
Steps to re-produce the behavior: · Add a New report item. · Add a Dataset with following data. · sers catg datp 2007 13 12 2007 14 10 2007 18 2 2007 19 3 2007 20 8 2007 21 2 2007 22 5 2007 23 4 2007 24 6 2007 25 2 2007 26 2 2007 28 3 2007 29 4 2007 30 1 2007 31 2 2007 32 2 2007 33 4 2007 35 2 2007 36 4 2007 37 2 2007 38 2 2007 39 1 2008 13 1 2008 15 1 2008 16 3 2008 17 2 2008 18 2 2008 20 1 2008 21 3 2008 28 1 2008 29 4 2008 30 2 2008 31 1 2008 32 6 2008 33 1 2008 34 1 2008 35 5 2008 37 8 2008 38 2 2008 39 2 · Add a Chart control into the report. In the popup Select Chart Type dialog, select Line with Markers and then click OK. · Click the chart twice and when the Chart Data pane is displayed. Drop datp in data fields area. Right Click datp and select Series Properties... Change [Sum(datp)] to datp in Value field: Select [catg] in Category field: Click OK Drop catg in category fields area. Drop sers in series fields area. · Right click X-Axis (Catg Axis) Specify 1 as Interval: Click OK Preview the Report: Please See how for 2008 series the line jumps from 13 to 18 skipping 15,16 and 17 then jumps to 34 skipping 20, 21, 28, 29, 30, 31, 32 and 33 and so on. Finally it comes back to 15 from 39. Please advise. Thanks Amarjot Singh
December 30th, 2010 5:02pm

Hi Amar, To solve the issue, you can add a sorting on the category field. Right click the catg Category in the "Drop category fields here" and select "Category Group Properties", on the Category Group Properties box, click Sorting and click Add button to insert a sorting row, select Fields!catg.value as the sorting column and "A to Z" as the order, then the chart will be ok. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
January 2nd, 2011 11:02pm

Hi Amar, Honestly speaking, it's hard to explain the cause.When i reproduce your issue in my reporting environment, i found the chart X-Axis was messed. So i order it with setting its sorting, then the x-axis order was ok and the issue you mentioned also was gone. I ever tried to give an explanation for this issue but did not find the exact reason. If you have to want it, you can call microsoft customer service for this help. thanks, Jerry
January 3rd, 2011 10:59pm

Hi Jerry, Thank you! Sorting fixed the issue. It is interesting though, that it requires sorting at the group level since I already have the catg field sorted. So is this by design or should we report it as a bug? Thanks Amarjot Amarjot Singh
Free Windows Admin Tool Kit Click here and download it now
January 3rd, 2011 11:12pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics