Pulling my hair out - Crystal Reports
ok... i have two tables
players (id, name, surname, age, genre, ...)
results (id, playerId, result, date)
first page of the report should be player info and second should be all his/her results.
i've made dataset1.xsd and put these 2 tables there... and made relation between them
then i've included this dataset1 to crystal reports and also linked the tables there
i've put 2 test players into the "players" table and i've put 5 results for each in "results" table
when i run the reportviewer i get report 20 pages long!
first page shows the player info and second page one result... and again player info and 2nd result ....
but there sghould be only 4 pages.... 2 for each player
i am going crazy ....
please help!
thank you in advance!
Matej
