dynamic parameter doesn't display complete list of values

building reports crystal reports
1

Hi Experts,

I searched across forum topics however not found the answer I am looking.

I have created a very simple crystal report with dynamic parameter to returns the complete list of values from the database field however noticed distinct values of the field in database is 155 however parameter list box displays only 19.

What could be the reason of not displaying all the 155 distinct values in the report parameter list box? what’s the solution? any help would be highly appreciated.

FYI…
I have used Crystal Report 2008, Oracle 10g. I also haved Crystal Report v10 installed in my machine.

BOKris (BOB member since 2003-08-27)

2

Hi Kris,

You need to change the registry settings, by default I think you it only populates dynamic parameters from the first 1000 lines of data.

I must stress it does come with the disclaimer that if your not happy with editing the registry yourself, keep searching until your confident with what your doing!

For 2008, I think you’ll need to navigate to 12.0 instead of the 11.0 referenced below, it works fine on my installation of Crystal Reports XI.

  1. Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.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.
    NOTE: The value 0 (Unlimited) will not work with BusinessObjects Enterprise XI or Crystal Reports Server XI,
    you must specify another value.

This link probably doesn’t exist any more now if they’ve moved over to the SAP website so you might have to do some digging if you don’t get redirected, but here it is anyway;
http://support.businessobjects.com/library/kbase/articles/c2017238.asp

shrek1895 (BOB member since 2005-08-23)

3

Hi Shrek,

Thanks for your reply.

Unfortunately, the solution you provided didn’t work for me. I am not sure if I missed anything after changing registry setting?

Also, the below link is not accessible to me. By chance you have saved copy of the article?

BOKris (BOB member since 2003-08-27)

4

Did you find any solution?
I think i’m phasing same issue.
I have dynamic parameter link to command, and in drop down for that parameter i do not see all the values, only one appearer for this example: 345by138_Xf_flo
345by138_xf_flo
But i ideally i need to see both of them.
When i have this parametr as field on report, both values appear.

Please HELP…

kolsasha :moldova: (BOB member since 2007-01-31)

5

If you can see the parameter values by using the same in report then you can use it in the report section and hide it.

In my case parameter list of values are uncomplete due to using Command object as report query. To resolve the issue I have to create LOV using Business View and schedule the list of values.

BOKris (BOB member since 2003-08-27)