Crystal reports and sub report issue

Thanks much for the suggestion.  A left outer join did the trick as well as just updating the sub report dataset with the added table (field).

Appreciate it.

 

Carol

 

I am trying to modify the Pack Slip that prints from Customer Shipment entry.  I have duplicated the RDD and renamed it.  I included a UD field from the Part table.
I then created a new report style and Crystal report
In the Crystal report I am calling for a Sub Report which is a "Certification Of Compliance" form.
I want this form to be suppressed when the UD field in my dataset returns a certain value.
I have set my datasource and when I right click on the UD field from the Part table in field explorer I can see the 2 values listed in there.  However, when I drag the field onto the report all of the other fields disappear and I am left with a blank page.
What am I missing?
>>when I drag the field onto the report all of the other fields disappear and I am left with a blank page.
>>UD field from the Part table
Have you tried changing the link(s) in Crystal database expert?
A "left outer join" for the added table(s) can eliminate the issue you describe