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

Dynamic Column Headers

Started by Md37, 10 Nov 2010 10:42:34 AM

Previous topic - Next topic

Md37

Hi all.  Please forgive me if this has been asked before here, I have searched but didn't find anything.  I have a query that gets data for a rolling 12 month period.  Each column has the months data (ex: Jan 2009, Feb 2009).  This report will be run once a month, so I would need the column headers to change each month for the data.  Is this possible?  Thanks in advance.


cognos10

Yes we can create a dynamic column headers,

I think ypu need to create a 12 new data items

for each mnth

like example for january month

if(extract (month,current_date)=1)
then 'January'
else''

u can try this