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 wouldn’t get “no data to fetch” errors, based upon running a particular report.
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!
Conditions on Values in Prompt
- Thread starter rlkemp
- Start date
Multiple ways. It is possible to define a construction that will always return a result to avoid getting the 'no data to fetch' error.
A second technique (depending on requirements) is to build a cascading prompt that shows values based on the first entered value in the prompt.
In general terms, adding a list of values to the prompt will avoid that a value is entered that does not exist.
When defining the prompt and list of values in designer you can add a where clause to the prompt to restrict values.
The last technique is probably where you are after..
Ties Blom
A second technique (depending on requirements) is to build a cascading prompt that shows values based on the first entered value in the prompt.
In general terms, adding a list of values to the prompt will avoid that a value is entered that does not exist.
When defining the prompt and list of values in designer you can add a where clause to the prompt to restrict values.
The last technique is probably where you are after..
Ties Blom
- Status
Similar threads
- Locked
- Question
- Locked
- Question