Report output version for bursting and scheduling when data is not present

[davidcognos]

Hi,

The report has scheduling and bursting to directories. We are getting the report output version daily when data is present in the table. The issue is that when data is not present in the table , we have formatted the report to show some text as "No data found".

The issue is that when data is not present in the table, the report won't burst. But here we atleast require the blank report output version in the portal which should show the text when data is not present.

can anybody suggest


Thanks in advance !!

[PRIT AMRIT]

Hi,

It will show you 'No Data Found' message if there is no data.

The issue is that when data is not present in the table , we have formatted the report to show some text as "No data found"

How you have formatted report? Have you tried with,
select the report, No Data contents--> YES
Drag a Text Item and drop inside the block and write 'No Data Found'

Save & Burst the report again and see if it helps?

BTW, what is your Cognos Version?

Thanks

[Lynn]

I suspect it isn't going to burst without a burst key in the result set regardless of the no data contents being set up.

Not entirely sure but you could try to construct the queries such that all your burst keys are present, maybe one query that generates them all outer joined with the data query?

[PRIT AMRIT]

Hi Lynn,

We are getting the report output version daily when data is present in the table. The issue is that when data is not present in the table , we have formatted the report to show some text as "No data found".

cognag31 already has the Bursting set up in his report. So I suggested, to try with 'no data contents' option.

I have a report with 'no data contents' set to YES --> 'NO DATA' and I am bursting the report.
However, I have a Burst Query and Burst Key Query Item i.e. 'Report Name'

It's working fine, even source doesn't have DATA, I can get the excel with 'NO DATA' in the file location.

Thanks
Prit

[davidcognos]

Hi,

Actually in the current report I am bursting to directories. I specifically donot have burst table in the database and donot need it as i am using the function 'CAMID("::Everyone")' to create a data item in the main query and bursting the report based on the grouped column. The report is getting burst on the grouped column perfectly but the issue when data is not there in the table (main query) , I require a blank output report view saved in the portal as I am doing the scheduling for the report. Will the outer join of main query with the Burst query work to achieve this. What data items should i have take in the burst query.

Please suggest.

[davidcognos]

Hi Lynn,

Can you please reply to the above query.....

[Lynn]

If your burst key is in the main query then you will get NO ROWS returned from the query when there is no data. Therefore, the burst key will not exist so how can it burst?

Perhaps you can try using a separate query with the burst key expression such that it always returns a row and use that instead.

I think this is pretty much what Prit was describing, so hope it works out!