I have a report with numerous table throught a number of different pages. The problem is I want to only show information for 1 month on each table. I can set up a filter on each table but then I need to go update every filter on every table at the start of a new month. Is there no way of adding a single filter to multiple objects within a single report?
I am using Business Objects rich client so cannot set up prompts in the report. I feel there must be a way of doing this but currently takes ages to update each month.
Oh yes, I like that very much. Ok, I see how it works alright. The only problem I have now is that it only seems to work if the “Month” dimension is a string. Not if it is in a date format.
=If([Audit].[MMM / YY]=“May”;1;0)
The code above was where I typed in a string “May” into the database and changed the dimension from “date” to “string”.
But, I will figure something out. Thanks very much for your help.
(BOB member since 2010-04-14)
(BOB member since 2010-06-16)