I used _screen.QtyPict for the qty format.

The clients can choose either '999,999.99' or '99,999,999' for its value.

in the whole application I always use trans(qty,_screen.QtyPict) for qty value.

But I have problem in the report designer, in the Group Footer, if I have:

trans(qty,_screen.QtyPict) => Calculation: sum

I will get '***' instead of value.

if I tried:

Expression: qty => Calculation: sum
Format: _screen.QtyPict

the report won't recognize it.

I did try to create a report variable: Tqty => Calculation: sum 'qty'
and in the Group Footer, I used trans(Tqty,_screen.QtyPict) => Calculation: Nothing, it works.

but I try to avoid this solution because somehow it conflicts with my another reporting tool.

is that any solution?

thanks for the help.

regards,

Jerry