issue with group by

[abbaskhan]

I have four columns in a table called rpot1(on overdraft bank a/c)
Actually it is a reporting table
1)sum(os)---outstandings(sm_os)
2)sum(lmt_gap)---limit gap (limit allowed for overdraft-actual overdraft taken)
3)lmt_bnd_----(outstanding in each limit band i.e 100-200,200-500 etc)
4)lmt_bnd_lmtgap(outstanding in each limit gap )


OUTPUT
OS_BND LMT_GAP_BND SM_OS SM_L_G

bnd_1 -25755419
bnd_2 25650968
bnd_3 53983065
bnd_4 238107406
bnd_5 269816479
bnd_6 4632194812
NOLMT NOLMT 5733753644 5193997310
bnd_1 8231633
bnd_2 51784857
bnd_3 108944365
bnd_4 218809561
bnd_5 220968795
bnd_6 5125014433

you can see my result i am getting some blank fields which are giving me
problem when i am dumping this date into crystal report since crystal report
does not accept string values(blanks it is assuming string since blanks are null)
can you suggest me an idea so that i can put all the four columns in one line
i know by doing this my data will get corrupted but i need it only for reporting purpose
hope you understand my problem
bye.

[shezam]

Hi,

you can simply concat the results from each column into one

I have four columns in a table called rpot1(on overdraft bank a/c)
Actually it is a reporting table
1)sum(os)---outstandings(sm_os)
2)sum(lmt_gap)---limit gap (limit allowed for overdraft-actual overdraft taken)
3)lmt_bnd_----(outstanding in each limit band i.e 100-200,200-500 etc)
4)lmt_bnd_lmtgap(outstanding in each limit gap )


OUTPUT
OS_BND LMT_GAP_BND SM_OS SM_L_G

bnd_1 -25755419
bnd_2 25650968
bnd_3 53983065
bnd_4 238107406
bnd_5 269816479
bnd_6 4632194812
NOLMT NOLMT 5733753644 5193997310
bnd_1 8231633
bnd_2 51784857
bnd_3 108944365
bnd_4 218809561
bnd_5 220968795
bnd_6 5125014433

you can see my result i am getting some blank fields which are giving me
problem when i am dumping this date into crystal report since crystal report
does not accept string values(blanks it is assuming string since blanks are null)
can you suggest me an idea so that i can put all the four columns in one line
i know by doing this my data will get corrupted but i need it only for reporting purpose
hope you understand my problem
bye.