I wonder if I have found a bug in Report Writer. I have created a custom SQL report (by copying a canned report) to include the custom property for Region. The report shows individual node availability and also groups the nodes by the assigned region. I wanted to also have the report calculate the overall availability for the region, so I inserted the SQL to do so successfully.
The problem I am having is that the formatting options I choose on the Field Formatting tab are not being saved for the region availability field that I manually inserted into the report. When I open the custom report I notice that the Format indicates Numeric Data as it should, and the Format String and Units are set to 0.00 and % respectively as they should be. But, when I execute the query those settings are set to default.
What is happening? By the way, the report formatting holds on the website.
