Sage 100

Sage 100 Premium v2018. I have a dynamic parameter in my Crystal report to pull the list of Item Codes, but it stops at the 1,000th record. I see an article written by  @Wayne Schulz and other tech site articles that advise editing the registry to add a key for LOV and a string value MaxRowsetRecords with a value slightly more than the number of records in the table. I followed the procedure, but it still doesn't show more than 1,000 records in the list. Any thoughts as to what I may not be doing correctly? 

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
Fresno CA
803.252.6154 x242
559.577.4142
90 Minds Treasurer
------------------------------

I've had to reboot the machine before after that change. Have you tried that yet?

------------------------------
Amber Prayfrock, Blytheco
------------------------------

Hi, Amber. No, I haven't. I'll see if I can get that done. Thank you for the advice!

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
Fresno CA
803.252.6154 x242
559.577.4142
90 Minds Treasurer
------------------------------

Original Message:
Sent: 12-19-2020 00:04
From: Amber Prayfrock
Subject: Crystal Reports 2016 Dynamic Parameter Record Limit

I've had to reboot the machine before after that change. Have you tried that yet?

------------------------------
Amber Prayfrock, Blytheco
------------------------------

That registry entry needs to be set at the workstation level, not just the server.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

I thought so, based on what I was reading. Thanks for the confirmation, David.

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
Fresno CA
803.252.6154 x242
559.577.4142
90 Minds Treasurer
------------------------------

Original Message:
Sent: 12-19-2020 13:28
From: David Speck II
Subject: Crystal Reports 2016 Dynamic Parameter Record Limit

That registry entry needs to be set at the workstation level, not just the server.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

The IT guy and I are striking out on this. I watched him make the registry changes, reboot, and then I tried my report. It actually lists fewer than 500 records, not even 1,000, and there are about 3,000 items. I don't know why this isn't working or what else I can try. Any ideas?

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
Fresno CA
803.252.6154 x242
559.577.4142
90 Minds Treasurer
------------------------------

Original Message:
Sent: 12-19-2020 13:29
From: Karen O'Lane
Subject: Crystal Reports 2016 Dynamic Parameter Record Limit

I thought so, based on what I was reading. Thanks for the confirmation, David.

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
Fresno CA
803.252.6154 x242
559.577.4142
90 Minds Treasurer
------------------------------


Original Message:
Sent: 12-19-2020 13:28
From: David Speck II
Subject: Crystal Reports 2016 Dynamic Parameter Record Limit

That registry entry needs to be set at the workstation level, not just the server.

------------------------------
David Speck II
Tennessee Software Solutions

Are you creating the registry entry in the correct locations?

I have the following in a .bat file.  It writes the lines that start with ECHO to a .reg file in the same directory as the .bat file when ran and then imports the contents of the .reg file into the registry, it then deletes the .reg file.  It works on 32 bit or 64 bit windows since it queries the registry to determine processor configuration.

reg Query "HKLM\Hardware\Description\System\CentralProcessor\0" | find /i "x86" > NUL && set OS=\ || set OS=Wow6432Node\
(
ECHO Windows Registry Editor Version 5.00
ECHO.
ECHO [HKEY_LOCAL_MACHINE\SOFTWARE\%OS%SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV]
ECHO "MaxRowsetRecords"="99999"
ECHO.
ECHO [HKEY_LOCAL_MACHINE\SOFTWARE\%OS%SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV]
ECHO "MaxRowsetRecords"="99999"
) > "%~f0.reg"
REGEDIT.EXE /S "%~f0.reg"
DEL "%~f0.reg"
EXIT​

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 01-28-2021 20:37
From: Karen O'Lane
Subject: Crystal Reports 2016 Dynamic Parameter Record Limit

The IT guy and I are striking out on this. I watched him make the registry changes, reboot, and then I tried my report. It actually lists fewer than 500 records, not even 1,000, and there are about 3,000 items. I don't know why this isn't working or what else I can try. Any ideas?

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
Fresno CA
803.252.6154 x242
559.577.4142
90 Minds Treasurer
------------------------------


Original Message:
Sent: 12-19-2020 13:29
From: Karen O'Lane
Subject: Crystal Reports 2016 Dynamic Parameter Record Limit

I thought so, based on what I was reading. Thanks for the confirmation, David.

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
Fresno CA
803.252.6154 x242
559.577.4142
90 Minds Treasurer


Original Message:
Sent: 12-19-2020 13:28
From: David Speck II
Subject: Crystal Reports 2016 Dynamic Parameter Record Limit

That registry entry needs to be set at the workstation level, not just the server.

------------------------------
David Speck II
Tennessee Software Solutions

David, cool. I'll see if we can try this. Thank you.

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
Fresno CA
803.252.6154 x242
559.577.4142
90 Minds Treasurer
------------------------------

Original Message:
Sent: 01-28-2021 21:52
From: David Speck II
Subject: Crystal Reports 2016 Dynamic Parameter Record Limit

Are you creating the registry entry in the correct locations?

I have the following in a .bat file.  It writes the lines that start with ECHO to a .reg file in the same directory as the .bat file when ran and then imports the contents of the .reg file into the registry, it then deletes the .reg file.  It works on 32 bit or 64 bit windows since it queries the registry to determine processor configuration.

reg Query "HKLM\Hardware\Description\System\CentralProcessor\0" | find /i "x86" > NUL && set OS=\ || set OS=Wow6432Node\(ECHO Windows Registry Editor Version 5.00ECHO.ECHO [HKEY_LOCAL_MACHINE\SOFTWARE\%OS%SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV]ECHO "MaxRowsetRecords"="99999"ECHO.ECHO [HKEY_LOCAL_MACHINE\SOFTWARE\%OS%SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV]ECHO "MaxRowsetRecords"="99999") > "%~f0.reg"REGEDIT.EXE /S "%~f0.reg"DEL "%~f0.reg"EXIT​

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 01-28-2021 20:37
From: Karen O'Lane
Subject: Crystal Reports 2016 Dynamic Parameter Record Limit

The IT guy and I are striking out on this. I watched him make the registry changes, reboot, and then I tried my report. It actually lists fewer than 500 records, not even 1,000, and there are about 3,000 items. I don't know why this isn't working or what else I can try. Any ideas?

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
Fresno CA
803.252.6154 x242
559.577.4142
90 Minds Treasurer


Original Message:
Sent: 12-19-2020 13:29
From: Karen O'Lane
Subject: Crystal Reports 2016 Dynamic Parameter Record Limit

I thought so, based on what I was reading. Thanks for the confirmation, David.

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
Fresno CA
803.252.6154 x242
559.577.4142
90 Minds Treasurer


Original Message:
Sent: 12-19-2020 13:28
From: David Speck II
Subject: Crystal Reports 2016 Dynamic Parameter Record Limit

That registry entry needs to be set at the workstation level, not just the server.

------------------------------
David Speck II
Tennessee Software Solutions