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