Hi everyone

Can anyone pls help me how to filter a report (reporting service) using certain criteria thats been generated from an SQL Server Business Intelligence studio.

Can anyone pls reply.its urgent!!

hello anyone there? its been two days since i've posted this. someone please reply

Hi. You have to provide more details. Do you want to filter based on another selection ( ie. A cascading parameter ) ?

Not sure what does the certain criteria  mean. But in reporting service, there are two levels to filter data. You can filter your data in SQL query side, or you can add a parameter for your report, and provide the parameter on the report-consumer side. (this is used in RDLC mostly.) Try the article

http://msdn.microsoft.com/en-us/library/ms155917.aspx

My idea is to create a report based on the result from a Stored Procedure. Infact im not supposed to modify the result set inside the SP. What i have to do is to filter the result based on a criterion for example, report on a given date or can be a given string. Is that possible in reporting? Please reply.

So basically you are not allowed to have a filter in the Stored Procedure ? You want to bring all the data from the stored procedure and then filter this in the report itself ? You can do this using the filter property on the table or matrix object. Go into the properties of the table or matrix , select filter and you can set it up to filter on a column and you can even link this to a parameter.