I have a master-detail report with a header with approximately 35 fields, 25 sub-reports (tables) in a detail section and a report footer. I've used a row above the Table for the sub-report header with the row below for column headings and the row on the bottom for the field data. Each sub has 1 or 2 Report Parameters that defines what is seen.
Recently when I edited some of the subs they started repeating based on the matching rows in the SQL Server 2008 R2 database which typically means that both the Report and the Table have their respected data source set to the same data source. But in this case there is only one data source set and that is on the Table itself.
Has anybody seen this before? Any help would be appreciated.