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!

fail report sending result

Status
Not open for further replies.

nattyborneo

Technical User
Feb 1, 2011
29
0
0
DE
hallo,

does anyone know how to fail sending report if report is suppresed because contain no data?

thanks
 
Dear all,

I have one report and result could be changing, like :
1. only one result where
sum row a coulumn a = 0.00
sum row a coulumn b = 0.00
2. only one result where
sum row a coulumn a > 0.00
sum row a coulumn b = 0.00
3. there are several results where
sum row a coulumn a = 0.00
sum row a coulumn b = 0.00
sum row b coulumn a > 0.00
sum row b coulumn b = 0.00
4. there are several results where
sum row a coulumn a = 0.00
sum row a coulumn b = 0.00
sum row b coulumn a > 0.00
sum row b coulumn b = 0.00
sum row c coulumn a > 0.00
sum row c coulumn b > 0.00

I want to make if function if condition 1 or 2 or 3 fulfill
then failed the report

for ex :
if sum coulumn a > 0.00 and sum coulumn b >0.00
then 0
else sum coulumn a / 0

but the reports always fail even true result coming.

somebody help me please..
thank you

rgds,
Nat
thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top