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

Framework Manager - Report Studio - Sort Month Name in month order

Started by LeeNash, 16 May 2013 07:39:53 AM

Previous topic - Next topic

LeeNash

HI,

This may be another daft question from me, but I am using framework manager to configure a package for use with report studio.

The data is very basic, an employees name, where its budget or forecast, annual salary, month salary value and month name..
However when i query this information the month name is in alphabectical order, I obvioulsy need it in the actual month order however I can't think of a clever way of doing this.

If anyone can point me in the direction of a tried and tested method that works I would be very grateful!

Thank you all in advance

Lee

Prerna Chaudhary

Hi Leen

You can actually include month id or month key in your package while publishing and then in the report studio you can sort the data container(list, crosstab, chart) by the sort key.

Go to Grouping and Sorting in the properties pane for that object in the report studio and then sort by month id/month key there.

Please include the month id/ month key as a query item in the query of that object even if you are not using it on the report.

It has to be in the query of that list/crosstab/chart so that appears when you actually sort it on the report.

Please get back to me if you have any queries.

Thanks and regards
Prerna

LeeNash

great thanks, I just figured that out about 5 mins before your reply!
Thank you for your time