Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: New: Create function with mult. relationships Post Reply Post New Topic
Author Message
sonora
Newbie
Newbie


Joined: 10 May 2012
Online Status: Offline
Posts: 1
Quote sonora Replybullet Topic: New: Create function with mult. relationships
    Posted: 10 May 2012 at 4:41am
Hi I am very new to Crystal, as in I just started playing with it within the last 24 hours. Embarrassed
 
I created a standard report that listed Land Owner Names and the Land Parcel Numbers they own, which can be many.
 
I am trying to creat a report that will show each Land Owners name once and the Land Parcel numbers as follows:
 
                 John Doe: / 300, 301, 302 & 303 /Additional Information
 
I am trying to figure out how to write the function to accomplish this. Also, I do have a very basic understanding of VBA.
 
Thanks!
S
 
IP IP Logged
mudcat1
Newbie
Newbie
Avatar

Joined: 21 Jul 2008
Online Status: Offline
Posts: 11
Quote mudcat1 Replybullet Posted: 10 May 2012 at 10:14am
Try using Group By for the Land Owner column, and put the Land Parcel and Additional Information as columns in each row of the detail section.
The down side of this is that you will still have multiple rows for the details section of the report.  It will look like this:
Group:  John Doe
Details: 300 Additional Information
            301 Additional Information
            302 Additional Information
            303 Additional Information
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.