How can I add a user selectable filter to a report?

Last Post 28 Jun 2007 06:43 AM by Maxer. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Maxer
New Member
New Member

--
28 Jun 2007 06:43 AM


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?


Acceptable Use Policy
---