CR 8.5: Linking in a dBase table with Oracle Tables

[TEM3]

I created a sub-set of an Oracle table (Excel to dBase). I want to use the sub-set as a selection criteria.

CR 8.5 reads the dBase table fine. But I have no idea of how to link it to my Oracle tables.

What do I need to do? Would I have been better to convert the table to Access??

 

[rosemaryl]

Dear TEM3,

Depending upon the needs you can:

A. Click Database/Add Database and (assuming you have a dsn for this new table) select the database and table. Now, you have to link the two tables in Visual Linking expert on some field they share in common.

Create a report on the dbase table and then create a subreport linked on the main report ....

What made you decide to create a subset of the table to use as selection criteria? Could you not have effected the same thing in the Select Expert?

Please be advised that if you link tables from 2 databases you will receive an informational warning:

"More than one datasource or Stored Procedure has been used in this report. Make sure that no SQL Expression is added and no Server-Side group by is performed."

This simply means that you will not be able to add SQL Expressions and that you cannot turn on the Perform Grouping on Server checkbox in Report Options for this type of report.

More info on what you are actually trying to do may assist.

Regards,
ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[TEM3]

This is a report that selects evidence that is ready to be returned to a Police Agency. There are about 400 evidence storage locations. About 100 of them are designated for evidence ready to be returned. I did not want to type in 100 locations into the Select Expert.

 

[rosemaryl]

Dear TEM3,

What designates that the evidence is ready to be returned? Something on paper or in the db ... because if it is in the db then that is the field you want to base your selection criteria on.

If it is on paper, then won't you have to continually update your *subquery*?

Regardless, you should be able to do an equal join on location number, now that the how has been explained.

Best regards and good luck,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762