Solved

Suppress Lines in Crystal Reports 11i in Visual Studio 2005

Posted on 2010-11-29
6
774 Views
Last Modified: 2012-05-10
Hello Experts,

I'm stuck in Crystal reports 11i working in VS2005 IDE, where I need to suppress line, if I have no data coming from my stored procedure.

Currently, I get empty lines , which make report look odd. I tried the check box and had the formula to suppress still doesn't work.

Anything else I need to do??
0
Comment
Question by:ASPDEV
[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
  • 3
  • 3
6 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 34234788
Are there fields in the section?

try suppressing with a formula like

IsNull({SomeField})

mlmcc
0
 

Author Comment

by:ASPDEV
ID: 34234908
I have Dept  table, I check if Dept_id ="001" then show the record in the section else hide.

Hide is working, but cannot suppress the lines.
e.g
001
002(HIDE)
003

It should be:
001
003
 
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 34235761
Do you have graphic lines?
The only way to suppress a line is to suppress the section.

mlmcc
0
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

 
LVL 101

Expert Comment

by:mlmcc
ID: 34287846
If that isn't the solution then why should you accept it.

mlmcc
0
 

Author Comment

by:ASPDEV
ID: 34288030
Sorry.
0
 

Author Closing Comment

by:ASPDEV
ID: 34288037
Thanks!
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Suggested Courses

624 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