I have a main report that ideally would contain two subreports. The main report contains singular data about a person, and each subreport contains multiple records about a person. I'm using the PersonID from the main report to link to the @Sub1PersID and the @Sub2PersID. Both subreports and the main report use sprocs to generate the data.
When I add both subreports into the rectangle/matrix, every other row of data from the main report does not show up. The borders around the text fields are present, but they contain no data. I used an expression to join a few fields in one text box and the ' - ' and ', ' show up in the main report, but no data. All the data from the subreports is present.
If I delete one of the subreports (it doesn't matter which one) then every main report record is shown. I've tried rebuilding the reports from scratch and I've reproduced this error. I have a selectable sort parameter so I know its not dependent upon a data field (i.e. its not omitting the data from the sproc, and it is definitely every other row from the report and not the dataset).
Has anyone seen something like this before?