Report Builder - Format Chart Y Axis

Is changing the display format of the Y axis of a column chart supported in the Sept CTP or is it going to be supported in the official release? For example I have built a report model with the numeric sales values set as 'C' for currency and have created a simple bar chart with year on the category axis and sales on the Y axis. The problem is that the Y axis displays as a general number (10000000) and would like to display it as a currency ($10,000,000). I can't for the life of me figure out how to display the Y axis as currency in Report Builder.
When I can create a report in BIDS and set the format to 'C' and upload it via the Reporting Services Web App the Y axis displays correctly.
I check the version of Report Builder I have installed and it is 9.0.1314.0.
Is this a know issue, bug, or not supported in this release of Reporting Services? Any help would be greatly appreciated.
Thanks,
Larry

This is true. If you format a field and display this field value on the point labels on a graph the format doesn't apply. In the Report Design if you go to the Chart properties -->Data Tab -->Values Edit --> Point Labels Tab-->there is an option "Format Code" to format the point labels. This isn't available in report builder.

Is there a work around?

Thanks, Susan

|||

I found a solution for my problem. I created a NEW field in Report Builder and I used the ROUND() Math function to round this field to two digits. I still think that you should be able to format the point labels in a graph in Report Builder. This is a bug.

Thanks, Susan