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 |
|
bh0526
Yak Posting Veteran
71 Posts |
 Posted - 2011-12-13 : 09:05:55
|
| I have a simple report with a table that basically list items. I presently display all items. This all works so far.Now I want to allow the user to filter on the item name. So I right clicked on the table detail row and selected Tablix Properties. I then clicked Add, to add a filter and I select the field name ItemName. I want to allow the user to search for a portion of the item name. So I selected LIKE as the operator. But I'm not sure what to do for the value. The value will change each time the user runs the report and enters something. So I'm not sure what to do here.Maybe I'm doing this all wrong. I was hoping I could display all items and then let the user filter down to the items they want. Is this possible using this table filter? Bob |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-13 : 09:11:48
|
| you need to add a corresponding filter to report for passing the item value. Then in properties for parameter point it to dataset which retrieves the list of items from your item table (you've to create dataset for that). Then once you render the report you'll get an item filter with all items from your table populated. on selecting it will pass the item name and filter results based on that------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
k_nataraj
Starting Member
7 Posts |
Posted - 2011-12-19 : 06:08:40
|
| HiYou do it this way aswell. Within in your dataset add a where condition like below:[YourFieldName] LIKE '%'+@YourFieldName+'%'This will create a filter for you aswell.I have recently uploaded couple of videos on Parameters, here are the links, hope it helps.http://www.bitipsntricks.com/?p=293http://www.bitipsntricks.com/?p=303http://www.bitipsntricks.com/?p=314regardsNatraj |
|
|
|
|
|
|
SSRS Filter question