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
Hi,
Are you using a relational or dimensional package? The approach you take will be different for each.
Regards,
MF.
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