Dynamic list of values with manual entry

[Bisquite]

Hi,

I am trying to solve a problem caused by Crystal only returning the first 1000 values in a prompt. I cannot edit the registry settings to change this however.

I have a report using a stored proc as the data source with a parameter @Case. I have created a list of values from a Business View that gives a list of clients and the cases assigned against them.
In the report I have then set up the @Case parameter to use this list with 2 prompts. So the user first selects a client, and is then presented with a dynamic list of that client's cases.
This works fine, but there are around 20,000 clients so the first drop-down box does not display all of them.
Ideally I want the user to be able to manually enter a client number, then for the 2nd prompt to use this to display the dynamic list of cases.

Can anyone think of a way of doing this? Dynamic cascading prompts only seem to work for drop-down boxes (which cannot be edited at run time).

CR XI R2
SQL server 2000

Thanks for any assistance.
B

 

[dgillz]

Why can't you edit the registry? To my knowledge this is the only way to address this limitation.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Bisquite]

Thanks for the quick response.

My preference would be not to edit the registry, I am working for a client that has strict policies on such things.

If we were to try it though, would we need to change the BO Enterprise server's registry or the client pcs, or both?

 

[IdoMillet]

The registry change would be needed on the server side. However, this is not a very user-friendly solution so, as you say, a better approach is to have a type-in prompt for the Client ID.

Consider a 3rd-party tool as a solution (for a list of such tools, see

http://www.kenhamady.com/bookmarks.html).

My DataLink Viewer software has a more flexible approach to cascading & dynamic parameters. Among other things, it would easily allow you to have a regular type-in parameter cascading down to a drop-down dynamic parameter.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com