SSRS 中的数据方法参数

发布于 2024-12-13 07:41:18 字数 568 浏览 2 评论 0原文

我为 SSRS 报告编写了一个数据方法，如下所示。我创建了一个名为 County 的参数，它工作正常。

当我尝试将参数的多值属性更改为 true 时，它停止工作。

我意识到我需要一个数组来执行该 String [] 但我不知道要更改什么。

谁能帮助我吗？我还需要添加更多参数。举个例子就太好了。

public static System.Data.DataTable GetContactList(String County)
{
    var ranges = new Dictionary<string, object>
    {
      {"ContactPerson.1.County", County}
    };
    var dt = Microsoft.Dynamics.Framework.Reports.AxQuery.ExecuteQuery("Select   ContactPerson.1.Name, ContactPerson.1.County from Contactsquery", ranges);
    return dt;
}

原文

I wrote a datamethod for my SSRS report as seen below. I created a parameter called county and it is working fine.

When I tried to change the multivalue property of the parameter to true it stopped working.

I realized I need an array to do that String [] but I do not know what to change.

Can anyone help me? I also need to add more parameters. An example would be great.

public static System.Data.DataTable GetContactList(String County)
{
    var ranges = new Dictionary<string, object>
    {
      {"ContactPerson.1.County", County}
    };
    var dt = Microsoft.Dynamics.Framework.Reports.AxQuery.ExecuteQuery("Select   ContactPerson.1.Name, ContactPerson.1.County from Contactsquery", ranges);
    return dt;
}

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

偏闹i 2024-12-20 07:41:19

您看过这篇博文吗：http://www.axepclipboard.com/?p=198

请注意，AllowBlank 为 False，并且该方法返回一个数组：

public static System.Data.DataTable GetContactList(string[] _county){
    var ranges = new Dictionary<string, object>
    {
      {"ContactPerson.1.County", _county}
    };
    var dt = Microsoft.Dynamics.Framework.Reports.AxQuery.ExecuteQuery("Select   ContactPerson.1.Name, ContactPerson.1.County from Contactsquery", ranges);
    return dt;
}

希望这会有所帮助！

Have you seen this blogpost: http://www.axepclipboard.com/?p=198

Notice the AllowBlank is False, and the method returns an array:

public static System.Data.DataTable GetContactList(string[] _county){
    var ranges = new Dictionary<string, object>
    {
      {"ContactPerson.1.County", _county}
    };
    var dt = Microsoft.Dynamics.Framework.Reports.AxQuery.ExecuteQuery("Select   ContactPerson.1.Name, ContactPerson.1.County from Contactsquery", ranges);
    return dt;
}

Hope this helps!

回复收藏 0 原文

~没有更多了~