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

Avatar

Avatar

ckumari12

Avatar

ckumari12

ckumari12

22-08-2017

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.CampaignRptyearwise.JPGrpt forum.JPG

View Entire Topic

Avatar

Avatar

ckumari12

Avatar

ckumari12

ckumari12

23-08-2017

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.