I have a deski report which uses a stored procedure. The sp has an input paramter of a date which I always want to populate with the current date and not prompt the user for this. Is there any way to dynamically set the value of the prompt using a report variable or passing in the CurrentDate function. I’m sure there must be a way to do this but just need the syntax.
Thanks in advance…
paulo (BOB member since 2007-09-27)
Hello Paulo,
Try this out:
In universe create a new object and in the select part use sysdate (for Oracle or corresponding value for other database) . The object wont parse as it is not referencing any table.
However it can be used in the report along with any other object without any issue. So in the query drag the prompt which you want to use and give equal to and do a select from Object and use the newly created object.Hope that helps.
Cheers,
Anshuman
anshubit@gmail.com 
(BOB member since 2007-07-03)
I can’t drag in a prompt as the query is based on a stored procedure. I need to pass a variable into the stored procedure prompt. If I can’t find a way to do this I’m just going to amend the store procedure.
paulo (BOB member since 2007-09-27)