Scheduled Email BAQ Report - Don't email if no data

[aosemwengie1 (Alisa Osemwengie)]

Its funny you bring this up. I find that if I create a BAQ report in the BAQ report designer, it fails with no records selected when there is no data. But if I create a regular report in the Report Style screen, using an RDD that has a BAQ as the data source, then it sends out an empty report.

Empty reports

When I used to design BAQ reports and schedule them to email out, whenever there was no data (for example, no new orders), the report just . . . wouldn’t go out. But now I have switched to using SSRS BAQ reports and have discovered that even when there is no data an empty report is sent to the user. It’s not the end of the world but its a little frustrating because there doesn’t seem to any way to control this behavior. I am amused at my own frustration because previously I would always compl…