Tuesday, April 22, 2014

Default current Month and Current year on Value prompt:


Solution:
 
Pq_Date (Prompt Query):

d_Date_Month_Use: Expression: month([Date])

d_Date_Month_Display: Expression: left(monthname([Date]),3)

d_Date_Year_Display: Expression: year([Date])
 
d_Date_Month_Final_Use: Expression:

Case
When [d_Date_Month_Use] = month(current_date) then 0
Else([d_Date_Month_Use])
End

 
d_Date_year_Final_Use: Expression:

Case
When [d_Date_Year] = year(current_date) then 0
ELse([d_Date_Year])
End
-----------------------------------------------------------------------------
Now add 2 Drop down Prompts: (Month; year) :
Month: Drop down prompt(Value Prompt)
Use Value: d_Date_Month_Final_Use
Display Value: d_Date_Month_Display
Add Default Selections: 0
 
Year: Drop down prompt(Value Prompt)
Use Value: d_Date_year_Final_Use
Display Value: d_Date_Year_Display
Add Default Selections: 0

  -----------------------------------------------------------------------------------
Main Query— add filter:
([d_Date_Month_Final_Use] = ?P_ Month?) and ([d_Date_year_Final_Use] = ?P_ Year?
---------------------------------------------------------------------------------------

No comments:

Post a Comment