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

Variable Headings

Started by pepper354, 02 May 2006 10:35:44 AM

Previous topic - Next topic

pepper354

Does anyone know of a way to create variable headings in ReportNet?  I'm trying to create an AR report and the requestor wants the colums to be months old but instead of saying month 1, month 2, month 3, etc, they want to see April, February, January, etc.  Theses column headings should change every month as 1 month old will be different when the report is run at the end of each month.  Any ideas or suggestions would be greatly appreciated!

Thank you!!!

pepper

cogman

Add a Table to the Report and Create Calculated Columns with if or case statements.use syntax current_date -1..

Hope it helps you

bdybldr

Add a query item to query that drive your list report, called "Month" (or something).

Define the query item as (extract(month, [date])).

Then, click on the report column heading and add "Month" to Report Expression on the properties pane.

HTH.  Keep us posted.