Thanks for your reply. There is no FilterName option for SQL DataSource webpart. I tried to create a custom datasource but how does it work even if i add a new property "Filter" to it when we use "QueryText/Storedprocedure" to get the data.
Is it possible to give the table name and FilterName to SQL Datasource webpart like other datasource webparts?
If yes, could you please point me to some article/documentation how to do achieve it?
Appreciate your help! Thanks!