Categories
Crystal Reports Ripplestone Ripplestone Tips

Updating the Page Size in the Parameters List

With the new version of the Crystal Reports Runtime Engine there is page size limit that determines how many parameter values are in each page of values.  The default is 200 values per page or batch.

Below is an example of a report that has 2100 parameters.  The parameters are broken up into 11 pages of values.  The first page has the first 200 parameter values and as you move through the pages you get the next 200 values.

image

 

This page size can be changed in Ripplestone by updating the web.config file located in C:SitesRipplestoneweb.config (this is an XML file that can be updated with a text editor).

Look for a section called <businessObjects> and add or change the line highlighted below.  In the example the value is set to 500, but this can be any value.

  <businessObjects>
    <crystalReports>
      <crystalReportViewer>
        <add key="documentView" value="printlayout" />
        <add key="EnableTextClipping" value="true" />
        <add key="maxNumberListOfValues" value="500" />
      </crystalReportViewer>
    </crystalReports>
  </businessObjects>

 

After the config file has been changed to allow 500 values per page, there are only 5 pages of values.

image

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }

By jlyon12

I'm a partner at TechSol Consulting and we make a software application called Ripplestone that is used to publish, manage, distribute and schedule Crystal Reports. We also create custom websites for ecommerce sites.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s