Parameter Not showing all values from database 1

[sds786]

Hi there,
I am using cr xi r2 with Oracle 11.
I'm working on a report having parameter Employee ID where I have to display all existing values in drop down list from the database.
There are more than 5000 employees in my related table but in my parameter drop down list I can only see about 1000 record but when I display that field in the report that show all records there.
A solution w'd be appreciated.

 

[lbass]

By default the parameter pick lists are limited to 1000 values. There is a way to change this by changing a registry key, but you should only do this if you are experienced with working with the registry. Check with BO knowledge base for more information.

Note that more than 1000 values becomes unwieldy for a user to wade through. You could consider using a command as the source of your picklist where you narrow the list by adding other criteria.

-LB

 

[sds786]

Thanks Ibass for your response, actually I was already doubted about this fact and I just need to confirm from an expert like you, Tek-Tips is a great site and I really glad to join this forum

 

[sds786]

Hi Ibass, I have some experience working on Registry (ODBC setting)I would appreciate if give me directions to change registry, thanks.

 

[lbass]

This article might be helpful:

https://www.sdn.sap.com/irj/servlet...43330333033303331333233313338333533383338}.do

Click OK whenever it asks for a digital certificate.

-LB

 

[sds786]

Wonderful, thanks Ibass.

 

[sds786]

Hi Ibass,
I reviewed the article and just need to make sure, that if I am working in server-client environment and our server is maintained by citrix, then where I should modify the registry file? if I apply on server side then will that work for all user/clients?
Thankis.

 

[lbass]

I have no clue and I personally don't feel comfortable with making any recommendations about working with the registry. Maybe someone else can help. Sorry.

-LB

 

[sds786]

Anyway, I appreciate your directions, actually I did the other solution, I saved my query results (all employee list) in xls sheet and then imported to Crystal and that worked fine, that displays the complete list in drop down list, Thanks again for your help.