如何在不引用其他单元格的情况下将报表从 Reporting Services 2005 导出到 Excel？
我正在使用 Reporting services 2005，并将报表导出到 Excel 中。 除了已引用的单元格之外，一切都很好。 例如：
textbox1 的值为 10
textbox2 的值为 20
textbox3 中的公式为
=ReportItems!textbox1.value + ReportItems!textbox2.value
textbox3 将在报告服务显示上得到正确的结果 30。
但是当我将报表导出到 Excel 时，文本框应为的值是对 Excel 工作表中 textbox1 和 textbox2 位置的引用，而不是该值。
如何导出该值而不是对其他两个单元格的引用？
谢谢你，
I am using Reporting services 2005, and am exporting the reports into Excel. Everything is fine except for cells that have been referenced to. An example is this:
textbox1 has the value 10
textbox2 has the value 20
the formula in textbox3 is
=ReportItems!textbox1.value + ReportItems!textbox2.value
textbox3 would have the correct result 30 on the reporting services display.
but when i export the report to excel, the value where textbox should be is the reference to the location of textbox1 and textbox2 in the excel sheet instead of the value.
how can i export the value and not the references to the other two cells?
Thank You,
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
当在将两个[数字]相加的公式中引用 textbox.value 时，您需要更改数据类型：
textbox1.value =10
textbox2.value =20
textbox3.value =CInt(ReportItems!textbox1.value) + CInt(ReportItems!textbox2.value)
当您将此报表导出到 Excel 中时，您将获得每个值 (10|20) 以及各个值的总和两个 - 没有提及它们占据的单元格。
我希望这有帮助。
When referring to a textbox.value in a formula that adds two [numbers] together you need to change the datatype:
textbox1.value =10
textbox2.value =20
textbox3.value =CInt(ReportItems!textbox1.value) + CInt(ReportItems!textbox2.value)
When you export this report into Excel you will have each value (10|20) and the sum of the two - without the reference to the cells they occupy.
I hope this helps.