Sage 100

 View Only
  • 1.  Crystal Reports 2011, Sage 100 v2016 Advanced, Dyn

    Posted 10-07-2016 15:18
    Crystal Reports 2011, Sage 100 v2016 Advanced, Dynamic Parameter Limit. Found the registry fix to increase the dynamic parameter limit. However, it only fixes reports when run within Crystal Reports. It does not work when running run-time Crystal from the module's custom reports menus. It also does not work when using Logicity. This is very urgent for my customer who just upgraded. Does anyone know how to fix?


  • 2.  RE: Crystal Reports 2011, Sage 100 v2016 Advanced, Dyn

    Posted 10-10-2016 06:16
    We did this Registry Change for a client, and If I recall correctly; it did correct the problem when running from withing Sage 100 on the Custom Report Menu. Is this the change you did for your client? 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


  • 3.  RE: Crystal Reports 2011, Sage 100 v2016 Advanced, Dyn

    Posted 10-10-2016 10:46
    @Madeline. Yes, this is the exact fix that I did, but it only fixes running from within Crystal for me - not running from menus or Logicity.