when you creating prompt under show label select 'SQL Results' and write the below code to choose year from week columns SELECT YEAR(week_column) FROM SubjectArea
after that come to Default to label-> SQL Results and write the below code to show current year as a default value. SELECT MAX(YEAR(week_column)) FROM SubjectArea Note: Replace week_column and subjectArea with your column name and subject area name respectively.
Hope it helps!
If you want to show current_year as default in week prompt then copy/edit the code below and paste it in default->SQl Results
select "Calendar"."Year" from "Subject Area" where "Calendar"."Year" in (YEAR(CURRENT_DATE))
Go--> Edit your prompt --> Click Default--> SQLResult--> Paste the below code.
SELECT case when 1=0 then cast(Your week column as int) else YEAR(current_date) end saw_0
FROM your subject area
Hope it help's
Edited by: Satya Ranki Reddy on May 8, 2012 10:32 AM
Edited by: Satya Ranki Reddy on May 8, 2012 10:33 AM
Edited by: Satya Ranki Reddy on May 8, 2012 10:34 AM