Passing Filter to Sub-Query

[JRO061601]

Hi all,

I'm building a report in which one of the columns has a filter built off it that gets a list from a sub-query. However, I need to put two additional filters on the report that get defined at run-time by the end user. My problem is that the filter criteria selected at run-time does not get passed through into the sub-query. Without the filter criteria, the sub-query is so large it won't even finish running - too many rows returned for the tool to handle. I've tried building filter prompts into the sub-query as well, but they seem to just get ignored. Any ideas as to how I can build out this logic in this tool? Thanks in advance.

 

[mbrowningsmith]

Have you tried entering the "is prompted" into the filters of the second report for the columns that should be accepting the prompted values from the first report? I'm pretty sure that's what I've done.

 

[JRO061601]

Thanks for your reply. I have moved on from this project (and the employer, for that matter) so I can't test your suggestion. Maybe another user will make use of this knowledge.

 

[mbrowningsmith]

Do you mind if I ask what company you worked for? It's always nice to know what other employers have the tools I work with.

 

[JRO061601]

No offense, but I'd rather not say.

 

[mbrowningsmith]

No problem, thanks anyway.