A couple SSRS tips

A co-worker of mine, Tina, gave me a couple of tips for SQL Server Reporting Services - so I thought I would publish them to help myself remember and to be of help to anyone else who is reading.

• When exporting to Excel, we found that Excel was showing 3 decimal places instead of 2 even though I had formatted the fields to C2.  By changing the format to $0.00 instead eliminated the extra decimal place in Excel exports.
• Also by changing the background color to White rather than transparent, then scrolling headers would work properly.  Otherwise, the data would run into each other as the user scrolled through the report.