2 Chart Questions

[RichMcGillicuddy]

Using the Chart in Data Band as an example and I have multiple charts showing up successfully but I am working on refining the display of the reports. My questions are

1. For the chart axis labels, there is a format field. The list here is very different than the format options available for formatting a field. Is there a way to set the format to not show decimals, what is the format string for that? Also, if I want to have an hour only for a date time, I tried H, HH and it does not accept that as a format. is there a way to format the labels more?

2. For a clustered bar graph, I want to have the chart have values on the X-Axis of 0 to 60 and the dataset that I am providing will only have data for some of those slots. I set the range for the axis to auto, set a min and max and the values in the preview look correct but if my data only has 2 or 3 values, the are next to each other and not spread across the fixed (0 to 60) range that I setup. Is it possible to do what I am describing?

Rich

[HighAley]

Hello, Rich.

1. For the chart axis labels, there is a format field. The list here is very different than the format options available for formatting a field. Is there a way to set the format to not show decimals, what is the format string for that? Also, if I want to have an hour only for a date time, I tried H, HH and it does not accept that as a format. is there a way to format the labels more?

We use standard .Net Framework format string. The samples you could find on the MDSN. We have found some problems with datetime format strings and trying to solve them now.

2. For a clustered bar graph, I want to have the chart have values on the X-Axis of 0 to 60 and the dataset that I am providing will only have data for some of those slots. I set the range for the axis to auto, set a min and max and the values in the preview look correct but if my data only has 2 or 3 values, the are next to each other and not spread across the fixed (0 to 60) range that I setup. Is it possible to do what I am describing?

If you set the Range of an axis you should set the Auto property to false.

Thank you.

[HighAley]

Hello.

We have made an improvement in the formating.
The patch will be available in our next prerelease build from March 14.

Thank you.