Solved

Suppress Lines in Crystal Reports 11i in Visual Studio 2005

Posted on 2010-11-29
6
763 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
  • 3
  • 3
6 Comments
 
LVL 100

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 100

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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 100

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

746 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now