Lookup info in an unlinked table

[BlindPete]

I'm rather new to CR so if this obvoius please dont flame me.

I have two differnt databases (ODBC) and for reasons I won't bore you all with I can not link one table between the two databases.

Since the table is tiny (only 3 fields and <20 records) I wonder If I can't just use a WHILE or FOR loop to scan the table in a function that would be good enough.

Or if I could write my own SQL into a function that would work to.

BUT I've been stymied by both methods today.

Any ideas please help.
-Pete

 

[IdoMillet]

Use a subreport...

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[BlindPete]

well errr no I seek to avoid sub reports if possible. here is the problem I am surmounting:

TableA TableB TableC
id------->id id
fieldB fieldC

Because of companies screwey and proprietary ODBC driver I need to get a data in TableB via TableA link as shown.

TableC is tiny 20 record three field table in which the following relationship exists LEFT(fieldB,2)=fieldC BUT I can not link the two fields (unfortunately)

I need to group by fieldC and FieldB. I know I can do it with a subreport but I prefer not to.

Is there any lookup functions in CR? like Variable = lookup(LEFT(fieldB,2),TableC,LookupField or LookupIndex).


I want to group
-Pete

 

[HowardHammerman]

Nope. The only way is with a sub-report like Ido says. If your data is in *.dbf format, you can use R&R which DOES allow linking on a formula field.

Howard Hammerman,
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269