OK. Solved it.
My report also had some conditional formatting rules applied. It seemed that the conditional formatting rule had a strange format that was overriding the format of the field.
I removed the conditional formatting and the formatting displayed correctly.
I have a report that has a number of grouping levels.
I would like the highest grouping level to determine a new page.
How do i accomplish this?
Much thanks for any help received
Mrhopko
Hi All
I have created a report from a query. The report contains some numeric fields.
I have set the format of the numeric fields to #,###;#,###;0;0;
Despite this setting, my report is showing numbers as #.###
How can I solve this?
Much thanks for any help received
mrhopko