on 03-31-2011 11:50 AM
Hi,
I want to show the current month as the default value in Prompt in XI R3.1 Webi. i.e. when the user runs the report, the prompt for "Month" should show the current month (Say March) and if user wants to change it he can change it to someother month.
Pls let me know how to acheive this (May be by doing changes to report or to the Universe).
Regards
Jim
You can try the below step in Universe
Steps
1.You have a date time field = u201CDateXu201D
2.Build another object of the same field in unv = u201CDate X New Objectu201D
code:
case When to_date (Sysdate, "MM") then "Current Month"
end
3.Build Condition in Unv = Date Picker
code:
@Select(Cass\DateX New Object) = @Prompt(u2019Date Pickeru2019,'Au2019,{u2019Customu2019,'Yesterdayu2019,'Last 10 Daysu2019,'Todayu2019},mono,constrained,persistent,{u2019Current Monthu2019})
You can take reference of the below
http://www.dagira.com/2008/07/15/how-can-i-make-today-my-default-prompt-value/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.