Reports : How to pass parameter captured in page to query activity

[#1]

Hi,

I have created one sample report to list all campaign created in this year. I was able to successfully create it.

Now, I want my report to be more flexible.

I want to get results based on the year selected while running the report.

If I select 2016, it should return all campaign created in 2016. For this, I have created a page, created combo box variable, input 3 years 2015,2016,2017.

But I am unable to see this variable in my next activity which is a query activity so that it can dynamically pick that value and return campaign list as per the year selected.

Attached are the images.

[#2]

Thanks J-Serge for your detailed hints.

I have used static combo box and in my query used $([vars/yearSelected]) in value column to pull my report.

I am able to create this report.

JavaScript approach I might try it later for another requirement.