Tips and Tricks
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Tips and Tricks
Message Icon Topic: cancel report when no data found Post Reply Post New Topic
Author Message
ray fitz
Newbie
Newbie
Avatar

Joined: 16 Nov 2007
Online Status: Offline
Posts: 2
Quote ray fitz Replybullet Topic: cancel report when no data found
    Posted: 16 Nov 2007 at 6:19am
Does anyone know how setup a report with a message
that displays "no data found" and the report processing
will be canceled. You can do this Microsoft Access thru a macro,
but I have been unable to find a similar function with Crystal.
ray fitzgerald
IP IP Logged
IdoMillet
Groupie
Groupie


Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 99
Quote IdoMillet Replybullet Posted: 16 Nov 2007 at 1:25pm
Use the suppress attribute expression on a section with a text box saying "No Records Found"

The suppress expression can be something like:
NOT IsNull({column_name_that_should_never_be_Null})

- Ido
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
www.MilletSoftware.com
IP IP Logged
ray fitz
Newbie
Newbie
Avatar

Joined: 16 Nov 2007
Online Status: Offline
Posts: 2
Quote ray fitz Replybullet Posted: 16 Nov 2007 at 1:56pm
thanks   your response is very much appreciated. will give it a shot
ray fitzgerald
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.