Need assistance - please view attached image for view of the problem. Have my report all ready to go. Used the Report Wizard to generate the .rdl.
When I generate the report, I am able to modify formatting on any of the totals on the expanded information, but I cannot figure out how to modify the format of the system-generated SUM on the payment amount. This was entered in the VALUE box using the wizard. It's coming up as ######.#### and I want to only see two decimal places, not four. The reformatting works on the fields when you expand the results to see the details, but at the summary level, it's stuck at four decimals. THE UNDERLYING DATA CARRIES FOUR DECIMAL POINTS.
Report Builder Formatting