I have a Graph displaying data by the day - it has a set size that I do not wish to change, however I now have so many data points that the X-Axis labels are overlapping. Is there a graph setting that will show (say) onlyevery second or third label on the axis? Or perhaps dynamically calculate which to show based on how many data points are returned to it? If there are no report settings, I may need to calculate this on the SQL side of things, but this will reduce the data points I send to the graph (rather than just the amount oflabels shown), which is not really what I want. Thanksin advance, Mark

Look at number 16 on this link; it is really nice link to set up images and scale on reporting services... http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

Hi, Thats fine for a bar-chart by the looks of it, but it doesn't seem to be able to be applied to the specific problem i am having (unless i'm missing something). I don't want to set the maximum value for my x-axis (this would stop me seeing values above this limit), I just want to limit the number of labels displayed on the X-Axis so that they dont overlap. The graph scales itself to accommodate the new values, it just annoyingly overlaps the labels on the axis to the point by which they are incomprehensible. Cheers, Mark

U need to limit your dataset then...if you are having last 5 years data and if you need to show it in small graph by month then it should have 60 different labels...how it can display 60 label in small space? It is just an example....it is overlapping coz u haev too many labels to display....

Well, yes - i could limit my dataset, but then i'm losing granularity if I do wish to show it over that period (i may miss a significant peak or trough). I'd just like to display the data whilst applying a filter to the labels that are shown (such as every 5th label). Does that make sense? Cheers

In SSRS 2005 you can control number of labels shown using Axis Interval. You can use a simple value or expression. To find Interval follow this steps: 1) Right click on the chart and select Properties 2) Select X Axis tab 3) Set Interval field to 10. 4) Click OK to close the dialog. This will show X axis labels with interval 10. In SSRS 2008 we have more control over the axis interval. In addition to the Interval you can also specify the unit types of the interval (days, months, minutes ) and also origin offset. Let me know if my suggestion worked for you! Alex.

Thanks Alex, I'll give that a try tomorrow and get back to you. Much appreciated, Mark

Hi Alex, Works fine - thank you. Mark

hi guys,is there a way to specify an expression as an interval? I mean:Interval=IIf(a=b,1,2)This was possible in ssrs 2005. However it seems that it is not supported by ssrs 2008.Thanks a lot,mem.

Hi, Can anyone tell me the difference between the Primary and Seconday axis? I'm trying to fit more data onto the x-axis (using SSRS 2008) and can only affect the y-axis using the interval settings. SSRS 2005 instructions look straight forward enough but not so for 2008. Regards, Lee.