English 中文(简体)
贵国如何利用《社会行动计划》第2段为相关报告设定SSRS报告参数?
原标题:How do you set SSRS report parameters for a linked report using the SOAP API?

我的情况是,我需要我的报告服务器,因为我们正在把报告电文控制在伙伴关系中。 该网络的网络应用和用户群体将获得各种报告。

这将使用2008年服务器标准版。

安保工作将通过编制相关报告(每名用户各一份,在要求从我们的网页上发布报告时常发表),但我难以按方案确定相关的报告参数值。

简言之,报告有少量保留参数名称(例如用户信息数据库和语言信息数据库)。 定期,网络用户将核查用户是否有链接报告(为每个报告/用户使用独特的链接报告名称),如果不存在,则制作一个。

正在利用SSRSSOAP AP AP PIC,并做了大量工作。 I m的问题在于为相关报告确定报告的范围。

例如,如果我是一家星座,我只想看到报告,并完全掌握报告观众的参数。 如果我以“低”用户身份表示,我预计用户信息数据库的参数将在相关报告中确定给我的身份证,并且无法改变用户信息数据库,在其他用户报告中进行选择。

可以通过开放相关报告的财产,确定参数缺省值,不核对“适当用户”箱,以人工方式做到这一点。

现在,我试图以方案方式使用《社会行动计划》的版本来做这项工作,似乎无法找到这样做的正确方式。

我在几个地方读到“创建链接报告”方法能够确定参数的背后,但我开始认为这只是作者的误解。 虽然这种方法确实接受一种财产,但这些财产似乎只提供元数据(如相关报告名称)。

我是否需要用财产名称/价值来标明财产是报告参数?

任何想法都受到高度赞赏。

最佳回答

Ah! 签字!

There are 2 SOAP methods: GetReportParameters and SetReportParameters

这些文件被记录为与报告一起工作,这些报告与报告关系很大,但APIC中的这一功能范围似乎与两者并进。

For any future searchers: I ve written a method to receive a ReportParameter[] (the result of GetReportParameters called on the linked report) and iterate through them. Pseudo/almostC# code:

ReportParameter[] reportParameters = ReportingService2005.GetReportParameters(LinkedReportName);
foreach( ReportParameter reportParameter in reportParameters)
{
   switch(reportParameter.Name)
   {
      case "ReservedParam1":
         reportParameter.DefaultValues = new string[1];
         reportParameter.DefaultValues[0] = CalculateReservedParam1();
         reportParameter.PromptUser = false;
      //etc
   }
}
try
{
   ReportingService2005.SetReportParameters(reportParameters);
}
catch (Exception e)
{
   // if error occurs while replacing params, delete linked report so user can t specify parameters they aren t entitled to
   ReportingService2005.DeleteItem(LinkedReportName);
   throw e;
}
问题回答

暂无回答




相关问题
An error has Occurred During Report proccesing

When I m running the report I m getting that message above. The Report Works fine when I press the "Run Report" Button but I want also to avoid that annoying message that appears when the page loads. ...

Reporting services only displaying the last row

I have built a report pretty basic just a table wiht 45 rows of data. Problem is its only showing one row of data and its the last row. It displays just fine in the dataset and proc. any ...

Show Parameters for Reports In SSRS

I m developing an SSRS in Visual Studio BIDS. In it, I have a link that links to another report (report A). Report A has 4 parameters (dates). When I click on that link, it goes to report A fine, but ...

How to add group, or page field in an existing .rdl report

I have several .rdl reports designed for our client. However, they need new ones, that are relatively similar to the old ones. Differences are in the "group" and "page fields" (these can be changed ...

Report rendering using SSRS in Google Chrome

Hey, In our project, we use SSRS integrated with asp.net forms to render reports. The report looks good in IE. when it comes to google chrome, there re some issues we face such as date picker not ...

热门标签