Schulz Consulting 833-724-3100

Sage 100cloud Consulting

  • Home
  • Services
  • Find A Local Sage Consultant
  • Contact Us
You are here: Home / Sage 100 ERP / How to increase the number of dynamic parameters in Crystal Reports

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

  • Sage Summit Atlanta Agenda Released February 18, 2019
  • Sage Summit San Diego 2019 Wrap-Up February 15, 2019
  • Is Sage 100 cloud hosting right for you? February 12, 2019

Our sponsors

  • APS Payments | Integrated Credit & ACH Payments for Sage 100
  • ScanForce | Bar Code Scanning, Mobile Warehouse Management, Sales Automation for Sage 100cloud
  • Summit Hosting | Secure Hosting for Sage 100 & Sage 100cloud

Contact Us

Schulz Consulting
160 Oak Street
Glastonbury, CT 06033
Phone: 833.724.3100
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide. We are a local affiliate of DSD Business Systems.

Copyright © 2019 · 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.