部署后更新默认参数 [英] Updating Default Parameters after deployment
问题描述
大家好，
我正在使用2017年的SQL报告服务，我有一个基于查询内置参数的报告。 问题是我想要一个报告，我可以将其部署到不同的文件夹，只需添加默认参数，具体取决于它所在的文件夹（不同的
用户可以访问不同的文件夹）。 例如：文件夹A具有参数0100,0200,0300但文件夹B具有默认参数0900,1000,2000。
我相信在过去几年中您可以创建参数查询可用值，只需在报表服务器中选择它们作为网站端此特定报表的默认值。 我知道我可以简单地打开报表生成器并在那里调整它们
但这将由一些最终用户管理，我宁愿它们不在实际的RDL中。
目前，如果我导航管理报告并选择参数，我可以选择使用默认复选框，我可以根据我在RDL中设置的内容查看所有可用值，但是它不允许我检查下一个框价值观。
有人有任何想法吗？
谢谢
G
您好格兰特霍奇森
根据您的描述，似乎您要将报表部署到报表服务器的不同文件夹，然后每个报表都有不同的参数选项值，对吗？
似乎当前设计不可用。
如果可能，您可以尝试在部署之前使用ssis进行映射。
如果您的参数选项值来自qu ery，然后您可以尝试在部署之前根据文件夹名称编辑rdl中的数据集查询。
赞：如果文件夹名称是A，则更改rdl中的查询<跨度>&NBSP;
（从表中选择optionvalue，其中optionvalue为（ 0100,0200,0300 ））
然后使用该脚本运行rs.exe将报告部署到文件夹A. / p>
您可以在
ssis论坛。
希望它可以帮到你。
最好的问候，
Eric Liu
Hi All,
I am using SQL reporting services 2017, I have a report that has built in parameters based upon a query. The issue is I want one report that I can deploy to different folders and simply add default parameters depending upon what folder it is in (Different users have access to different folders). For example: Folder A has parameter 0100, 0200, 0300 but Folder B has default parameters 0900, 1000, 2000.
I believe in years past you could create parameters from a query as available values and simply select them in Report Server as the defaults for this specific report on the website side. I know I could simply open report builder and adjust them there but this is going to be managed by some end users and I would rather they were not in the actual RDL.
Currently if I navigate to manage the report and select parameters, I can select the use Default checkbox, I can see all the available values based upon what I set up in the RDL, but it will not allow me to check any boxes next to the Values.
Anybody got any ideas?
Thanks
G
Hi Grant Hodgson
According to your description , seems that you want to deploy the report to different folder of the report server ,and then each report have different parameter option values ,right ?
Seems it was not available by current design.
If possible , you could try to use the ssis to do the mapping before deployment.
If your parameter option values are from query, then you could try to edit the dataset query in the rdl based on the folder name before deployment.
Like : if the folder name is A , then change the query in the rdl like (select optionvalue from table where optionvalue in (0100,0200,0300))
And then use the script to run the rs.exe to deploy the report to the folder A.
You could ask more detailed information about the step at ssis forum .
Hope it can help you.
Best Regards,
Eric Liu
这篇关于部署后更新默认参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
