英文:
SSRS: Display a different word (alias) in parameter than that in login domain
问题
我正在为多家相关公司创建报告,并使用用户的登录域来限制数据只显示他们所属的公司。问题在于域名与公司名称不匹配。我需要在参数中显示公司名称,以消除对他们所看到的内容的困惑,特别是对于使用多个域名登录的用户。这是否有可能?如果可以,请提供一些说明。
我正在使用以下语句来提取域名:=Split(User!UserID, ""\").GetValue(0)
例如:域名/登录如xyz/bsmith,但我需要显示ABC而不是域名xyz
域名/登录如mno/ajordan,但我需要显示JKL而不是域名mno
我有一个包含域名和公司名称的表,或者我可以创建表之间的连接来完成相同的操作。
我可能在错误的方法中搜索此问题,但我找不到类似这个问题的答案。
已尝试谷歌搜索多个相关短语,以及尝试在stackoverflow内部搜索,但没有成功。
英文:
I am creating a report for several related companies and using the user's login domain to restrict the data to thier specific company. The problem is that the domain doesn't match the company name. I need to display the company name in the parameter to eliminate confusion as to what they are seeing, especially for the users that login using multiple domains. Is this possible? If so please provide some instructions.
I am using the following statement to pull the domain: =Split(User!UserID, "\").GetValue(0)
EX: domain/login like xyz/bsmith, but i need to display ABC instead of the domain xyz
domain/login like mno/ajordan, but I need to display JKL instead of the domain mno
I do have a table that contains the domains and company names, or I can create a join between tables to do the same thing.
I may be searching for this the wrong way, but I can't find any questions like this issue.
Googled several related phrases, as well as attempted to search inside stackoverflow with no success.
答案1
得分: 1
我不确定我是否理解您的问题,因为您已经有一个包含域名和公司名称的表,所以只需创建一个名为dsCompany
的数据集,查询类似于:
SELECT Company FROM myTable WHERE DomainName = @userdomain
这应该会自动将userdomain
参数添加到您的报表中,但如果没有,请手动创建一个(它们区分大小写,所以请检查拼写),然后将其默认值设置为:
=Split(User!UserID, "\").GetValue(0)
如果这不起作用,请详细说明情景,模拟一些用户期望看到的图像等。
英文:
I'm not sure if I understand what your problem is as you already have a table with the domains and company names so just create a dataset called say dsCompany
with a query something like
SELECT Company FROM myTable WHERE DomainName = @userdomain
This should automatically add a userdomain
parameter to your report, but in case that didn't happen, just create one (they are case sensitive so check spelling) then set its default value to
=Split(User!UserID, "\").GetValue(0)
If this does not help, please explain the scenario in a bit more detail, mock up some images of what you expect the users to see etc..
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论