Skip to Content
author's profile photo Former Member
Former Member

Parameter List not showing a complete list of values from database


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

Fydropdown2.jpg (28.1 kB)
Fydropdown1.jpg (216.0 kB)
Fydropdown3.jpg (107.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 09:57 PM
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Posted on Jan 09, 2014 at 03:14 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 03:52 PM

    Hi Kelvn,

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

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 04:41 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.