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

Creating dynamic Month Header

Started by TerranceU, 23 Dec 2011 12:29:56 PM

Previous topic - Next topic

TerranceU

I'm trying to create a dynamic header for my reports which shows the previous month.  I know this is probably an easy formula, any thoughts?

cognostechie

It's pretty easy if you want to display that in the Report header but what exactly you want to display? The previous month name, year, both , date ?? and where exactly you want to display that? If you can post an example of how you want it to look, I can give you the exact syntax.

absriram

Create a data item with this expression:

_add_months(current_date,-1)

You can now drag this item to the report page and format it as you wish.

Thanks,
Sriram.
http://cognosonsteroids.blogspot.com

TerranceU

Awesome, it looks like that worked.  Thanks!