Is there an option to have the currency symbol on a textbox (or a column in a table/crosstab item) either fixed or floating. See attached image. The screenshot is from Crystal Report. In fixed format, the currency symbol is left aligned while the number is right aligned, which will give a look like an accounting book.
Fixed: Floating:
$ 1,000,000 $1,000,000
$ 1,000 $1,000
$ 210,000 $210,000
$ 50 $50
------------------- --------------
$ 1,211,050 $1,211,050
------------------- --------------
Fixed: Floating:
$ 1,000,000 $1,000,000
$ 1,000 $1,000
$ 210,000 $210,000
$ 50 $50
------------------- --------------
$ 1,211,050 $1,211,050
------------------- --------------