Urgent!!!!hide the rows

[karnd]

Hi,

I have the following scenario:

in the Crystal Reports Detail Section- i have two rows but almost similar so basically amount field has one record with value(Eg:$1000) and another record without a value(Eg:Just blank) so i need to hide the record with out a value.

Could you please help me out with your valuable suggestions.

Thanks a lot,
Regards,

 

[lbass]

If it is truly null and not "suppressed if duplicated", go to the section expert->detail->suppress->x+2 and enter:

isnull({table.value})

-LB

 

[karnd]

Hi Lbass,

Appreciates that works but i have not mentioned properly that i have to hide the entire row no matters howmany fields and that they have the data.
So, only condition is if amount field is null then the entire row has to be suppressed or not shown those values.

Thanks for your help!

Regards,

 

[kskid]

Why not eliminate them in the record selection?

not(isnull({table.amount}))

-lw

 

[lbass]

You misread my post. If you go into the section expert and use the isnull({table.amount}) in the suppression area, it WILL suppress the entire row. This works differently than field suppression. Also, as kskid suggested, if you don't really need those rows in the report, remove them in the record selection formula.

-LB

 

[karnd]

Hi LB,

Yep,I got you after made changes as per you said and now it works.
It might also work as per KSKID.
Thanks for your help.

Regards,

 

[Turkbear]

Hi,
Go with the record selection method ( KSKID's)
Why get data you do not want?









To Paraphrase:"The Help you get is proportional to the Help you give.."