Wednesday, September 09, 2009 4:12 PM
We have several MS Reporting Service Reports at my company that were using a parameter that I’ll call “Person”. We display the reports on our ASP.NET Website and when a report is selected that needs the Person parameter we show a Person DropDownList. For some reason this was working fine on several reports, but not for a new report. We verified through the Reporting Service interface and by looking at the actual parameter data in the database that everything looked correct. The Person parameter for the non-working report was identical to the working report. We wasted a lot of time looking for a solution as to why this wasn’t working and eventually figured out that we just needed to reverse the orders of the parameters in the non-working report. For some reason the Person parameter needed to be the last parameter instead of the first parameter. Hopefully this helps if someone else runs into this issue.