Supress or set visibility in crystal report 8.5

Dear Experts,
I created a report with many fields on crystal report 8.5. I need some of the fields not to be displayed on the report when certain conditions are not met. (eg. I have fields to display number of items ordered, name of items and price for that item). However, if the user didn't order that particular item, i don't want this field to be displayed on the report. Is there a way to do it? Thanks for the help experts
SlythieAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
I assume you have the information in the detail section
Right click the detail section in the left margin
Click FORMAT SECTION
Click the formula button to the right of SUPPRESS
{QtyField} = 0

Anothe way would be to use a select statement
{QtyField} > 0

mlmcc
0
 
SlythieAuthor Commented:
Yes, i have all the information on the detail section. It is listed vertically. I got the suppress thing right and now the problem is, if i suppress one of the items which is number 2 or 3 in the list, then there will be gaps in between before the next item is displayed. How to get rid of those gaps? there's no (No-Drill down) option to use is there? thx mlmcc
0
 
SlythieAuthor Commented:
ahh nvm.. i got it working, i simply need to put each item on the list on separate details section and suppress each details when i dont need it. thx u mlmcc...
0
All Courses

From novice to tech pro — start learning today.