locked
TextBox value depended on Matrix ROW group value RRS feed

  • Question

  • User843229376 posted

    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

    Thursday, July 7, 2011 9:43 AM

Answers

  • User1471008070 posted

    hi Jassu107,

    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.

    Thanks,
    Challen Fu

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 11, 2011 11:23 PM

All replies

  • User1471008070 posted

    hi Jassu107,

    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.

    Thanks,
    Challen Fu

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 11, 2011 11:23 PM
  • User843229376 posted

    Thanks ...Smile

    Tuesday, July 12, 2011 3:07 AM