Does anyone have GL accounts in currencies other than their base currency. If so, how do you run balance sheet reports to show the balances in the account currency rather than base currency?

You can't run a balance sheet that shows balances in foreign currency only. Otherwise, it's not a balance sheet. You may be able to add an "Amount (Foreign Currency)" column to your balance sheet however.