Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


If no data, then no report generated. How to do?

If no data, then no report generated. How to do?

I would like to create a report, that is generated only if there is data. If there is no data, then there is no report to be distributed.
I have Bus. Objects Edge, Crystal XI R2.
I heard a guy at the Oct 2009 Users conference in Dallas who did this. I can't remember exactly how he did it, but I think he created a report based on an Event.

Any ideas?
Thank you.

RE: If no data, then no report generated. How to do?

When there's no data, all data fields will be null. Test on something that won't normally be null. Use Selective Section Suppression.

Right-click on the section and choose Format Section. Then choose the formula icon (x+2 and a pencil) for suppression. Add a test, in your case null.

Do this for all sections and the report comes out blank.

yinyang Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP yinyang

RE: If no data, then no report generated. How to do?

Take a look at rolling your report into a publication. When scheduling publications, there is an option to not deliver the report if there is no data.

RE: If no data, then no report generated. How to do?

Another option is to create a formula that will raise an error if the data is null. The report will fail if there is no data, so there will be no distrubution.


A computer only does what you actually told it to do - not what you thought you told it to do.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close