Is there a way to make a report viewer not print anything when the row set returns no rows? I am running on-premise Syteline version 10.
....not sure if it would work for you... 2 options:
-raise error inside the report's sp, this will fail the bg task
-re-design report...pre-process report into a staging table, do not submit if table is empty; report would have 2 parts, one that generates the data into staging table (use process ID) and one to select the data (based on the process ID)