Just show Currency Symbol instead of CAD in front.

Description - When you are in reporting it gives you the option to display currency or number fields with a $1,234.00, but when you actually run your reports or views, it will show CAD1,234.00. There should be an option, even in the Project Preferences, to set a symbol that can be used so it can match what options are available. 

Why is this feature important to you - It is cleaner looking and more efficient.