Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions
Message Icon Topic: Grouping assoc group data w detail Post Reply Post New Topic
Author Message
Harry5
Newbie
Newbie
Avatar

Joined: 12 Apr 2017
Location: United States
Online Status: Offline
Posts: 3
Quote Harry5 Replybullet Topic: Grouping assoc group data w detail
    Posted: 19 Apr 2017 at 1:29pm
I need to create a flat file for export - there are multiple samples w several data fields but the first sample contains data that needs to be associated w each of the samples ie

Sample #   test   site   result        address     "GH"
              
001          5     kit     3        59 oak rd   "Detail"
001          6     kit     17        59 oak rd
001          7     kit      4        59 oak rd
002          1     sink     23        59 oak rd
002          2     sink     33        59 oak rd
002          3     sink     12        59 oak rd
002          4     sink     11        59 oak rd
003          9     tub      15        59 oak rd
003          4     tub      10        59 oak rd

the address is only associated with sample 1,
                                                                                 So the address is blank for samples 002 and 003
                                                                                  How do I carry this data down for the remaining samples?

hbl
IP IP Logged
DBlank
Senior Member
Senior Member


Joined: 19 Dec 2008
Online Status: Offline
Posts: 8685
Quote DBlank Replybullet Posted: 20 Apr 2017 at 3:15am
if this is for the entire report just use a max(field) value. IF this changes throughout the report is it based on groups? On sort Orders? Something else?
IP IP Logged
Harry5
Newbie
Newbie
Avatar

Joined: 12 Apr 2017
Location: United States
Online Status: Offline
Posts: 3
Quote Harry5 Replybullet Posted: 20 Apr 2017 at 5:23am
A Work Order has several samples and each sample 1 or more tests. There will be many Work Orders in the extract - each with a different address. The Group Header would be Work Order# and the detail section has the sample#, data and address fields.
hbl
IP IP Logged
DBlank
Senior Member
Senior Member


Joined: 19 Dec 2008
Online Status: Offline
Posts: 8685
Quote DBlank Replybullet Posted: 20 Apr 2017 at 5:38am
so if you are grouping by WO then can you just do a MAXIMUM(table.address,table.wo) and place this in the detail section? This assumes there is only one address per WO.
IP IP Logged
Harry5
Newbie
Newbie
Avatar

Joined: 12 Apr 2017
Location: United States
Online Status: Offline
Posts: 3
Quote Harry5 Replybullet Posted: 20 Apr 2017 at 7:13am
Thank you DBlank Worked perfectly!
hbl
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.