If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Display Date Range in Header

Started by src144, 23 Apr 2021 02:04:29 PM

Previous topic - Next topic

src144

First, let me apologize in advance if the topic is posted on the wrong thread. I am using IBM Cognos Report Studio Version 10.2.2. I have a report that is pulling data from the last 7 days. I would like to add a header to reflect the date range. For instance, if I run the report on 4/23, the date range should be displayed on the header to reflect 04/15/2021-04/22/2021. How can this be accomplished?

I have inserted a text item in a block and selected the source type as a report expression. I then have _add_days (AsOfDate (), -7 ) in my expression definition but keep getting errors. Any help is GREATLY appreciated.

BigChris

The simplest thing to do is probably to add a calculation in your query for
_add_days(current_date,-7)
and perhaps a second one for
_add_days(current_date,-1)
then you can bring them into your header as singletons, perhaps with text fields before and between, so that you get something along the lines of

'Dates between ' [Calculation 1] ' and ' [Calculation 2]