Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Finding First Record Only Post Reply Post New Topic
Author Message
jologs
Newbie
Newbie
Avatar

Joined: 12 Feb 2008
Location: Philippines
Online Status: Offline
Posts: 2
Quote jologs Replybullet Topic: Finding First Record Only
    Posted: 12 Feb 2008 at 6:20am

I have two tables - Table A and Table B with one-to-many relationship. Is it posible that for every records in Table A only the first matching record in Table B will be display?

IP IP Logged
Alex
Newbie
Newbie


Joined: 28 Jan 2008
Location: Canada
Online Status: Offline
Posts: 22
Quote Alex Replybullet Posted: 12 Feb 2008 at 7:32am

Yes, quite simple.

In crystal reports group by the record that is from "one" side of one-to-many relationship. Move record (field) that is from "many" side to group footer. Hide details section -> that does what you asked for, it shows first record from many table. Is there any criteria for that record (the biggest or the smallest... etc?)
I just did this using "xtreme" sample db that comes with crystal. Joined customer and orders field, inserted customer & orders field in details section, grouped on customer... and did the rest as above.
Cheers,
Alex
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.