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.
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.