1704511 - How to NOT paginate a List Of Values parameter prompt

• An application built using Crystal Reports SDK for VS .NET
• Report has a List Of Values (LOV) parameter list longer than 500 values
• The list is paginated at 100 values
• How to create an LOV that is not paginated?

• Crystal Reports for Visual Studio 2010
• Visual Studio 2010

• Modify the app configuration file (app.config for windows applications, web.config for web applications)
• Unaltered config file:

<?xml version="1.0"?>

<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="CrReports.My.MySettings.ConnectionString" connectionString="Data Source=sqltest;Initial Catalog=Reports;Integrated Security=True"  providerName="System.Data.SqlClient"/>

    </connectionStrings>
    <startup>
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
    </startup>

</configuration>

• Modify the config file as follows:

 <?xml version="1.0"?>

<configuration>
    <configSections>
        <sectionGroup name="businessObjects">
        <sectionGroup name="crystalReports">
          <section name="crystalReportViewer" type="System.Configuration.NameValueSectionHandler" />
        </sectionGroup>
      </sectionGroup>
      </configSections>
    <connectionStrings>
        <add name="CrReports.My.MySettings.ConnectionString" connectionString="Data Source=sqltest;Initial Catalog=Reports;Integrated Security=True" providerName="System.Data.SqlClient"/>
    </connectionStrings>
    <startup>
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
    </startup>
 
<businessObjects>
    <crystalReports>
      <crystalReportViewer>
        <add key="maxNumberListOfValues" value="2000"/>
      </crystalReportViewer>
    </crystalReports>
  </businessObjects>
</configuration>

• MaxNumberListOfValues value=2000 controls how many items appear in a prompted parameter before pagination occurs

CR2010 2010 CR4VS2010 CR4VS VS2010 NET2010 Crystal Reports for .NET Framework 4.0 crforvs 13 page param , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , How To

SAP Crystal Reports, version for Visual Studio all versions