Parameter List not showing a complete list of values from database

[Former Member]

Hi,

  In my database table,there are 8 different year period, however, when i run the report, it display only 2 years period for me to select, is there any something wrong on my setting? what I need to do in order to display all year period for the year parameter?

  I install crystal report 2011 on my laptop..

Thanks

Kelvin

[Former Member · Accepted solution]

guy,  thanks for the answers, I found one link is helpful:

http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_b...

[Former Member · Accepted solution]

Hi Kelvin Ho,

What exactly u have done to resolve ur issue? I mean u have only 8 values input parameters, But the system by default supports upto 1000 values.

Could u be plz give the exact solution which you have done.

Thanks & Regards,

Mahesh.

[former_member477249]

Can you test this with a 'New' dynamic parameter that is created by selecting the 'New' radio button instead of 'Existing' in the 'Edit Parameter' window.

It is strange to see this happening for a list of just 8 values.

-Prathamesh

[abhilash_kumar]

Hi Kelvn,

Please have a look at this post for the registry key solution Dell mentioned above.

-Abhilash

[DellSC]

It is doing this because it doesn't read all of the records in order to provide the list.  If you search here, you should be able to find information about a registry key you can set to increase that number.  However, this can be slow and there is a better way to do this.

I would create a command (SQL Select Statement) that pulls just the distinct list of year periods.  DO NOT link the command to any of the tables in your report - Crystal will throw up a warning that this configuration is generally not supported, but it's ok in this situation.  Then use the values from the command ONLY in the prompt and not anywhere else in the report.

-Dell

[former_member584790]

This is still valid. Just fixed this issue i was having with Illinois counties, it was only showing me 5.