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

Need to Display Short Month in RS and QS Reports

Started by pdaprem, 15 Mar 2011 07:07:58 AM

Previous topic - Next topic

pdaprem


I'm using DB2 and have used monthname to extract the month text for a date field. I now want to display the month as the short name 'Jan' in reports. I have tried using the Date format to indicate display short name but in my Report Studio reports the month is coming out 'January'. Without using a case statement any suggestions on how to make the Date format in the Properties pane work?

PRIT AMRIT

Not sure if I understood your query though, if you have date field and u want to just show the Month part alone with the short name, then just select that DATE column, go to Data Format properties, select type Date, then you can select all the default option as NO and for month, just select 'Short'.

Hope this is what you r looking for?

pdaprem