hi
I am new to SSRS. I have a matrix table like below:
---------------------------------------------------------------------------
| id | name | family | book1 | book2 | book3 | book4 | book5|...|book10|
As you know, the count of books in rum time are different for each user. it's may be 10 or less. I don't like this style. I want the crosstable just for books and show the name and family columns in textboxes. so the form of rport may be like this:
---------- ---------
|Family | | Name |
---------- ---------
-----------------------------------
| id | book1 | book 2 | ... |book10|
with a pagebreak at the end of group, this will be repeat in each page (separate page for each person). I made this in ssrs designer (default VS2010 report) but name and family's textboxes will not print in each pages. Is it possible and how can I do it?
I googled a lot and read some ssrs articles and tutorial. But I did not find any report like this
thnx in advance