incorrect data being returned

[SeeBee]

I'm using two database tables (Job Detail (History) and Job History. I did a manual link using JobNo and Job Number from each database. Below is the code I am using:

{Job Detail (History).Operation} = 301.00 and
{Job History.Close Date} in date(2002, 02, 01) to date(2002, 02, 28) and
{Job History.Ship Via} = "P" and
{@CustomerNo} >= 1.00 and
{Job Detail (History).Cost Center} = 13.00

The very last record is Job Number 138045. This should not
be included in the report. This job number is in the database 3 times, for
years 2000, 2001, & 2002. Year 2002 does not contain the Operation 301, as
I specified in the formula, but 2001 does, as well as year 2000.

I don't understand why Crystal is returning this record or how to eliminate it. The End Date should be within the same period as the Close Date. I have tried specifying that the End Date be in period Year to Date, but this does not work either.

The correct records that should be returned is 51. I must use the Close Date to get the correct number of jobs closed within Feb02. Running the report on the End Date alone distorts.

Any thoughts?

 

[Roadkill150]

Hello
I would make sure that there was a corresponding date link between the table that contains
{Job History.Close Date} and the table that contains {Job Detail (History).Operation}
from what you've said it sounds like a linking issue to me.
Also make sure you've tried using an equal join between tables Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[Ngolem]

If this is your record selection formula parts are missing

{Job Detail (History).Operation} = 301.00 and
{Job History.Close Date} in date(2002, 02, 01) to date
(2002, 02, 28) and
{Job History.Ship Via} = "P" and
{@CustomerNo} >= 1.00 and
{Job Detail (History).Cost Center} = 13.00

For example I see no reference to the join between the tables on Job number

{Job Detail (History).JobNo} = {Job History.JobNumber} and

should also be in there.

Is there more missing??

Jim