Row level hidding in Deski report

[Former Member]

Hi

We are trying to hide rows based on condition in Deski report, 

Column 1      Column 2

     1X                 A

     1X                 B

     2X                 A

     3X                 B

OUTPUT in the report has to be like below.

Column 1      Column 2

     1X                 A

     2X                 A

     3X                 B

If we have two records for column1 for 1X,1X , it has to disply only one record in the report  A, the B value must be hidden.

Please give your valuable inputs and solutions

Thanks

Arun K

[CdnConnection]

Arun,

   You need to have clear business rule that fully explains when duplicate row is to hidden.  Once a clear rule has been defined BLOCK filter to hide data that is based on the clear business rule.

Thanks Kindly,

Ajay

[Former Member]

Hi Ajay,

Thanks for replying

But the business rule is clear, and here I need only one out put for 1x. based on condition

Like if i have two value for column2 for 1x, then  we have to display only A, that is

1x    A

...  Please sugesst , what can be done at report level.

Regards

Arun

[CdnConnection]

Arun,

     The best way to put this in some sort if business rule is as follows.   If column 1 count is greater than 1 then only show column 2 where data is A.   Without knowing your data, this is the best the recommend.

Ajay