Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Suppress Lines in Crystal Reports 11i in Visual Studio 2005

Posted on 2010-11-29
6
Medium Priority
?
777 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 101

Accepted Solution

by:
mlmcc earned 1500 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

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…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Integration Management Part 2
Loops Section Overview
Suggested Courses

564 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