So the test report I'm using is blank so there is no data to return. The query that populates the Text parameter works fine as the dropdown gets populated just fine. It is just when I click on the "view report" button does the error occur. If I load the dataset in the SSRS query builder returns everything as well. Lastly, as I've stated in my original post it works in BIDS but not when deployed.

Thanks,

Anthony