Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Suppress Lines in Crystal Reports 11i in Visual Studio 2005

Posted on 2010-11-29
6
Medium Priority
?
776 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Screencast - Getting to Know the Pipeline

916 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