SHOW ALL RECORDS PLEASE

[CHUDMAN]

// show all records CR8 with oracle 8 db


// here is my attempt
// to show all records available
// and if a record appears within the second table then
// show the count that is in the specified field.
// else a "0" Numerical number should show
// in front of the reporting Form_File_Name field.

if {V_FORM_NAME.FORM_FILE_NAME} = {V_FORM_COUNT.FORM_FILE_NAME}
then {V_FORM_COUNT.NUM_USED}
else "0"


// this will not return the {V_FORM_NAME.FORM_FILE_NAME}
// that does not appear in {V_FORM_COUNT} table.


Please help with possible solution.

 

[Shirley]

Did you ever figure out how to show all records, I would greatly appreciate any information on the subject.

 

[rogar]

Join tables V_FORM_NAME => V_FORM_COUNT with a Left Outer Join to include all records in V_FORM_NAME and only those records from V_FORM_COUNT with a matching {FORM_FILE_NAME} field. Where no matching record exists, V_FORM_COUNT fields will be NULL.

 

[kenhamady]

It isn't real clear, but it sounds like you are trying to have the report list data that doesn't have a record. The following has an article that lists your options:

http://www.kenhamady.com/news0208.html

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com