Unable to find available master link field
Hi,
I am using Report Builder V. 11.04 with Delphi 2009 on a Windows XP machine.
Currently I am receiving the error "Unable to find available master link
field" while trying to link two queries in the Data tab of the report
Designer. The queries were designed using the Query Designer. I also
occasionally receive the error "Unable to insert a line" when clearing links
from queries I just added to the Data tab. The links all use the
Parameterized SQL option. Here is how I have set up the queries to work
together in the report giving me problems:
Fleet_List_Main_ //manually edited query
|
|
|---Maintenance_Data //created with Query Designer
| |
| |
| ---Part_Associations //created with query Designer
|
|---Scheduled Repairs //created with Query Designer
The "master link" error occurs when I try to link Part_Associations to the
Maintenance_Data query. The "insert link" error occurs when I remove the
Part Associations query and then add it back in. When I click the Link
button it automatically tries to link the query to the Fleet_List_Main_
query which is the first one I created for this report. I hit the clear
button and then the "insert" error occurs.
Any help in deciphering these errors would be appreciated. I could not find
them anywhere else and I don't know if there is something I am not doing
right.
Thanks,
Justin
I am using Report Builder V. 11.04 with Delphi 2009 on a Windows XP machine.
Currently I am receiving the error "Unable to find available master link
field" while trying to link two queries in the Data tab of the report
Designer. The queries were designed using the Query Designer. I also
occasionally receive the error "Unable to insert a line" when clearing links
from queries I just added to the Data tab. The links all use the
Parameterized SQL option. Here is how I have set up the queries to work
together in the report giving me problems:
Fleet_List_Main_ //manually edited query
|
|
|---Maintenance_Data //created with Query Designer
| |
| |
| ---Part_Associations //created with query Designer
|
|---Scheduled Repairs //created with Query Designer
The "master link" error occurs when I try to link Part_Associations to the
Maintenance_Data query. The "insert link" error occurs when I remove the
Part Associations query and then add it back in. When I click the Link
button it automatically tries to link the query to the Fleet_List_Main_
query which is the first one I created for this report. I hit the clear
button and then the "insert" error occurs.
Any help in deciphering these errors would be appreciated. I could not find
them anywhere else and I don't know if there is something I am not doing
right.
Thanks,
Justin
This discussion has been closed.
Comments
This is not a known issue with RB 11.04. Are you able to recreate this
using the Report Explorer demo and the DBDEMOS database? If so, please give
me the steps I can take to create the error on my machine or send a simple
example in .zip format to support@digital-metaphors.com.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
11.04 the error was fixed, so thanks for the help. I do have another issue
now though. Some of our programs share common utility files and the Report
code is one of those. When I try to run one of our other programs with the
RB Source directory set in our library paths I get the following errors:
[DCC Fatal Error] USecurity.pas(166): F2051 Unit raParser was compiled with
a different version of ppRTTI.TraRTTIClassRegistry
[DCC Fatal Error] USecurity.pas(15): F2051 Unit raIDE was compiled with a
different version of ppDsgner.TppDesignerWindow
If I remove references to raIde and raCodMod from the Uses clause the
program compiles with no problems. Is there something I need to recompile
to include the Source directory in the library path?
Thanks for all of your help,
Justin
This error indicates that the interface section of one of the source files
has been altered or there is an old file still being used from an older
version of ReportBuilder. Check to be sure your library path is not
pointing toward any old RB files (.pas or .dcu).
If you are still getting the error, try to perform a corrupt install cleanup
and that should solve the issue.
http://www.digital-metaphors.com/rbWiki/General/Installation/Cleaning_Up_a_Corrupt_Install
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I have checked all of our library paths and followed the Corrupt install
steps, but I still receive the errors. The only other clue I have is that
our other program is kept on the same machine and it compiles with no
problems. Only one program seems to have this issue.
Thanks for the help,
Justin
Are you able to run the RAP demos located in the \Demos\0. RAP\...
directory?
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
anything that could be different in the Project --> Options page and found I
had set the Record Field Alignment option to Byte instead of Quad Word. Not
sure what what effect this has on the reports, but I can compile the program
now. Thanks for all the help and info.
Justin