crystal report

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ranjana1980
    New Member
    • Jul 2008
    • 15

    crystal report

    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
  • Stang02GT
    Recognized Expert Top Contributor
    • Jun 2007
    • 1206

    #2
    I'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?

    Comment

    • ranjana1980
      New Member
      • Jul 2008
      • 15

      #3
      Originally posted by Stang02GT
      I'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?
      I 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.

      Comment

      • ranjana1980
        New Member
        • Jul 2008
        • 15

        #4
        Originally posted by ranjana1980
        I 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.
        Yes,I mean multiple records.
        To View such report is it require to take subreport for second table?

        Comment

        Working...