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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to stop Blank report goout or Conditionaly stop distribution.

Status
Not open for further replies.

Prchandra

Programmer
Nov 4, 2010
1
0
0
US
Fail the report by a formula field that devide by zero under specfic condition like no records return by query.
Devision by zero will fail report on infoview.
 
Divide by zero is not allowed, so test for a zero first. E.g.
Code:
if {Divisor} > 0
then {Some.Sum} / {Divisor}
else 0

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
Sorry, I took that for a question, but it seems you meant it as a tip.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top