Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Maxer
Yak Posting Veteran
51 Posts |
 Posted - 2007-06-28 : 11:15:12
|
| I have a report that returns:Name, Department, PhoneNow 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/library/ms156270.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? |
|
|
|
|
|
How can I add a user selectable filter to a report