I am attempting to create an Active Report that is using two cascading drop down prompts to coordinate data deck.
The idea is if Prompt 1 is populated but prompt 2 is null/no value, it will show deck 1 (tied to data in prompt 1). If Prompt 1 is populated, and prompt 2 is populated, then deck 2 will show instead (tied to data in prompt 1 and 2).
Another idea was to have the two data decks inside of a deck that would switch between the two but still having troubles identifying to swtich to whne one is null and one is not.
Currently I am having difficulties creating a render variable based on the active variables in the report.