Solved

Supress or set visibility in crystal report 8.5

Posted on 2009-05-10
3
443 Views
Last Modified: 2012-05-06
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
0
Comment
Question by:Slythie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
ID: 24351627
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
 

Author Comment

by:Slythie
ID: 24351672
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
 

Author Comment

by:Slythie
ID: 24351838
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

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question