Periodically, a report that has one parameter does not have any available values in the dropdown list. Where the dropdown list would normally read <Select a Value>, it is blank with nothing populated in it. When the issue occurs, I have no problem returning the same result set by running the query directly against the source database. Addinally, I have tried changing the the available values dataset from a simple select statment to a stored procedure...this did not help.
Any idea what may be causing this issue? Thanks in advance.
Start Free Trial