Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grouping problem
Message
 
 
To
11/08/2008 19:22:05
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01338206
Message ID:
01338237
Views:
12
Sure. After the information about the case itself (the header), they want the Attorney and Party data to look like this:


Attorney Julie Nagle
---Plaintiff Bob Bridge
---Plaintiff Helen Bridge

Attorney Ben Bogle
Attorney John Doe
Attorney Nancy Golden
---Plaintiff Roger Randle
---Plaintiff Geri Randle
---Plaintiff Jennifer Randle
---Plaintiff Henry Randle
---Plaintiff Percy Wilson

Attorney Jim Daniels
Attorney Frank Smith
---Defendant Amy Black
---Defendant George Green

Attorney Henry Prince
---Defendant Mary French

For each Case, there is at least one Party on each side; each Party is represented by one or more Attorneys. The problems with the report formatting come when they share Attorneys.. The data structure doesn't really facilitate grouping them. The Case is the 'parent', the Party the 'child', and the Attorney the 'grandchild'--and 'grandchildren' can be (and are) entered multiple times.. In this example, there are 20 Attorney records, but only 7 distinct individuals.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform