Ver 8.0 A to B, A to C

[dande]

I am working with 3 tables - Client(A), Address(B) and Communaction(C). One client has many addresses and many phones. Addresses and phone have many types - Client, Parent etc. with start and end dates. I set up a Client group and 2 detail sections for related tables. I can filter out types and enddates, but in attempting to report a client with current address and phone I get the double reporting because I cannot activate the linking option of "Look up all of one, then all of others." I've tried the example in their help with no luck. What am I overlooking?
PaulC@DAndECenter.com

 

[IdoMillet]

That option is available only for "Direct Access" data sources (e.g., MS Access, dBase). It is not available with ODBC.

You could use MS Access to link to the tables in your ODBC data source and then use Crystal against the MS Access database using a direct access method.

Otherwise, if you explain the situation and the desired output in more detail, it may be possible to suggest a solution that doesn't require that option.

Cheers,
- Ido

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

http://www.MilletSoftware.com

 

[dande]

Thanks for the offer! We have a MSSQL200 db with a new Delphi frontend app. I need to report active clients with current client address and current client phone. I inserted a group of clients by name(L,F) filtered no 'termdate'. Then established links to related address and phone tables -left outer. Related tables filtered to type = "Client" and no 'enddate'. Then created 2 overlayed detail sections 1 for address, other for phone. Tried different suppressions but I still get some duplicated reporting because of the mulitple related record combinations.
Paul;

 

[IdoMillet]

Do you have more than one record with no end_date?
If you, you would indeed get record inflation.

Do you need to show more than 1 current address and more than 1 current phone info if they exists?
If so, consider showing in the detail records the address info and then insert the phone info as a linked (by cust_code) subreport in the group footer (for each customer).

Cheers,
- Ido

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

http://www.MilletSoftware.com

 

[dande]

There should only be 1 address & phone record without an end date, but you understand how data entry goes. As you recommonded, I did designed the report with 2 subreports, which has greatly lengthened the report run time as I expected. I just was trying to make the report as efficient as possible.
Thanks for your time and knowledge.
Paul