| Author |
Topic |
|
skalra
Starting Member
20 Posts |
 Posted - 2009-01-06 : 09:59:06
|
| Hi - Is there any way of making Interactive filter in Sql Reporting services as we can do Interacive Sorting for users. Please help.Thanks in advance.Regards,S |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-06 : 10:01:13
|
| what do you mean by interactive filter? can you explain? |
 |
|
|
skalra
Starting Member
20 Posts |
Posted - 2009-01-06 : 10:02:42
|
| By Interacive filter I mean to say the drop down list by which user can select the item and can filter the column accordingly. As we do in data grids. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-06 : 10:10:13
|
quote:
Originally posted by skalra
By Interacive filter I mean to say the drop down list by which user can select the item and can filter the column accordingly. As we do in data grids.
ok. and where will you be passing value for filteration? |
|
|
|
skalra
Starting Member
20 Posts |
Posted - 2009-01-06 : 10:15:27
|
| On the Table column |
|
|
|
skalra
Starting Member
20 Posts |
Posted - 2009-01-06 : 10:16:28
|
| On the Table column of the Report... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-06 : 10:42:56
|
quote:
Originally posted by skalra
On the Table column of the Report...
?? didnt get that. how will you pass value through column? |
|
|
|
skalra
Starting Member
20 Posts |
Posted - 2009-01-06 : 10:46:08
|
| See when the report is generated the values are comming from database through Store procedure but I dont know how to add filter on First name , LAst name , ID etc.Please help Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-06 : 10:48:12
|
quote:
Originally posted by skalra
See when the report is generated the values are comming from database through Store procedure but I dont know how to add filter on First name , LAst name , ID etc.Please help Thanks
you should be adding parameters for filtering and filter values through it.you cant filter directly through values displayed in report |
|
|
|
skalra
Starting Member
20 Posts |
Posted - 2009-01-06 : 11:09:51
|
| Hey can you please give me one exaple for doing it. If i want to add filter in first name what shld i do ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-06 : 11:16:35
|
quote:
Originally posted by skalra
Hey can you please give me one exaple for doing it. If i want to add filter in first name what shld i do ?
add a new report parameter called firstname. create a new dataset and write query to get firstname values, use it to populate the parameter and then use parameter's selected value for filteration |
|
|
|
|
Interactive Filter in sql reporting services