Sending a scheduled report only when there is data.

[EyalR]

Hi all (New here ;D),

Is it possible sending a report (by mail) only when there is data?
Would like to do so but not in Event Studio.


Thanks,
Eyal

[BigChris]

You'll either need to do this in Event Studio, or alternatively set up a trigger when there is data on the server and schedule the report accordingly.

[oscarca]

Use the burst feature when scheduling the report.
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_modrep_bursting_reports.html

[CognosPaul]

I agree with oscara. Set up the burst so it has the email addresses you want to send to, but only when there's data. If the burst query is null, it won't send.

[MFGF]

I agree with oscara. Set up the burst so it has the email addresses you want to send to, but only when there's data. If the burst query is null, it won't send.

Just to add to this, also be mindful of your licensing situation if you decide to use the bursting feature. Using bursting means that the report content is classed as being personalised for each burst recipient, and this means each of them needs a Cognos license to receive the report content according to IBM's licensing definitions.

Cheers!

MF.