Print Page | Close Window

cancel report when no data found

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1694
Printed Date: 24 Apr 2024 at 9:04pm


Topic: cancel report when no data found
Posted By: ray fitz
Subject: cancel report when no data found
Date 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


Replies:
Posted By: IdoMillet
Date 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

Posted By: ray fitz
Date Posted: 16 Nov 2007 at 1:56pm
thanks   your response is very much appreciated. will give it a shot

-------------
ray fitzgerald


Print Page | Close Window