BusinessObjects Board

How to Schedule those reports only with Data

scheduling XI Scheduler
#17

No, I am not getting any SQL error or anyting.I scheduled the report with Data and No data still it can be scheduled into my Inbox.

So, Is there anyting I need to do to make this happen “Scheduled only those reports which has data”.

Thanks

Pooja

ktm :us: (BOB member since 2008-11-12)

#18

I asked if you got the error when running the report interactively (not scheduled).

case when count(Customer Number) > 0 then 1/0 end

I assume this isn’t a direct copy/paste, since there’s a space in the field name. But as it is, it’ll fail only when there is data.

joepeters :us: (BOB member since 2002-08-29)

#19

No, When i run the Query there is no SQL error.

I have customer Number Object, Payment and in the second query i have taken the measure which i created in the universe.

case when count(Customer Number) > 0 then 1/0 end.

When i ran the Query there is no effect.

FYI- we have Space in the Customer Number object.

Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

#20

What does the complete query look like?

joepeters :us: (BOB member since 2002-08-29)

#21

we have two query :

Query 1:

SELECT
Customer.CustomerID
FROM

Table…

Query 2:

SELECT
case when count(Customer.CustomerID) = 0 then 1/0 end
FROM

Table…

Thanks

Pooja

ktm :us: (BOB member since 2008-11-12)

#22

This query:


SELECT
case when count(Customer.CustomerID) = 0 then 1/0 end
FROM

Table.....

should fail if the table is empty, or the conditions produce no rows. You do not get an error? What do you get for a result in that column?

joepeters :us: (BOB member since 2002-08-29)

#23

There is no Query Corresponding to this Query.

Thanks

Pooja

ktm :us: (BOB member since 2008-11-12)

#24

That’s the result in the report? Or an error message?

joepeters :us: (BOB member since 2002-08-29)

#25

No Error At All.
Should I need to add any function, like Combined Query?
Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

#26

You are confusing me. What is this?:

joepeters :us: (BOB member since 2002-08-29)

#27

When I schedule this report it is successful.We just want to fail when data is not available in the report.

Thanks

Pooja

ktm :us: (BOB member since 2008-11-12)

#28

I understand that. If you want my help, you need to answer my questions.

joepeters :us: (BOB member since 2002-08-29)

#29

What is your questions?

Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

#30

joepeters :us: (BOB member since 2002-08-29)

#31

sorry actually i was also confuse that SQL error means I will get the SQL error so i have written the above post.

Sorry , if i have made you confuse.

Thanks

Pooja

ktm :us: (BOB member since 2008-11-12)

#32

So you do get an error message. That’s good. That is what will prevent the report from distributing when scheduled.

joepeters :us: (BOB member since 2002-08-29)

#33

But , When i schedule into the User In box I can see the reports into their folders.it is not failed.

Thanks

Pooja

ktm :us: (BOB member since 2008-11-12)

#34

So it fails when you run it interactively, but runs when scheduled? That doesn’t make sense. What do you get in the body of the report when the scheduled report runs?

joepeters :us: (BOB member since 2002-08-29)

#35

I did not see any data in the report but i can see the layout of the report.

It should fail schedule when I schedule right?

Thanks

Pooja

ktm :us: (BOB member since 2008-11-12)

#36

This link my help you

https://bobj-board.org/t/151998

aniketp :uk: (BOB member since 2007-10-05)