ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
TRUSTED BY
Normally, the subreport Data tab has a Master Field and Child Field and this binds the main report and subreport together.
It is important to understand WHERE those fields are physically on the report.
Let's say the two are bound on PersonID.
If the control with PersonID in it is in the Report Header, but the subreport is in the Detail section, you will likely get a subreport for the PersonID in the first record only. After all, when the Report Header renders, the first record is the only one in force yet -- and the control doesn't change it's value there each time the Detail section renders.
Now let's say that the control with PersonID in it is in the Detail section. Great! It'll change with every record. But if the subreport is in the Report Footer section, then PersonID will be the last record in the set when the subreport renders.
So, you need a control with the Master field to be in a Section that will allow it to change with each record. Likewise, the subreport must be in a similar section. The Detail Section is the obvious place -- but sometimes that isn't what you want organizationally. In Grouping and Sorting, you can add fields to sort by, and you can give them their own header and/or footer section. I'll do this with a Primary Key field that is unique for each record on the report when I need to do this.
But I suspect your problem at the moment is that the subreport is in a section other than -- and farther down the page -- than the Detail section. This What is happening is that the subreport is only showing information about the last person of the group. is exactly the expected result from that setup