When using a report prompt, we need the prompt options to only show what our report filter is set up to include.
Business Case:
I have a report that only pulls ACTIVE portfolios. I added a prompt for the "Portfolio" and added the report to an Executive Dashboard, so my Execs could drill into a specific portfolio.
BUT the report prompt on the dashboard is showing active AND inactive portfolios. So, even though my report filter is for ACTIVE portfolios, a report prompt will not look at that filter. Workfront Help Desk has relayed that this is how the system is configured - prompts will not look at report filters.