Getting blank report 1

[PlsHlpKat]

I am using CR 8.0
SQLBASE v6.2.1 database
Data connection method: ODBC
Each time I write a Crystal report and cross
database tables I get a blank repot, even though I know that there is data
that should appear. I used to do this with no problem. Below is a sample
of one report that is coming out blank.

SELECT
PURCHASE_ORDER."ID", PURCHASE_ORDER."VENDOR_ID",
PURCHASE_ORDER."ORDER_DATE", PURCHASE_ORDER."DESIRED_RECV_DATE",
PURCHASE_ORDER."PROMISE_DATE",
PART."ID", PART."DESCRIPTION", PART."UNIT_MATERIAL_COST"
FROM
"SYSADM"."OPERATION" OPERATION,
"SYSADM"."PURCHASE_ORDER" PURCHASE_ORDER,
"SYSADM"."PART" PART
WHERE
OPERATION."VENDOR_ID" = PURCHASE_ORDER."VENDOR_ID" AND
OPERATION."STATUS" = PURCHASE_ORDER."STATUS" AND
OPERATION."DRAWING_ID" = PART."DRAWING_ID" AND
OPERATION."DRAWING_REV_NO" = PART."DRAWING_REV_NO" AND
OPERATION."DRAWING_FILE" = PART."DRAWING_FILE" AND
PART."ID" = '100080'

Am I doing something wrong? Thanks KAT

 

[Madawc]

Try commenting out parts of the command and see what you get. That should isolate the problem.

Madawc Williams
East Anglia, Great Britain

 

[synapsevampire]

I'm surprised that you're using a Cross Join, why not join the tables in some meaningful way?

-k

 

[PlsHlpKat]

I am not sure what you mean by join the tables in some meaningful way I am very new to Crystal Reports and have had no training just learning as I go. Could you explain in more detail?

Thanks!

Kat

 

[Madawc]

For Crystal 8.5, you find [Visual Linking Expert] under [Database] on the menu. Link fields that way, it saves a huge amount of coding.

Madawc Williams
East Anglia, Great Britain

 

[PlsHlpKat]

I am running Crystal 8.0 and I orginally set this up using the standard report wizard.

I now went into Visual Linking Expert and cleared the links then linked the tables. I am still getting the same results.

 

[Madawc]

The data must be something other than what you thought it was. I repeat my earlier suggestion, remove the tests so you get something and should get a clue about what the problem is.

Madawc Williams
East Anglia, Great Britain

 

[PlsHlpKat]

Thank you that helped I did find a problem!