Bar chart chart reportviewer, wrong line width

Question

I had a problem with a report that is created using Report Builder 2.0, in the sql2008 database (the latest set of updates), report services version 10.0.5500.0.

The problem is that the bars are wider than they should be. Each bar should be 1 hour wide.

The x axis is configured with the interval set to hour , and interval value 1 minimum value =TimeSerial(0,0,0) and maximum value =TimeSerial(23,59,0) . The series has a CategoryField set to [hour] , a column of type time with the time of the hour (example 08:00:00.0000000 ).

Answer 1

What you are looking for is in the property grid under General → User Attributes → PointWidth First you must select a series. If you do not see the property grid, you need to enable it from the ribbon. Check the box next to the properties.

A number less than 1 will give gaps between the columns; a number greater than 1 will overlap the bands.

This is more of a relative width than with respect to your hourly interval, but you can adjust it to be correct. Personally, I would suggest that you have a little less than an hour, because they looked better with spaces.

barchart1.png

You should also set the labels on the horizontal axis vertically, and then rotate them to make them look a little better.