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

SAP Knowledge Base Article - Public

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

Symptom

  • 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?

Environment

  • Crystal Reports for Visual Studio 2010
  • Visual Studio 2010

Resolution

  • 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

Keywords

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

Product

SAP Crystal Reports, version for Visual Studio all versions