Report Builder - Formatting numeric output - help

Hi -

I've worked a lot with SSRS 2000 - just starting with 2005. Report Builder is very cool. I build a Report Model - then built some reports biased on the model - all went well including filtering until I attempted to format the numeric data - specifically monetary data. I right clicked on the field in the designer and format was an option - but when I select format - all the numeric options are grayed out an unelectable.

The really interesting this is that if I then create a calculated field biased on tow of the numeric fields - like Total Sales Amount \ Total Orders - I CAN then format that new calculated field field. So - of course I then attempted to alter the formula of on of the base fields - like Total Sales Amount = Total Sales Amount * 1 to see if that would work - no - it did not.

I am stumped?

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

|||

Jim From Florida wrote:

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

Is this a matrix report baised on a Report Mode for ad hoc reporting - or a regular report matrix? I have had no problems formatting fields in regular matrix reports...

To answer your question - I have not resolved the Ad Hoc report model formating issue...