How to combine specific fields within 2 unrelated tables

[cazellnu]

I had created a report base on betrieve database. It contains two tables that had 3 fields. Table A has Order#(indexed), field_name, Tray#. Table B has Inv#(indexed), field_name, Tray#. The question is how can I combine all and only the Tray# (without duplication) within both tables and display as one field within one report?

Any suggestion will be very apperciate.
Thank You

 

[synapsevampire]

Can't you just join on the tray?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[cazellnu]

I cannot join on the tray because tray from both table contains different set of tray number but I need to disaplay both

 

[Naith]

No one who hasn't seen your data schema can really answer that. Look at your data schema or speak to your data architect or DBA who should be able to inform you of common tables between the two tables you want to report against, that you may have to include in your report merely for linking purposes.

If you cannot feasibly link the two tables, you'll have to report against one table in the main report, and the other table in a subreport. This will be a little slower, but you won't have to worry about linking the data in the subreport to the main report.

Naith

 

[synapsevampire]

I think that you have some discovery to do here, as Naith described.

Since you don't have a means to join these tables, you also have no basis by which to place them in a single row.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[cazellnu]

The only fields that are in common within both tables are the "field name". However, It is meaningless to join the "field name" since I have no basis to place those tray in single row. I wonder if there is anywhere I can union "tray " within crystal in which similar to the function of Union within MS Access?

 

[cazellnu]

I understand that it can be done by the SQL Statement according the article within the knowledge base of crsyal decision site. However, since I have to access the data throught the ddf files, is there any alternative way?

 

[Ngolem]

is there only one value for Tray# in the Table A and one value for Tray# in Table B for a given Fieldname???

Just do an equals link on Fieldname

The if your problem is to display all of the data in a report then report the fields.

If you want to combine two fields then write a formula doing this if necessary

@combinedField

WhilePrintingRecords;

//if both fields are strings

{TableA.field} + " " + {TableB.field} ;

//Or if one is numeric use

totext({TableA.field},0) + " " + {TableB.field} ;

If this isn't your problem you will have to describe it alot better than you have done so far


Jim Broadbent