Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Urgent!!!!hide the rows

Status
Not open for further replies.

karnd

Programmer
Feb 1, 2003
190
US
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,
 
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
 
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,
 
Why not eliminate them in the record selection?

not(isnull({table.amount}))

-lw
 
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
 
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,
 
Hi,
Go with the record selection method ( KSKID's)
Why get data you do not want?







[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top