Drop Down Box options not being displayed

[OutInLeftField]

With Crystal Reports 8.5, I created a dropdown box based upon a sql connection to retrieve a list of users. In the preview, all of the users appear in the listing. When I published this report in Crystal Enterprise, only 20 or so users appeared.

Is there a setting on Crystal Reports server that limits the number of drop down items displayed for the report?

Thank you

Michael

 

[dgillz]

How did you create a 'Drop down box'. Do you mean a parameter field with default values?

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

http://www.gainfocus.biz

 

[OutInLeftField]

I used a sql command to select all of the users from the table. Then in the parameter default value screen I selected the sql command and all of the values. When I use Crystal Reports on my machine all of the required values appeared in the drop down box. But when I displayed the report in the web -based form (Crystal Enterprise), the listing went only to the B's (about 52 users).