This is a migrated thread and some comments may be shown as answers.

Repeating Sub-Reports with 1 data source

1 Answer 68 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Greg
Top achievements
Rank 1
Greg asked on 21 Oct 2016, 12:50 AM

Hi there,

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.

Thanks,

Jack Willhoite

1 Answer, 1 is accepted

Sort by
0
Greg
Top achievements
Rank 1
answered on 21 Oct 2016, 03:07 PM
Solved the issue, I was assigning the data source in the table properties and in the NeedDataSource event in the code too. I commented out the assignment in the code and as is well again.
Tags
General Discussions
Asked by
Greg
Top achievements
Rank 1
Answers by
Greg
Top achievements
Rank 1
Share this question
or