I added a summary column to my crosstab report and set the Summary Header to display Total. When I view the report I don't get my text, instead I get the name of the field from the database. Even when I change the text on the label field it does not work. I also have an issue with the column formatting. It is set to 0.00 and I tried changing it to 0.## but it is still displaying the two decimal places.

Any ideas on how I can fix this?