linking to multiple tables at the same time

[thecricketer]

Please help!

What am I missing? I am linking from one table to two others using the same field. The section on how to handle linking two files from the one file is greyed out! I need to look up one table then the next, it won't allow me to do this!

Thanks

http://www.ais-lims.com

 

[kenhamady]

You are probably using SQL. This only works in Dbase or Btreive reports. 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

 

[thecricketer]

Ken,

I am using SQL, I used to use DBase and I knew I could use it there. What would you suggest to get around this issue in SQL?

Thanks

http://www.ais-lims.com

 

[kenhamady]

The only ways to do this in SQL is to use a UNION in the SQL (maybe writing a stored procedure) or to use subreports, which will have lots of limitations. 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

 

[thecricketer]

Thanks Ken,

That's the conclusion I had come to here. It's just a shame this functionality isn't available?

http://www.ais-lims.com

 

[kenhamady]

That would be handy, but union joins are more complex for a reporting tool to handle than are the regular joins. However, CRv9 is supposed to allow SQL to be entered directly into the report. That will make unions available without access to the database. 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