You actually need to use two copies of the same table to get what you're looking for. Since you didn't give us your table structure, I'm going to make some assumptions:
Table Name = PaperEntries
Table Structure = two fields RecordNumber and GSM.
1. Keep your existing table named PaperEntries in the report. We're going to keep the selection criteria on this table and it will work like the "Master" table in a Master-Detail relationship.
2. Add the PaperEntries table to the report again. Crystal will tell you that the table already exists and ask if you want to add it with an alias - click on Yes. The table will appear in the list as "PaperEntries_1".
3. Right-click on the PaperEntries table and select "Rename". Set the name to "PaperEntries_Master". Do the same thing on the PaperEntries_1 table, setting the name to "PaperEntries_Detail". You don't really have to do this step, but I find that it helps me to remember what the report is doing if I have to come back and edit it later.
4. Join from {PaperEntries_Master.RecordNumber} to {PaperEntries_Detail.RecordNumber}.
5. In your Description column on the report, use the data from PaperEntries_Detail so that you get all of the records you're looking for.
-Dell
IP Logged
