I'm using CR XI r2.

I have created a dynamic parameter to have a drop-down of all the product numbers in the database from which to select for the report.  Unfortunately, it is only displaying the first 1000 product numbers.  There are currently a total of 1606 product numbers/rows in the MySQL database.

I created a SQL Command and set it as the Data Source for the parameter:

select prod_id
from prod_specsheet

Still only the first 1000 rows.  I tried:

select all prod_id
from prod_specsheet

Still only the first 1000.

I am at a loss as all the solutions I've been able to google still result in only the first 1000 rows of the database being displayed in the dropdown.

Does anybody have any suggestions?

DBlank,

Thank you for the reply.  Unofrtunately, it did not resolve my problem.  However, I discovered that when the report is run through my Crystal.net application all product numbers are displayed in the drop-down.  It is only when I open the report in Crystal Reports itself that I do not see all of the product numbers.

So, until I find that I need the full listing while designing/editing reports, I will considered this problem resolved.