Long List of Values (LOVs)

building reports crystal reports
1

In CR 2008, there is a new feature “Prompting Dialogue for Long List of values”. What it does is when the system detects more than 200 records in either a static or dynamic list of values, it will ‘batch’ the list of values into chunks of 200 records, and allow you to navigate between the chunks using the navigation arrows. Our users do not like this new feature since for some LOVs we only have fewer than 500-600 LOVs and they want to see all values just by scrolling top to bottom. Is there a way to somehow push the detection to maybe 1000 recs before the new feature come into play ?

AnthonyJ :philippines: (BOB member since 2006-06-30)

2

There are two methods for changing the number of items in a long LOVs.
When prompting the user, Crystal Reports retrieves the long LOV batch size from this Windows registry location:
HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\ReportView
If it does not already exist, create the DWord value called PromptingLOVBatchSize, and set the value to the number of items in a batch.
Note: Be careful to select Decimal as the base value before entering the batch size.
You can create or change a parameter in the Tomcat configuration file to set the batch size for long LOVs. Open the following file:
{CR_install_folder}/Tomcat/webapps/CrystalReports/WEB-INF/web.xml
If it does not already exist, create this parameter:

<context-param>
  <param-name>crystal_max_number_list_of_values</param-name>
  <param-value>{number}</param-value>
</context-param>

Where {number} in the above example is the number of items in the batch.

You can find this information under Crystal Report 2008 Help

nahtanoj :philippines: (BOB member since 2009-07-08)

3

Thanks for the tip.

AnthonyJ :philippines: (BOB member since 2006-06-30)