hi, i have created a custom report that shows the balance sheet in USD. however, another user is viewing the exact same custom report and it shows the balance sheet in CAD. any ideas on why?

Check the Subsidiary Context on the footer area. You may have selected the consolidated one and he/she has selected the Canadian subsidiary