SSRS报表如何设置下拉框?
0
命令如下
SELECT C.FirstName + ' ' + C.LastName AS Employee, DATEPART(Year, SOH.OrderDate) AS OrderYear, DATEPART(Month, SOH.OrderDate) AS OrderMonthNum,
DATENAME(Month, SOH.OrderDate) AS OrderMonth, SUM(SOD.LineTotal) AS Sales
FROM Sales.SalesOrderHeader AS SOH INNER JOIN
Sales.SalesOrderDetail AS SOD ON SOH.SalesOrderID = SOD.SalesOrderID INNER JOIN
Sales.SalesPerson AS SP ON SOH.SalesPersonID = SP.SalesPersonID INNER JOIN
HumanResources.Employee AS E ON SP.SalesPersonID = E.EmployeeID INNER JOIN
Person.Contact AS C ON E.ContactID = C.ContactID
WHERE (DATEPART(Year, SOH.OrderDate) <= @ReportYear - 1 OR
DATEPART(Year, SOH.OrderDate) = @ReportYear AND DATEPART(Month, SOH.OrderDate) <= @ReportMonth) AND (SOH.SalesPersonID = @EmpID)
GROUP BY C.FirstName + ' ' + C.LastName, SOH.SalesPersonID, DATEPART(Year, SOH.OrderDate), DATEPART(Month, SOH.OrderDate), DATENAME(Month,
这里report可以出现如下图的3个字段:
SELECT C.FirstName + ' ' + C.LastName AS Employee, DATEPART(Year, SOH.OrderDate) AS OrderYear, DATEPART(Month, SOH.OrderDate) AS OrderMonthNum,
DATENAME(Month, SOH.OrderDate) AS OrderMonth, SUM(SOD.LineTotal) AS Sales
FROM Sales.SalesOrderHeader AS SOH INNER JOIN
Sales.SalesOrderDetail AS SOD ON SOH.SalesOrderID = SOD.SalesOrderID INNER JOIN
Sales.SalesPerson AS SP ON SOH.SalesPersonID = SP.SalesPersonID INNER JOIN
HumanResources.Employee AS E ON SP.SalesPersonID = E.EmployeeID INNER JOIN
Person.Contact AS C ON E.ContactID = C.ContactID
WHERE (DATEPART(Year, SOH.OrderDate) <= @ReportYear - 1 OR
DATEPART(Year, SOH.OrderDate) = @ReportYear AND DATEPART(Month, SOH.OrderDate) <= @ReportMonth) AND (SOH.SalesPersonID = @EmpID)
GROUP BY C.FirstName + ' ' + C.LastName, SOH.SalesPersonID, DATEPART(Year, SOH.OrderDate), DATEPART(Month, SOH.OrderDate), DATENAME(Month,
这里report可以出现如下图的3个字段:
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
3 个回复
gogodiy - 天善智能数据库专家、Tableau爱好者 2015-11-09 回答
赞同来自: nihuang
如果允许多选,那么选择“允许多个值”,然后选择“可用值”:
如果手动添加下拉框内容,则选择“指定值”,然后逐一点击“添加”按钮添加值,并且可以自由调整显示顺序;如果来自一段T-SQL查询或者存储过程,那么:
选择“从查询中获取值”,第一个“数据集”是下拉框数据来源,在“报表数据”里事先添加好的,“值字段”是真正的参数内容,“标签字段”是在下拉框里显示的内容。
还可以选择设置默认值。
悟 - 取是能力,舍是境界 2015-11-08 回答
赞同来自: 天桥下的郑成功
天桥下的郑成功 - Hadoop大数据开发工程师、数仓架构师、熟悉数据仓库设计、Hadoop、Spark、HBase、Hive、SSIS等开发 2015-11-09 回答
赞同来自: