COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: lestes on 07 Mar 2019 09:37:54 AM

Title: Stopping distribution of a scheduled report, if "no data available"
Post by: lestes on 07 Mar 2019 09:37:54 AM
I was wondering if anyone had any luck in stopping a scheduled report when the result is "no data available"?  This is a list report.  I have it scheduled to be emailed to a user every hour.  I was hoping to only have it emailed if there was data on the report.
Title: Re: Stopping distribution of a scheduled report, if "no data available"
Post by: BigChris on 07 Mar 2019 10:06:56 AM
You need to set up an even to control when the report gets sent
Title: Re: Stopping distribution of a scheduled report, if "no data available"
Post by: dougp on 07 Mar 2019 01:16:23 PM
Another option is to use bursting.  If there is no data for a particular group, that group will not receive the report.
Title: Re: Stopping distribution of a scheduled report, if "no data available"
Post by: lestes on 07 Mar 2019 05:03:03 PM
thank you both for your response.  I am new to these reports so I will need to look into these two options, as I have not used those methods.  I will do a little more digging into each option. 
Title: Re: Stopping distribution of a scheduled report, if "no data available"
Post by: MFGF on 08 Mar 2019 07:48:01 AM
Quote from: BigChris on 07 Mar 2019 10:06:56 AM
You need to set up an even to control when the report gets sent

I think Chris means an event, otherwise that would be odd :)

MF
Title: Re: Stopping distribution of a scheduled report, if "no data available"
Post by: BigChris on 08 Mar 2019 08:42:36 AM
I'll make sure I read my posts twice before pressing the enter key in the future.
Title: Re: Stopping distribution of a scheduled report, if "no data available"
Post by: MFGF on 11 Mar 2019 01:04:08 PM
Quote from: BigChris on 08 Mar 2019 08:42:36 AM
I'll make sure I read my posts twice before pressing the enter key in the future.

It was just another bad muppet joke. Even... odd...

I know! Don't give up my day job 😃

Title: Re: Stopping distribution of a scheduled report, if "no data available"
Post by: BigChris on 12 Mar 2019 03:11:17 AM
It gets worse - I tried to trump your muppet joke and it completely missed the mark. Odd or even, if it's doubled it'll be even...I blame my mathematical past