Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how can i stop blank reports being sent out in crystal server 2008

Status
Not open for further replies.

toniescott

Programmer
Feb 9, 2010
1
GB

hi
I have a large number of reports being sent out through the scheduler in crystal reports server 2008
These reports are being scheduled from every 10 mins to once a day
The problem is that some of the reports will at times be blank I need to know how I can stop these reports being mailed out and only if the report has data on it fo9r it to be mailed out to the users


Please can you help in how I can stop these reports being sent?
 
I'm going to assume that Crystal Reports Server works a lot like Crystal Enterprise.....
In your report put a new Report Header. LEAVE IT TOTALLY BLANK and check mark "new Page After" in your Section Expert. If you display page numbers in your report, replace with a formula "pagenumber-1"
In Crystal Reports Server, Export to Adobe Acrobat with a Page range = 2 to 9999.

If there is no data, the report will fail and no email will be sent out. The failure message will be "The specified start page is greater than the last page on the report."

DataDog [pc2]
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top