New Matrix on change of ID value

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.

Answer 1

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

Answer 2

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....??

Answer 3

User2105670541 posted

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

Answer 4

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.

Answer 5

User2105670541 posted

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

Answer 6

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 ...

Answer 7

User1471008070 posted

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