Hi
I have created a crystal report with a parameter Employee. This is a drop down list of Employee last names that the user chooses from. The problem is that it only shows one option, which is empty space (2 options if you count the nothing option that is the three dots(...)).
The thing is before I inserted some new data this worked fine. But now there is around 2500 rows and each can have an employee attached to it although most don't.
On the other hand my other drop down list that uses the same SQL and is created in exactly the same way works fine.
I have no idea what could be causing this. I thought it was the sql but I put the Name Of Employee the same thing the DropDownList should be picking up into this other report (this is a date report showing everything between 2 dates) and it shows up fine. Again, same sql select function for filling the report.
Is it the fact that there are so many rows and so many possible employees that is causing this?
What can I do to fix this?
Thank you