Issue:
After converting my reports (created in 2005 version) to SSRS 2008, one of my reports had an issue on X- axis with line and bar charts disappearing values on randomly basis (see screen shot). This report shows MS Project schedule tasks information with time line showing in Gantt chart. Initially, I thought that it will be resolved after updating height adjustments but no luck. I realized that the Chart control's configuration/properties in SSRS 2008 have been changed what I had in 2005 version.
Solution:
After a couple of hours investigation, I found a solution that helped me to fix this issue as follows
1- Right click on X-axis and click “Axis Properties”
2- In the "Category Axis Properties", do the following
· Under the "Set Axis Scale and Style" section, there is a check box named "Enable variable interval” displaying underneath “Interval” field, enable this check box
· Enter “1” in the “Interval Type” drop down values. “1” means "default" setting. Click OK.
(See the attached screen shot below)
3- Run the report and it will fix the missing gap on X-axis and show the correct field as below
Note: Bar chart offers now dynamic height and width changes properties in the SSRS 2008 version which was not available in version 2005. You can create expressions to adjust height and width dynamically (i.e. on run time) based on the number of available data...I liked the new flexible Bar chart in SQL Reporting services 2008 BI.
Hope it helps!
