>Can I do his with the SQL I had created for the report, numerics of different lengths are also not compatible if I union two queries, I have to append 0000+fldname etc. to make them compatible.
>
>I want to sum the numeric fields in the report.

If the numeric fields that you want to sum are represented as strings in the report cursor, you could sum their VAL in the report (but be careful of formatting characters, which could affect the result of VAL). Another solution would be to create two columns in the output cursor, one being the numeric value, which you would use for summing, and the other being the formatted string of the same value, which you would use for printing.

If you need to UNION two cursors that have numeric fields of different sizes in a corresponding column, you could use STR or TRANSFORM in your SELECT statement to create a string of the same length in both cursors in lieu of the numeric fields.