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 |
|
sqlbug
Posting Yak Master
201 Posts |
 Posted - 2012-11-26 : 17:35:59
|
| I have this subreport in the following environment:1) Report is hosted on a .NET page (runs on client).2) In the aspx page, there's one ReportViewer with two separate datsources, because subreport uses a different stored procedure.3) The stored procedure for subreport does not take any parameters, but4) The subreport has one parameter defined in the properties - which has its value as the ID field returned by the dataset. So I'm expecting the records returned by the stored procedure to be filtered by the parameter defined in subreports properties.Problem: Subreports get all the data without filtering.Any ideas what I'm missing?Thanks, |
|
|
waseemullah
Starting Member
1 Post |
Posted - 2012-11-27 : 18:18:47
|
| see tablix properties of subreport.rdlc select filterClick Add to add a filterIn expression select the field that you want to filterchoose operator =in value enter the subreport parameterthats allWaseem |
 |
|
|
|
|
|
Subreport not filtering records