I am running Business Objects 5.1.9. I hope I ask this question correctly. Is it is possible to set conditions on the Values prompt, similar to the where conditions in the SQL, of the resulting report? The objective would be so that user wouldnt get no data to fetch errors, based upon running a particular report.
RandyLewisKemp (BOB member since 2007-02-07)
Is it possible to use an @prompt instead of an @variable in your select statement?
With @prompt you can give values to choose from by the user.
SilentBob 
(BOB member since 2006-09-28)
If I understand correctly, you want to apply where condition to the values in the LOV?
Then go to the object properties which the prompt is based on, press Edit and apply required criteria in the condition pane. Press Ok, export universe. Thats it.
HTH
hyder
haider 
(BOB member since 2005-07-18)
If you want to avoid “No Data to Fetch” error messages, then there are lot posts on this topic already been discussed in forum. Also check the FAQ’s in the forum on how to avoid these error…
you can start with this thread:
https://bobj-board.org/t/15226/19
Use keyword/terms : No data to fetch
Hope that helps.
BO_Chief 
(BOB member since 2004-06-06)