Dynamic Parameter not showing all products.

Hello,

I am using CR 2008. I have a dynamic parameter which the user chooses a product. The issue is the drop down parameter list is not showing all the products. The only way I can show the second half of the list is if I choose Descending by value. I have 6 reports with this issue and there all using the same db table for products. I don't want to have to have two parameters for ascending and descending for the user to be able to pick a product.

Thanks,

Eric