GET VISUAL LINKING MESSAGE WHEN LEAVING DATABASE EXPERT 1

[TNN]

I am using the RDC in VB6.
After editing the linking and leaving the Database Expert I am getting the following Visual Linking mesage:

"Your current link configuration contains multiple starting points. Please be advised that this is generally not supported."

I have no idea what this is saying. In the Databse Expert I have both multiple tables and multiple command objects as "selected tables". Only 4 of the seven objects are linked, and all of the 4 are linked with a common field.

What is that message trying to tell me???

TNN, Tom


TOM

http://WWW.TNPAYROLL@AOL.COM

 

[synapsevampire]

It's saying what you just said, that you have multiple recordsets.

Crystal only supports one recordset at a time. If you have multiple recordsets, then these additional recordsets should probably be in subreports.

Perhaps you can describe your environment and intent technically so that someone can help:

Crystal Version
Database used
Connectivity used
Example Data
Expected output

-k

 

[TNN]

synapsevampire,
By one recordset at a time do you mean only one command object?? But multiple tables are ok??? Or do the command objects need their own subreport all alone????

Using:
Crystal Version 9.0
Access Database
Microsoft jet OLEDB ADO
Data is from multiple different tables. Sometimes has to be in the form of a recordset created with an SQL stmnt. The end result report is in fact a payroll check with the attached detailed checkstub.

If each command object is going to require a subreport I can probably live with that.
TNN, Tom







TOM

http://WWW.TNPAYROLL@AOL.COM

 

[TNN]

synapsevampire,
I have eliminated the command objects that contained the recordsets and have remaining 5 tables only. Only 2 of the tables are linked. Still getting the visual linking message.
What are those multiple starting points??? Do all the tables need to be linked?? is that what their saying??

TNN, Tom


TOM

http://WWW.TNPAYROLL@AOL.COM

 

[GMcNamara]

Conceptually, having an unlinked table does not make sense. If the table is not used, remove it from the report. If the table is used, it should be linked.

If you want to use the table but it doesn't link with the rest of the tables, then this should be a subreport.

Your report can contain multiple command objects, however, they must be linked together. So, each command object will not require a subreport, unless it does not link with the rest of the report.

 

[TNN]

GMcNamara,
OK then it looks like when any table is not linked I am going to get that visual linking message. I in fact have tested and it works just like that.

I do have tables and/or command objects that cannot be linked and as you say I will have to use them in a subreport. This could be cumbersome as some of these fields in the unlinked command object or table are not in one place in the report but scattered about the report. This may require multiple subreports.

Thank you for your input. TNN, Tom


TOM

http://WWW.TNPAYROLL@AOL.COM