|
sqlbug
Posting Yak Master
Canada
176 Posts |
 Posted - 11/26/2012 : 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, but
4) 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, |
|
Subreport not filtering records
