Display Previous Month in Heading of Report with No Data

Cognos 8 Business Intelligence Report Studio
1

I have a report that sometimes has no data in it. In the heading of the report I would like to display the previous month of the current date (for example, today it would display “Month of May 2011”). As long as the report is not empty this displays fine. However, if there are no data, it displays nothing. Is there a way I can make this display? I have created a query calculation to get the previous month from the system date. I am using Cognos 8.4.1. Thanks in advance for any help! Deb

2

Disregard, I got it to work. I used a Layout Calculation of _add_months(date2timestamp(Today()),-1) and formatted the field to display just the month and year.

3

Thanks for sharing, Deb! :slight_smile: