hi
I'm working in a simple school program in VS2010. I'm using VS default reporting tools (SSRS). I got big problem with ssrs and I don't know how to solve it.
I want to print for each student the result of books. number of box in different grades are different so I use matrix table. Each page of report should contain information about a single student. Information are the name, the family, the result for Each book and etc. I can create this report for a single student. I use a query that retrieve student information, putting the personal information in text boxes and result of books in a matrix table and everything is grate. But it's not good idea to generate report just for a single student. It's wasting time.
But when I want to create a single report for all student which each page of report belong to a single student, I become fail. I can put the result of books in matrix table, so in each page it print result of a single student. But putting the personal information of student in text box is difficult because in each page it print the information about the first student. I tried many tricks but each time I was unsuccessful.
Also I don't like create one report for each grade, and number of books for one grade in a year may by different from another year! This is why I should use matrix table.
Is it possible with ssrs?
Should I have two or more queries for information? the how can I bind them?
I don't know the routine?
I'm newbie in VS and ssrs, so if any guidance of article for this kind of jobs.
thanks in advance