how to get data in crystal report using two tables while in table A one filed is primary key and in table B same field as foreign key.And in Table B the foreign key has multiple record of same id.How to show it in crystal report
crystal report
Collapse
X
-
Tags: None
-
I Like to view from table B in crystal report in following format:Originally posted by Stang02GTI'm sorry but I was having trouble understanding what you were trying to say.
Are you asking how to show duplicate records in crystal reports?
Id Qualification Univrsity Percentage
r001 10th MPBoard 66
r001 12th MP Board 70
r001 Graduation Gujarat Univ 67
But in table A Id is primary key and in table B Id is foreign key.Comment
-
Yes,I mean multiple records.Originally posted by ranjana1980I Like to view from table B in crystal report in following format:
Id Qualification Univrsity Percentage
r001 10th MPBoard 66
r001 12th MP Board 70
r001 Graduation Gujarat Univ 67
But in table A Id is primary key and in table B Id is foreign key.
To View such report is it require to take subreport for second table?Comment
Comment