Being a crystal guy this is normally easy in that tool. is it possible for the end user developer of a webi report to create a prompt that functions as an “in list” or “all” option without putting the logic on the universe side? any help here will be greatly appreciated
Initially we defined a condition for the ALL and when we used it in the report it worked but would not allow us to select individual values (apparently a condition cannot prompt with a list). The next thing tried was to modify the SQL for the object with the detailed listing (LOV) to add the code:
UNION
SELECT ‘ALL’
FROM
After this the check box that says “Do Not Regenerate SQL” was checked. This allowed us to select ALL or individual values but the ALL did not return any values (seemed that the condition was not being used with this method), individually we had values returned. The final thing tried was to combine the ALL object with the detailed listing object and then use the detailed listing object in the report. This allowed us to select ALL or individual values but the ALL did not return any values (seemed that the condition was not being used with this method), individually we had values returned.
Does anyone know how to have the “ALL” return values?
It should work perfectly, step 1 is to include the UNION in your LOV’s and step 2 would be Prompt syntax given in the Designer FAQ. Let us know if you still have problems…