如何在rdl报告中传递参数 [英] How to pass an parameter in rdl report

问题描述

我有一个数据集，其结果来自以下查询



SELECT HREmployeeInfo.EmployeeId，HREmployeeInfo.EPFNumber，

HRTitle.TitleName +' '+ HREmployeeInfo.FirstName +''+ HREmployeeInfo.MiddleName +''+ HREmployeeInfo.LastName AS employeename，

HREmployeeInfo.EmployeeReferenceId

来自HREmployeeInfo LEFT OUTER JOIN

HRTitle ON HREmployeeInfo.Title = HRTitle.TitleId LEFT OUTER JOIN

HRUserAccount ON HREmployeeInfo.EmployeeReferenceId = HRUserAccount.EmployeeReferenceId

WHERE（HRUserAccount.UserAccountId = @useraccountid）



这里我想要一个参数，我在登录时会得到...



please任何机构都可以告诉我如何在浏览器

I have an dataset with result from below query

SELECT HREmployeeInfo.EmployeeId, HREmployeeInfo.EPFNumber,
HRTitle.TitleName + ' ' + HREmployeeInfo.FirstName + ' ' + HREmployeeInfo.MiddleName + ' ' + HREmployeeInfo.LastName AS employeename,
HREmployeeInfo.EmployeeReferenceId
FROM HREmployeeInfo LEFT OUTER JOIN
HRTitle ON HREmployeeInfo.Title = HRTitle.TitleId LEFT OUTER JOIN
HRUserAccount ON HREmployeeInfo.EmployeeReferenceId = HRUserAccount.EmployeeReferenceId
WHERE (HRUserAccount.UserAccountId = @useraccountid)

here i want an parameter which i am getting in session while logged in ...

please any body can tell me how will i pass the session value to the report's dataset while running on browser

解决方案

检查这些

在本地模式下使用报告参数 [ ^ ]

将输入参数添加到SQL报告 [ ^ ]

Check these
Using report parameters in local mode[^]
Adding input parameters to the SQL Report[^]

这篇关于如何在rdl报告中传递参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！