I have a report that i've created which uses section access to filter out a table of tasks to only those by the user. Onto this table i have linked a calendar table so that the user can select the month/week/quarter etc from a list box and see specific tasks for that timeframe.
A requirement of the report is that the list box should display all possible months, weeks etc and only grey out those that arent applicable. The problem is of course that since the calendar is linked in to the other table it is affected by the section access, so its values are reduced.
So my question is: how can i 'exclude' this calendar table from the section access on the tasks table, while still allowing the user to use it to filter out results? Removing all joins between the tables solves the problem but then means they cant be used for filtering, so i'm quite stuck at the moment.
Thanks for any help