Crystal Report Parameter Field Capacity

[Former Member]

Hai to all ,

I have using SAP B1 Crystal Report 2008 . i have created one command Query with Parameter field.

i have 5000 records in Database but parameter fields load first 500 records only .

How to solve this problem .

Ex:

Select DocEntry , Name , Description from Temp where DocEntry =

Temp Table Having 1 to 5000 Recored . but Parameter Field loaded first 500 records only .

Thanks & Regards

Madhubalan.R

[Former Member]

I confirm it's working on my configuration.

If this problem is on a report uploaded in CR Server 2008 don't try to modify the register of the server but the developer register.

Edited by: Paulo Calado on Jun 12, 2009 5:06 PM

[Former Member]

Hello Madhubalan,

You have to change the Register. We had the same problem with articles. We have > 20.000 articles. By using the Regedit and put in the code "MaxRowsetRecords"="(enter amount)" a full list will be presented. As we had several Suites, we have put in the code in every Suite.

Below how we have solved it:

[HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV]

"MaxRowsetRecords"="22000"

 
[HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal Reports\DatabaseOptions\LOV]

"MaxRowsetRecords"="22000"


[HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV]

"MaxRowsetRecords"="22000"

Best regards,

Tim

[Former Member]

HI Madhu ,

Just try to select the top 510 rows.

by using Select top n syntax, if its also not working , then it might be the crystal limitaion .

Rgds,

Premraj

[Former Member]

Hi

It could be limitation of crystal report .

Are you able to use wild card character to filter issue or not ?

My recommendation :

Donot create parameter for that which has more than 5000 records at one time .

Try to filter your record by using date parameter .

Hopefully that helps

Bishal