Limit in parameter values

[Sepie]

I am running Crystal 2008 and need to have a parameter with about 2,500 values to choose from. I realize it's a long list, but the end users wants to be notified if an entered value is not valid, and this is the only I know to do this.

Does anyone have any other recommendations?

Or, know if there is a limit in the values that can be used in parameter lists, dynamic or not?

Thanks

Sepie

 

[lbass]

Are you allowing multiple values for the parameter?

-LB

 

[Madawc]

There are different methods that could get the same result. You could put a subreport in the report header, that would check if the parameter entered was on the list. (I assume this would be distinct from having a correct parameter value but finding no data for the report.) You test IsNull for a field that won't be null if a record exists.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[GC2000]

Hi Sepie

It is possible but you need to change a registry item LOV. You should have everything up to that.

1. Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV.

2. Add a string value "MaxRowsetRecords" and set the value to 2500.

I recently had to do this and it did work for me.

 

[Sepie]

Hi All, thank you for your responses.

Ibass: yes, multiple values will be allowed.

Madawc: would this validation work if a user wants to enter multiple parameters for one run?

GC2000: I think I will probably need to take this route, although I was hoping there was a way to validate the values without having to create such a long list.

Thanks again.

Sepie

 

[Madawc]

If there are several parameters, you'd have to validate them separately, maybe using several subreports.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[JasGrand]

Hello, I was wondering... if we were to change this in the registry on the server... would it show up for the users who are viewing the reports online through the viewer or would we have to modify this registry setting on everyone's machine?

Thanks,


Jason