vb.net – 带参数的RS.exe订阅报告

发布时间：2020-12-17 00:23:12 所属栏目：大数据来源：网络整理

导读：我试图通过rs.exe创建动态报表订阅.我怎么不能让参数工作. enddate值是数据/时间,所以我认为这可能会导致它,但我不知道如何处理它.我已经尝试过施法,但错误信息.保持不变. rs.exe调用： C:Program Files (x86)Microsoft SQL Server130ToolsBinnrs.exe -

我试图通过rs.exe创建动态报表订阅.我怎么不能让参数工作. enddate值是数据/时间,所以我认为这可能会导致它,但我不知道如何处理它.我已经尝试过施法,但错误信息.保持不变.

rs.exe调用：

C:Program Files (x86)Microsoft SQL Server130ToolsBinn>rs.exe -i C:UsersmeDesktoprss_gensubs.rss -s "localhost/ReportserverT"

subs.rss文件：

Public Sub Main()
    rs.Credentials = System.Net.CredentialCache.DefaultCredentials

    Dim desc As String        = "Report description"
    Dim eventType As String   = "TimedSubscription"
    Dim scheduleXml As String = "<ScheduleDefinition><StartDateTime>2017-12-08T15:00:00</StartDateTime><WeeklyRecurrence><WeeksInterval>1</WeeksInterval><DaysOfWeek><Thursday>True</Thursday></DaysOfWeek></WeeklyRecurrence></ScheduleDefinition>"
 Dim parameters() As ParameterValue


    ' If you need setup parameters

      Dim parameter As ParameterValue
        parameter.Name = "enddate"
        parameter.Value = "2017-12-30 10:03:01.250" 'this is date/time
    parameters(0) = parameter



    Dim matchData As String = scheduleXml


    Dim returnValue As String

    Dim reports() As String = { _ 
        "/My Folder/report"}

    For Each report As String In reports
        returnValue = rs.CreateSubscription(report,parameters)
        Console.WriteLine(returnValue)
    Next

End Sub 'Main`enter code here`

错误消息：

C:UsersmeeAppDataLocalTemp11dhexge0m.1.vb(43) : error BC30455:
Argument n ot specified for parameter ‘Parameters’ of ‘Public Function
CreateSubscription(R eport As String,ExtensionSettings As
Microsoft.SqlServer.ReportingServices2005. ExtensionSettings,
Description As String,EventType As String,MatchData As Stri ng,
Parameters() As
Microsoft.SqlServer.ReportingServices2005.ParameterValue) As String’.

让我教你一个在.Net中编程的技巧.这听起来很简单,你需要做的就是传递他们期望的功能.让我举个简单的例子.

使用此代码我遇到了类似的错误：

CS7036 There is no argument given that corresponds to the required formal parameter ‘fileName’ of ‘FileInfo.FileInfo(string)’

红色的波浪线告诉你问题所在.如果我输入左括号,它会给我一个工具提示,它符合预期：

好吧,它需要一个字符串,所以我声明一个字符串并将其提供给它所期望的函数：

所以你遇到的问题是因为你没有给CreateSubscription函数提供它期望的参数.

Argument not specified for parameter ‘Parameters’ of ‘Public Function CreateSubscription

要修复它,请提供ReportingService2005.CreateSubscription Method的所有必需参数：

public static void Main()
   {
      ReportingService2005 rs = new ReportingService2005();
      rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

      string report = "/SampleReports/Employee Sales Summary";
      string desc = "Send email to anyone@microsoft.com";
      string eventType = "TimedSubscription";
      string scheduleXml = @"<ScheduleDefinition><StartDateTime>2003-02-24T09:00:00-08:00</StartDateTime><WeeklyRecurrence><WeeksInterval>1</WeeksInterval><DaysOfWeek><Monday>True</Monday></DaysOfWeek></WeeklyRecurrence></ScheduleDefinition>";

      ParameterValue[] extensionParams = new ParameterValue[8];

      extensionParams[0] = new ParameterValue();
      extensionParams[0].Name = "TO";
      extensionParams[0].Value = "dank@adventure-works.com";

      extensionParams[1] = new ParameterValue();
      extensionParams[1].Name = "ReplyTo";
      extensionParams[1].Value = "reporting@adventure-works.com";

      ParameterValue parameter = new ParameterValue();
      parameter.Name = "EmpID";
      parameter.Value = "38";

      ParameterValue[] parameters = new ParameterValue[1];
      parameters[0] = parameter;

      string matchData = scheduleXml;
      ExtensionSettings extSettings = new ExtensionSettings();
      extSettings.ParameterValues = extensionParams;
      extSettings.Extension = "Report Server Email";

      try
      {
         rs.CreateSubscription(report,extSettings,desc,eventType,matchData,parameters);
      }

      catch (SoapException e)
      {
         Console.WriteLine(e.Detail.InnerXml.ToString());
      }
   }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!