hi all

i have one .sql file which takes these parameters...

bdate,edate,mode

based on the mode i have to display the result in different levels

it is working fine, i have S and D values for mode

If mode is 'S' then we have to sum on some columns and also sum on report

If mode is 'D' then we have to sum on some columns and also sum on report also.

this is also working fine....prob is that

if i give S as a parameter it shows values for that query plus the report heading
for other Query also, this is because we used sum on report

If i remove that sum on report , it just shows valuse and report heading based on mode

So how can i go about it ....

More over i can't mix those two queries that's for Mode 'S' and 'D'

In Mode 'S' query we have groupby date but not in mode 'D'


Gtotal i used sum on report ...

Sample report ... for mode 'S'


S X Y

0 1 90
2 100
-----
Total 190
-----
1 1 50
2 50
Total -----
100
-----
GTotal 290

S D Y Z
------------------

Total --------

GTotal --------


These blank heading is for the query which we have for mode 'D' ....

So please let me know how can remove that ...blank..

thanks