Our database has 3 main tables : workorder, operations and materials

 

This workorder table contains the header information but also the more detailed level information.

 

This header information can be filtered out by a specific column.

 

WORKORDER

 

ID DETAIL   PART

A     0          PARTNUMBER

A     1          EMPTY

A     2          EMPTY

 

In the crystal report I put all records from this workorder table but now I want to add this PART information only from ID = 'A' and DETAIL = '0' by using a sql expression fields.

 

I tried it like this

(

SELECT WORKORDER.PART

FROM WORKORDER

WHERE WORKORDER.ID = WORKORDER.ID AND WORKORDER.DETAIL = 0

)

 

If I change WORKORDER.ID into 'A' I have off course the correct answer.

 

If something like this is impossible I have also a view that I can use

 

(SELECT WORKORDERVIEW.PART

FROM WORKORDERVIEW

WHERE WORKORDERVIEW.ID = WORKORDER.ID

)

=> in this view I filtered out all the records with DETAIL = '0'

But this is also not working.

 

I keep on getting errors about WORKORDER.ID can't be bound or that this is

This is probably going to slow down your report though.  A better way to do this would be to go to the Database Expert and add the Workorder table to your report a second time.  Crystal will alert you that the table is already in the report and ask you if you want to alias it - click on Yes (or maybe it's OK....)  The table will then appear in the list of selected tables as "WORKORDER_1".  Link from WORKORDER.ID to WORKORDER_1.ID.  Then, in the Select Expert set a filter on WORKORDER_1.DETAIL = 0.

 

-Dell

I tried to put the alias in the sql but also this is not working

(

SELECT WORKORDER_1.PART

FROM WORKORDER WORKORDER_1

WHERE WORKORDER_1.ID = WORKORDER.ID AND WORKORDER_1.DETAIL = 0

)