SSRS主副报告参数问题

发布于 2024-12-11 12:23:32 字数 1528 浏览 0 评论 0原文

我正在使用 Visual Studio 2008 BIDS 创建包含子报告的报告。这只是我创建的第二份 ssrs 报告,所以如果我没有使用正确的术语,请原谅我。现在,当我尝试在 BIDS 中预览报告时,我收到此错误消息:

[rsWarningExecutingSubreport] Warnings occurred while executing the subreport         ‘lineItemsSubReport’.
[rsNone] The report parameter 'salesOrderId' is read-only and cannot be modified.
[rsNone] The report parameter 'salesOrderId' is read-only and cannot be modified.
[rsNone] The report parameter 'salesOrderId' is read-only and cannot be modified.
[rsNone] The report parameter 'salesOrderId' is read-only and cannot be modified.

在子报告上,我的参数已设置为内部,但我已将其更改为隐藏。

我正在使用 FetchXMl 来查询这两个报告。

我的主报告包含一个数据集,其中有一个名为 salesorderid 的字段。我试图将此值传递给子报告,执行以下操作:

<Subreport Name="lineItemsSubReport">
  <ReportName>LineItemsSubReport</ReportName>
     <Parameters>
        <Parameter Name="salesOrderId">
           <Value>=Fields!salesOrder_salesorderid.Value</Value>
        </Parameter>
     </Parameters>
     <Top>0.38542in</Top>
     <Left>0.125in</Left>
     <Height>0.62499in</Height>
     <Width>5.98958in</Width>
     <ZIndex>1</ZIndex>
     <Style>
        <Border>
            <Style>None</Style>
        </Border>
      </Style>
</Subreport>

在我的子报告中,我有一个查询过滤器和一个名为 salesOrderId 的查询参数以及一个名为 salesOrderId 的报告参数。这个设置对吗?如果不是,如何设置子报告以获取从主报告传递的参数?这看起来应该很容易,但是却有点痛苦。

谢谢!

I'm using Visual Studio 2008 BIDS to create a report that contains a sub report. This is only the second ssrs report I've created so forgive me if I'm not using the correct terminology. Right now when I try to preview the report in BIDS I get this error message:

[rsWarningExecutingSubreport] Warnings occurred while executing the subreport         ‘lineItemsSubReport’.
[rsNone] The report parameter 'salesOrderId' is read-only and cannot be modified.
[rsNone] The report parameter 'salesOrderId' is read-only and cannot be modified.
[rsNone] The report parameter 'salesOrderId' is read-only and cannot be modified.
[rsNone] The report parameter 'salesOrderId' is read-only and cannot be modified.

On the subreport, my parameter was set to internal, but I have changed to it hidden.

I'm using FetchXMl for the query for both reports.

My main report contains a data set that has a field called salesorderid. I'm trying to pass this value to the sub report doing this:

<Subreport Name="lineItemsSubReport">
  <ReportName>LineItemsSubReport</ReportName>
     <Parameters>
        <Parameter Name="salesOrderId">
           <Value>=Fields!salesOrder_salesorderid.Value</Value>
        </Parameter>
     </Parameters>
     <Top>0.38542in</Top>
     <Left>0.125in</Left>
     <Height>0.62499in</Height>
     <Width>5.98958in</Width>
     <ZIndex>1</ZIndex>
     <Style>
        <Border>
            <Style>None</Style>
        </Border>
      </Style>
</Subreport>

In my sub report I have a filter on the query and a Query Parameter named salesOrderId and a Report Parameter called salesOrderId. Is this setup right? If not how do I setup the sub report to get the parameter that is passed from the main report? This seems like it should be easy, but it's being a bit of a pain.

Thanks!

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

扫码二维码加入Web技术交流群

发布评论

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

评论(1

七婞 2024-12-18 12:23:32

好吧,我以某种方式让它发挥作用,但我不太确定我到底做了什么。如果我弄清楚了,我会发布答案。

Well I somehow got it to work, but I'm not quite sure what excatly I did that did it. I will post the answer if I figure it out.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文