当前位置: 动力学知识库 > 问答 > 编程问答 >

ssrs 2008 - How to have a Reporting Services parameter automatically selected if there is only one

问题描述:

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

分享给朋友:
您可能感兴趣的文章:
随机阅读: