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!

Filtering zero valued records in crystal reports

Status
Not open for further replies.

smartlife

Programmer
Jul 15, 2011
6
US
I want to take out all the rows which has total values as zero.

Ex: I am getting ten rows from database and they have a column 'Total' and 5 rows have 'Total' as Zero,I don't want to display those rows in Crustal report.

Any help is really appreciated.
 
Use a record selection formula like:

{Total} <> 0



[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