2007年11月22日 星期四

Manual fix for alias limitation in Crystal Reports XI

  • The alias characters ("\" and "\\") used by the IFS Crystal Report framework
    is not supported by Crystal Report Developer XI by default.
    Due to this reason when developing reports an error message is show
    when adding a backslash ("\") as an alias character to a table or view,
    informing the report developer that the backslash is not a supported alias character.
    In order to work with the alias characters used by IFS,
    these alias characters should be manually added to the system registry.
    Add the registry key given below manually to the system registry or
    follow the steps given below to add the alias characters to the system registry
    by creating and running a script file,
    1. Copy and paste the following text to any text editor
    · Windows Registry Editor Version 5.00
    · [HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Database]
    "InvalidAliasCharList"="!(){}"

    2. Save the file by giving a name but make sure the file extension is .reg
    (e.g InvalidAliasCharList.reg)
    3. RMB on the file and select "Merge" and run the script file.
    By adding this registry key Crystal Report Developer XI will only recognize characters entered in the key as invalid alias characters.
    Also read the information about the "Alternative alias naming mechanism (characters) due to bug in Crystal Reports" further down in the list of limitations.