Creative Solution for using a dynamic filter
I have a table that pulls in information from multiple other tables. For this exercise, say one table is Projects Table, and the other is an Events Table. Each project has a single manager. Events...
Forum Discussion
You could try a Report Formula, something like:
If([Manager] != "", "Projects and Events", "Events")
Then add the report formula as a column in the report. They can't be used as one of the 5 dynamic filters, but in the new report style you can filter on each column.
Just my 2 pennies.
------------------------------
Paul Peterson
------------------------------