Report as view: Linked Filters
I have a report that is also being used as a view. In another report, I have used this view in a sub-query and have linked the filter from the master report to it's counterpart in the subquery
Other subqueries on the same report are based on the same view as the master query and when run, I can see the filter being applied in the SQL
However it seems that for this subquery, it queries the entire dataset and does not have the filter as a condition in the report SQL. The output is filtered correctly which makes me think this is being done in the application?
The problem is that as the dataset grows, we are seeing that the report does not load and when inspecting the page I can see that we are getting a 504 timeout error
I know I should probably create a real view and use it but I was hoping there might be a way to fix this without doing so.