[Crystal Reports] Adding fields of linked table

Stoffel

Member
Joined
Dec 11, 2004
Messages
16
Location
Belgium
Programming Experience
1-3
Hi

My Tables:

tblPerson
ID
Name
Story
OtherStuff
....

tblHobbyPerson
ID
PersonID
HobbyID

tblHobby
ID
HobbyName

First of all, these are fictive tables to illustrate what I want

Lets suggest that a person can chose between a few hobbies
The hobbies of that person are stored in tblHobbyPerson where PersonID is tblPerson.ID and HobbyID is tblHobby.ID

Now what I am looking for:
In a report, I want to show 1 person and his hobbies
I've been trying to, but I have no idea how to do this

Anyone?


One other thing
Lets say that Story and OtherStuff are memo fields in an access database. This means I don't know how much they will type into the fields. How can I make sure that there will be enough place on the report to show the entire field?

Thanks
 

cjaymcmeans

Well-known member
Joined
Jan 12, 2005
Messages
85
Programming Experience
3-5
the easiest way to single out one person is to create a parameter and equate it to the th personid..
u can do this through the recordselection formula..

assuming all tables are linked properly..
just place the fields of the tblperson in the header.. then
the tblhobby and the tblhobbyperson in the detail..

i would suggest that u do this using crystal report outside of .net..
 
Top Bottom