Is Sequence Number 000 always the description and 001 always the memo? If it is, this is fairly simple using aliases. I'm going to use a table name of "Tasks" in this example.
1. In the Database Expert, add a second copy of Task to the report - Crystal will ask you if you want to "alias" the table - click on Yes. A second copy of Task now appears in the table list with the name "Tasks_1".
2. Join from Tasks to Tasks_1 on the TaskNumber. If not all tasks have a memo, make this a Left Outer join.
3. In the Select Expert, set a filter so that {Tasks.SequenceNumber} = '000' and {Tasks_1.SequenceNumber} = '001'
You can now get the base data on the task from Tasks and the memo from Tasks_1.
-Dell
IP Logged
