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

Displaying data for part of a year

Started by pcc, 15 Apr 2010 05:52:29 AM

Previous topic - Next topic

pcc

Hi. I am new to Report Studio and am doing my first reports. I have a list that needs to display actual and budget hours for the current year, but only for year to date, not the complete year. Thus, at the moment, I need to display total hours and budget hours for Jan to March. (The data is stored by year and month). Therefore, I need to work out how many months have passed and apply some sort of filter to the list. I propose to work out months that have passed by finding the last month for which there are actuals (and use the month id to apply a filter to the main query), but I'm not sure how to do this. Can anyone give me a pointer please?

Hope you can help.
Regards

MFGF

Hi,

Are you using a relational or dimensional package?  The approach you take will be different for each.

Regards,

MF.
Meep!

pcc

Sorry I didn't gat back - I hadn't turned notifications on.... doh !
I have now fixed the problem, but many thanks for your reply, and apologies once again