Last post Jul 12, 2011 03:07 AM by jassu107
Jul 07, 2011 09:43 AM|jassu107|LINK
I have one textbox and a matrix below it.
The Matrix is RowGrouped as well as ColumnGrouped. The RowGroup is on StudentID and ColumnGroup is on DATE.
I've implemented page break on RowGroup so every new StudentId's Matrix would be on new page( along with TextBox I mentioned earlier)
Now my TextBox value fills with StudentName (corresponding to the StudentId). The problem is how to get TextBox value on each page break with correct value(StudentName attached with StudentId).
What I get is only the First StudentName(First(StudentName)) on all pages of report.
In EXPRESSION part of TextBox in
category-->Fields--->Report item not linked to any dataset. So I cannot get the rest of values of StudentName
So, how should I go through to get the desired result
Jul 11, 2011 11:23 PM|You-Hu Fu|LINK
To this achieve this requirement, you should make use of list control, group it by StudentID, then move the page break to list control, steps are:
1. Remove the pagebreak from matrix.
2. Drag a list control on the report body, then put the matrix into it.
3. Add a group to list grouped by StudentID.
4. Add a pagebreak to list.
5. Drag a textbox below the matrix inside the list control.
6. Give StudentName to textbox's expression.
Then you will get what you need.
Jul 12, 2011 03:07 AM|jassu107|LINK