locked
New Matrix on change of ID value RRS feed

  • Question

  • User843229376 posted

    I am using Matrix to display Student records.

    Now what I need is I want to display for every individual StudentId , its record in one matrix and for other StudentId, records should be shown in different Matrix. How can I do this.

    I am using Stored Proc to populate record. In my dataset I have following columns

    StudentId, StudentName,Period,Subject,Date

    for example if I have 3 StudentIds (11,12,13)

    StudentName(StudentId=11)      //TextBox to show StudentName

     

    3/1/2011

    Period  1

    Maths

    Period 2

    English

    StudentName(StudentId=12)    //TextBox to show StudentName

     

    3/1/2011

    Period  1

    Maths

    Period 2

    Music

    Period3

    Science

    StudentName(StudentId=13)   //TextBox to show StudentName

     

    12/1/2011

    Period  1

    Maths

    Period 2

    Music

    Period3

    Science

    Here Period is Row,Date is Column and Subject is Data part of Matrix
    How to get this , is my problem

    Also for every new/different StudentId, the matrix should be shown from new page.




    Monday, July 4, 2011 7:42 AM

Answers

All replies

  • User2105670541 posted

    i think you should use a list in your report project instead of matrix, this will populate records the same way you want, and in list properties, you can set the page break so that they will be visible in new page everytime, for Lists you can visit the link below:

    http://msdn.microsoft.com/en-us/library/ms251742.aspx

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/f7cf2f7d-b103-49f1-a441-9a1bf3225f3b

    Monday, July 4, 2011 9:47 AM
  • User843229376 posted

    But the issue is that my record for particular StudentId can expand in both Horizontal as well as Vertical direction....

    Period can increase Period 1,Period 2,Period 3,Period 4,Period 5......so on...

    Date can have multiple date.....thus horizontally my Column will expand.....

    Is this viable option with LIST....??

    Tuesday, July 5, 2011 1:38 AM
  • User2105670541 posted

    you must have row grouping, set the page break properties in row group.

    Tuesday, July 5, 2011 12:23 PM
  • User843229376 posted

    Ok.

    however I also want that there should be page break if my Column Group count is more than 5 that is if my Date column is more than 5 than

    next five dates(upto 5 count) should be shown on next page.

    Wednesday, July 6, 2011 1:40 AM
  • User2105670541 posted

    i dont think its pretty simple as we dont have a expression in page breaks.

    Wednesday, July 6, 2011 3:19 AM
  • User843229376 posted

    i dont think its pretty simple as we dont have a expression in page breaks.

    Any basic Idea/steps  on how should I move forward on this ...

    Wednesday, July 6, 2011 3:23 AM
  • User1471008070 posted

    Same thread http://forums.asp.net/t/1697113.aspx 

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