Hello All,

I have a very strange requirement. Report is very simle. It has 2 columns in the Prompt section & 10 columns in the analysis section. Based on the prompts selected, corresponding values get retrieved in the tabular format. very simple. One thing to note here is - those 2 prompts are not "is prompted", instead, presentation variables are ucresed to capture the values of prompts. And those Presentation variables are used in the formula column of all columns (FILTER...Using...method) to achieve the business logic. All well till here. Report works perfectly fine.

Here is the issue - We need to schedule this report. I created Agent. Now How to refer those Presentation variables from agents? (looks impossible to me???) If those prompts were "Is prompted" then I would get option in agent itself to set some value and schedule the report. But As I am using presentation variables, I am unable to filter the data from agent.

Need your expert advice guys. Please let me know how to access those presentation variables. If not possible, what could be best solution to resolve this issue.

Please Note that I Must use presentation variables as one of the prompt is "year" & and another is "month". And requirement is in such a way that few columns in analysis should get filtered by Year and few by month. So, I am achieving this by using "FILTER...USING.." method.

Awaiting your inputs.

Thanks and regards,

Gaurav