Home » Archive

Articles in the CR XI Category

CR XI, Crystal Reports »

[14 Mar 2009 | No Comment | ]

Symptom
CR by default will not sort the report based on ASCII values.
Dificulty:
Intermediate – Expert
Workaround:
You need to create a formula with following code :
Â
ASC({tablename.fieldname})
Sort the report based on this field. Now, you can see that the report is sorted based on ASCII values.
Above steps will help to sort the report based on ASCII values.
Â

CR XI, Crystal Reports, Uncategorized »

[14 Mar 2009 | No Comment | ]

Symptom
In Crystal Reprots Normally the number of entries in the drop-down list box in the “Select
Expert” window is limited since the database has more values:
Difficulty:
Intermediate – Expert
Solution:
To increase the number of entries in the drop-down list box in the “Select Expert” window,
try the following steps:
1. Close the Crystal Reports XI.
2. On the ‘Start’ menu, click ‘Run’.

3. Type ‘Regedit’ in the ‘Open’ text box, and then click ‘OK’.
4. In the Windows Registry Editor, navigate to the following sub key:
Update the following registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\ DatabaseServer\
Select the string “MaxNBrowseValues”, right click …