we have daily transactions for our business. can i display a prompt where we can select a single day or duration of days or default ( all days in a week)
where we can see the transactions for that corresponding day(s) ?
Can anyone please tell me how can we achieve this ?
If I understand correctly, you want three prompts that show up at once, and, depending on the selection in the first and second prompt, you want the LOV for the third prompt to be filtered accordingly. Is that correct?
There’s no way to accomplish this, as the LOV is generated, not based on the values chosen in another prompt, but based on the LOV query created by the Designer.
So, the only way to accomplish this would be with VBA.
Hi
No need of change of LOV’s.
we can have LOV file containing month, week, dates.
i want to keep 3 prompts
user can give response to any prompt …for the first prompts he can select date
for the second prompt, he has to select 2 dates…for the durations of dates.
for the third prompt, he has to select a week id …so that all days in that week will be displayed in the report
OK, I think I finally got it. You want all three prompts to be optional. User can fill in only 1 prompt and still get the data.
See this FAQ about how to get ALL included in your prompt options. Then, run your report, selecting ALL for all three prompts. Publish the report that way. Then, when a user runs the report, the prompts will still have ALL in them, and the users can change the one that they want, leaving ALL in the other two.
I’m trying to implement the solution in the designer FAQ regarding allowing the user to enter * or ALL in a prompt. Below is a copy of my code. I’m getting a “Missing right parenthesis” error message and can’t figure out for the life of me why. Got any ideas? I’m working with designer 5.1.7 and Oracle 8.1
(@Select(Project\Employee Name) IN @Prompt('Select employee(s) or
enter * for all employees','a','Project\Employee Name',multi,free) )
OR
('*' in @Prompt('Select employee(s) or enter * for all employees','a','Project\Employee Name',multi,free))
Thanks,
Shelley
[added bbc CODE formatting for better readability - Andreas]
(@Select(Project\Employee Name) IN @Prompt('Select employee(s) or
enter * for all employees','a','Project\Employee Name',multi,free) ) OR
('*' in @Prompt('Select employee(s) or enter * for all employees','a','Project\Employee Name',multi,free))
The actual definition of Project\Employee Name is:
Open the properties for your object (the one where you use the @Prompt function) in Designer, in the Select box click the double arrow to the right, then check the box “Show object SQL”
(TRIM(EMP_PROFILE.LAST_NAME)|| ', ' || EMP_PROFILE.FIRST_NAME || ' ' || TRIM(EMP_PROFILE.MIDDLE_INITIAL) IN @Prompt('Select employee(s) or
enter * for all employees','a','Project\Employee Name',multi,free) ) OR
('*' in @Prompt('Select employee(s) or enter * for all employees','a','Project\Employee Name',multi,free))
This is sometimes caused by having reserved words “embedded” a field name. Can you try a different field temporarily (maybe NAME is a reserved word) and see if that parses?
Are you getting this error when trying to run a query in Business Objects Reporter? If so, please post the complete SQL code generated by Business Objects so we have something to go by
If you get this error when parsing the predefined condition on Designer you will have to do basic troubleshooting: Start with smaller code and add piece by piece to identfy which piece of code is causing the error.
OK:
What kind of object? Dimension, detail, measure or predefined condition?
What is the exact SQL code throwing this parsing error?
Is this SQL code part of SELECT or WHERE?