I'm using SQL Server Reporting Services (SSRS) developed in Visual Studio 2010 to build my reports.
If there is only one item in a report parameter drop-down then I would like that item automatically selected. Instead of getting Select a Value and then having to manually a select that item (when it's the only one in the list).
At the moment, I deal with this by having the default value of the report parameter set by a stored procedure that checks the row count of the items in the parameter list and returns a default if there is only one. But this seems like overkill.
Is there a way I can set this in Reporting Services?
Looks like I'm going to do this with a stored procedure (the way I'm doing it now): MSDN Answer