2 tables without relation

[Former Member]

Hi experts,

I have a connection ODBC to Oracle, and i need the information of 2 tables without join!

How can I do it? because always is askme about a connection!

[Former Member · Accepted solution]

There must be some relationship, otherwise why are you bringing in two tables.

If you do not join you will get a cartesian result, ie if each table has 100 records you will return 100 x 100 = 10,000 records.

If you want to display data from two tables which are unrelated use a subreport for the 2nd table.

Ian

[Former Member · Accepted solution]

Thank you Ian!

Can u use data from one report to other?

thanks a lot

[Former Member · Accepted solution]

yes using shared variables.

Always use

Whileprintingrecords;

in any formula evaluating, using or displaying shared variable.

Ian