I have a report that returns:
Name, Department, Phone
Now I want to be able to filter the report by department.
So that the user can open the report (it is cached) and then select which department they want to see the phone numbers for.
So a drop down that says "Accounting, HR, Sales" and if they select "SALES" then it would only show department fields = SALES.
Anyway, I can add a filter to the report itself, but I can't figure out how to make it so the user can select the filter.
This is all I could find on filters: http://technet.microsoft.com/en-us/...56270.aspx
which works great, but doesn't tell me how to add one that the user can modify/set.
Can someone lend me a hand?