I am trying to create my first Crystal report so sorry if I am making an obvious error. I have a PO form in Remedy called PORequests. It contains a table pointing to another form called PO Line Items. The table is linked by an Instance ID field. I need to create a Crystal report so I can print the main form (PORequests) and all the line items in the table (POLineItem). I created 2 reports in Crystal. I inserted the POLineItem report as a sub report and linked on the Instance ID field. When I click on preview in Crystal I get 2 sub reports. The first PO record is displayed, the sub report correctly shows 3 line items associated with that PO and then there is a 2nd sub report that shows a different line item that is not associated with that PO. The Instance ID is not the same in this last line item so I am thinking my link in Crystal is wrong. Here is what is selected in the SubReport links dialog box:
Field to link to: PORequests.Instance_ID Subreport Parameter field to use: ?Pm-PORequests.Instance_ID Select data in subreport based upon field: POLineItem.Instance_ID Does this look correct? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"