Actually, I am doing a report which is hard to expain here, the report output for the accounts department is such that i have to do all tricks.they need the result side by side on a paper,comparitive result of this week to previous week.
select
to_char(GROSREV,'$99999,9999,999.99'))||''||to_char(GROSREV1,'$99999,9999,999.99')
if i do this, in the reportdesigner,the property is varchar2.

how do i convert this to number, so that in the reportdesigner,it is number only,so that i can play with formats inside the designer.

thanks