Hello, I am new to webfocus and trying to figure out dynamic way to filter month based on year selection.

My report have two parameters &year and &month.
on launch HTML page when user chooses a drop down list year as 2007 it should filter out entries in second dropdown list and display just jan,feb,mar,apr,may . I have referred to previous posts about chainlinking but it didn't work for my case. Please suggest. I can upload my code if any one likes to see.
Thank you,

Hi Tkota,

uploading the code helps and upgrading your signature with the versions you're working with would help too.

tkota,

Welcome to Focal Point!

Hopefully this code will get you going in the right direction:

-* Set reference year
-SET &MYYEAR = 2007;

-* Get current year and month in numeric format
-SET &CURRYEAR = &DATEYY;
-SET &CURRMONTH = &DATEM;

-* If we are not in the current year, load all months in array, otherwise
-* only load array for months that have occurred this year
-SET &CURRMONTH = IF &MYYEAR NE &CURRYEAR THEN 12 ELSE &CURRMONTH;

-REPEAT :MONTHLOOP FOR &IDX FROM 1 TO &CURRMONTH

-SET &MONTH = DECODE &IDX
-    ( 1 'January' 2 'February' 3 'March' 4 'April' 
-      5 'May' 6 'June' 7 'July' 8 'August' 9 'September' 
-     10 'October' 11 'November' 12 'December');

-SET &MONTHARRAY.&IDX = &MONTH;

-:MONTHLOOP

-* Display the array
-REPEAT :PRINTLOOP FOR &IDX FROM 1 TO &CURRMONTH
-TYPE IDX(&IDX) : &MONTHARRAY.&IDX

-:PRINTLOOP

Regards,
Sean