问题描述:

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

相关阅读:
Top