INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

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.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I have never been to any technical site that shows concern just to anybody with problems...I look forward to also share in the future..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Reporting Solutions > Business Objects:Crystal Enterprise Forum

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

Read More Threads Like This One

starbase59 (MIS)

11 May 12 16:31

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.

Madawc (Programmer)

14 May 12 10:23

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

briangriffin (Programmer)

14 May 12 11:22

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.

hilfy ( IS/IT--Management)

29 May 12 11:25

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.

-Dell

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

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!

Back To Forum

Back To Business Objects:Crystal Enterprise