on 2008 Sep 10 5:57 AM
Hello,
I am using Business Objects Desktop inteleigence 11.5.0.0
Every morning we run a report for the previous day.
In my query i say date is greated than equal to and date is less than eual to. both of them are prompts. example today is 10-Sep-2008, i will give 09-Sep-2008 00:00:00 and 09-Sep-2008 23:59:59
I want that every time any user launchs this report in the prompt screen insetad of us typing the date ranges, i would like it to have a default value of yesterdays date.
Hope you can help. I am brand new to BO.
Appriciate !
Prakash
Prakash, I believe ability to change a prompt value dynamically is only available in Crystal Reports.
George
Edited by: George Pertea on Sep 10, 2008 5:56 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Prakash,
Have a look at SAP-Note 1207448 - How to automatically fill the date prompt with the current date. It describes two ways to do that:
1. Create a macro.
2. Use the query-on-query function instead of a prompt.
Ilse
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
you can create an object in the universe called todays date which is defined with current date
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.