blank row in cross tab

[Durango122]

Hello
cr 9.0
ms sql
i have a cross tab and i suppress the total collumn row
and i cant get the empty box to be remove
here is what my cross tab looks like
ex:
Column #1 name
column#2 name| total
row#1| row#2| @Amount| @sum_Amount
|Total_suppress | suppress|suppress

now i have no tal showing but the row still show up blank
i would like to be like this
Column #1 name
column#2 name| total
row#1| row#2| @Amount| @sum_Amount

Is it possible????????????????

thanks




Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[lbass]

Go to the customize style tab and check "suppress column totals".

-LB

 

[Durango122]

Hi -Lb
thanks for the replied.
I done that and it suppress the total
buttttttttt
the gritline still show.
i got this from bo
Total rows/columns within the cross-tab, due to inner groups, will remain as blank rows/columns as there is no way to completely suppress them

thanks



Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[lbass]

From your display, this doesn't look like the situation that BO is referencing. If it's just the bottom row, this will be totally eliminated by checking that option, along with the gridlines. If you have inner groups, you can also select them on the customize style tab->suppress subtotals. You shoudn't be using field suppression at all.

-LB