Repeatition of rows in table box??

[narender123]

Hi Guys,

I have made a table box.In which I have done the calculation in script level.

in script

like

Tax_Code,

Tax,

If (Tax_Code='VT',Sum(Tax)) as amount

  from table1 group by Tax_Code,Tax;

Now in table box there is 15 dimention and 1 calculated dimention amount .

Table box looks like Below

Consignee_Name    city     Country     .......              amount

a                            XX           AA                                   5

a                            XX           AA                                     -

a                            XX           AA                                    -

b                           YY           BB                                 -

b                           YY           BB                                 10

Any Body tell what i have to do for remove duplicate row????

Thanks in Advance

Narender

[alexandros17]

It depends ...

Try to check in the last dimension the checkbox "suppress when value is  null" or in the presentation tab check the box "suppress zero values"

Hope it helps