NEED HELP WITH EXTRACTING DATA PLEASE HELP

[jobillborf]

Good morning. Here is my problem.
Using Crystal V9 Connected to SQL server database.

Two tables
1) CUSTPROB table where citizens call in complaints. A service number (SERVNO) is recorded for each Call. When a SERVNO is completed a date is placed in the Resolved DATE (RESDTTM)

2). HISTORY table for work orders completed to resolved the complaint. Link to CUSTPROB is by SERVNO. If the work order is completed a date is placed in the COMPDTTM FIELD


LINK AGAIN CUSTPROB.SERVNO TO HISTORY.SERVNO

We would like to create a report grouped by CUSTPROB.SERVNO. Detail section HISTORY fields.

We need to extract all records where CUSTPROB.RESDTTM is NULL or blank and all HISTORY.COMPDTTM are NOT NULL.

In other words, we need to extract all complaints where the CUSTPROB.RESDTTM IS NULL and all the workorders in the HISTORY.COMPDTTM have a date entered.

or All the work to resolve the complaint is done (HISTORY TABLE)but the completed date for the complaint have been left blank or null.

Hope this is enough information. Thanks for your help.

 

[lbass]

You should be able to use a record selection formula like this:

isnull({CUSTPROB.RESDTTM }) and
not isnull([HISTORY.COMPDTTM})

If you have tried this and you are not getting the results you expect, please explain how your results differ from expectation.

-LB