Schulz Consulting

Sage 100cloud Consulting

  • Home
  • Services
  • Contact

How to increase the number of dynamic parameters in Crystal Reports

October 30, 2013 by Wayne Schulz

logo-crystal-reports

There is a limit to Crystal Dynamic parameters. The limit is 1000 items, which may not be enough if you need all of your inventory items in a report selection criteria field.

Here’s how to change the limit:

Important: As with any changes to the system registry – do so at your own risk and have a backup. Incorrect changes may render your computer or applications inoperable.

 

Crystal Reports 2011

1. Create a registry key HKEY_HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV.
2. Add a string value “MaxRowsetRecords” and set the value to the maximum number of values that you desire for your report. For example, a value of 2000 will return up to 2000 values in the lowest level of a cascading parameter.
3. After making changes to the registry, restart the affected service or application as required.
NOTE: the registry key on 64 bit Operating Systems is:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP, Sage ERP, slider Tagged With: Crystal Reports, mas200, sage 100, Sage 100 ERP

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 and Sage 100cloud ( Formerly Sage MAS 90 and MAS 200) since 1986 and provides advanced Sage 100 technical support to companies located in Connecticut, Massachusetts, Rhode Island, New York and throughout the United States. If you are experiencing an issue with Sage 100, and would like to schedule a support session - please request assistance here or call 833-724-3100.

Search Our Site

Sage 100cloud Latest News

  • One or more Avatax objects could not be created. The Avalara Avatax adapter.dll must be registered to continue April 7, 2021
  • Eight Tips for Speeding Up Sage 100 March 22, 2021
  • Sage Dev Stream March 18, 2021 March 15, 2021
  • Sage 100 Files to Exclude from Antivirus Scanning March 2, 2021
  • WFH Tip For Sage 100: Go Paperless February 24, 2021
  • When is Sage 100 2021 Due for Release? February 19, 2021
  • Sage 100 Partner Cloud List of Supported ISVs as of January 2021 February 12, 2021
  • Sage 100 User Help Files and Table Layouts – Version 2018 – 2020 January 27, 2021

Our sponsors

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657-8544
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2021 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.