Crystal Reports - Dynamic Parameter Limit

[mouazaltabbaa]

I am currently encountering an issue with a Crystal Report that I have created. The report includes a dynamic parameter with more than 1000 values, causing the list to display only the initial 1000 entries. This limitation is due to Crystal Reports having a default constraint of 1000 lines.

After researching potential workarounds online, I discovered a solution involving the addition of a registry key. Specifically, I added a string key named "MaxRowsetRecords" with a value exceeding 1000 to the following registry path: HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV. This successfully overcame the line limit, as evidenced by the Crystal Reports tool.

However, upon importing the report into SAP Business One and attempting to open it from within the system, the issue persisted. The list continued to display only the initial 1000 values. Despite extensive research, I have been unable to find a solution within SAP B1, as most references only mention the registry fix without addressing the issue within the SAP B1 environment.

I would greatly appreciate your insights and any guidance you could provide on resolving this matter within SAP B1.

[DellSC · Accepted solution]

The same registry setting needs to be applied to the server where B1 is running reports.

I'm not sure whether B1 uses the 32-bit runtime or the 64-bit runtime for Crystal. If it's 32-bit, the registry path will change slightly to

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV

-Dell

[mouazaltabbaa · Accepted solution]

i am actually working directlly on the server and i edit the bath with wow6432Node but what i noticed there wasn't a key with the name DatabaseOptions so i have created it manually but still the same

[DellSC · Accepted solution]

You might have to either restart the B1 services or reboot the server for the change to take effect. For most applications, registry changes made while the application is running do not automatically take effect.

-Dell

[mouazaltabbaa · Accepted solution]

i tried restart the service and the server still the same problem

[DellSC · Accepted solution]

Is your B1 system using just the Crystal runtime to run reports or is it connected to either Crystal Reports Server or BusinessObjects to run reports?

-Dell

[mouazaltabbaa · Accepted solution]

hello Mr.Dell

i am using Crystal runtime to run the reports

[DellSC · Accepted solution]

Is the Crystal runtime installed on the B1 server or on a separate web server? (I don't use B1, but I know how things work from the Crystal side of things.)

-Dell

[mouazaltabbaa · Accepted solution]

yes in the same server

[mouazaltabbaa · Accepted solution]

the strange thing is the list inside the crystal report is working perfectly but when i open from inside the SAP B1 no change are effected

[DellSC · Accepted solution]

It's strange that it's not getting picked up by the runtime. At this point I'm at the limit of what I know to tell you. You might need to open a support ticket on this. I would open it for B1 rather than Crystal because it's working correctly in Crystal.

-Dell

[mouazaltabbaa · Accepted solution]

ok thank you very much for your support and taking the time to answer me

bets regards