Is there a way to delay the execution of a query until the user has made a selection from a value prompt? I have a report that has 2 queries. The "main" query is executed when the report is run. The report has a second query that uses a value prompt as a parameter. I'd like the 2nd query to only be executed if/when the user selects something from the value prompt. The 2nd query has a filter that uses the parameter like such
[measure] = ?ValuePromptParam?
When the report is run it always requires a value for the ValuePromptParam before the report is run (even if the prompt is marked optional). I'd like the report to run and execute the main query, and hold off executing the secondary query until the user picks something from the value prompt.