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.

SQL View,Stored Procedure's are not showing in Crystal Report

Cause:
The number of database objects returned to CR is determined by the setting in the Windows Registry. The default value for this registry setting is 8,000. You can change this default value by editing the Windows registry setting, NTablesMax.
NTablesMax - specifies the number of database objects to get a listing of from the database. Once this number is reached the listing of objects in Crystal Reports is stopped. Objects can include tables, views, synonyms and stored procedures.

Solution:
To access the NTablesMax item in the registry:
1. On the Start menu, click Run.
2. Type "Regedit", then click OK. The Registry Editor will appear.
3. Browse to the following folder:
CR 2008
HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\FetchOptions
CR XI Release 2

HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal Reports\FetchOptions
CR XI (Release 1)

HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\FetchOptions

CR 10

HKEY_CURRENT_USER\Software\Crystal Decisions\10.0\Crystal Reports\FetchOptions
CR 9

HKEY_CURRENT_USER\Software\Crystal Decisions\9.0\Crystal Reports\FetchOptions

CR 8.5

HKEY_CURRENT_USER\Software\Seagate Software\Crystal Reports\FetchOptions
4. In the right-hand window of the Registry Editor, double-click NTablesMax. The 'Edit DWORD Value' dialog box appears.
5. Select Decimal.
6. In the Value Data text box type "10,000". Click OK.
7. Close the Registry Editor and then restart your computer.

The next time you open Crystal Reports, you will be able to see all 10,000 database object