Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Unable to find available master link field

edited April 2009 in General
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

Comments

  • edited April 2009
    Hi Justin,

    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2009
    Looks like I made a mistake with my version number. As soon as I installed
    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


  • edited May 2009
    Hi 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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2009
    Nico,

    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

  • edited May 2009
    Hi 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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2009
    I figured out the problem. I looked back at our other programs to find
    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

This discussion has been closed.