I have 1 Qvd generator file which generates N no. of qvds.
There are 2 analysis files which refer these qvds and report gets generate from the analysis file which is getting mailed from publisher.
Mail is happening (by a trigger) through a task defined in the server. Sometimes after loading data, some of the Qvds are having no data i.e. 0 record.
As report is reffering those Qvds which are having 0 records, Blank report is getting mailed which i dont want to be send as Blank.
How can I stop mailing blank report?
How can I check if records in Qvd is 0 then disable the task from server which is sending mail?