Repeating Sub-Reports with 1 data source

2 posts, 0 answers
  1. Jack
    Jack avatar
    2 posts
    Member since:
    Apr 2013

    Posted 20 Oct Link to this post

    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

  2. Jack
    Jack avatar
    2 posts
    Member since:
    Apr 2013

    Posted 21 Oct Link to this post

    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.
  3. DevCraft banner
Back to Top