June 28, 2010 at 8:34 am
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?
June 28, 2010 at 9:18 am
It appears to only be a display problem in the report. If I export to .pdf all the data appears.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply