如何在不引用其他单元格的情况下将Reporting Services 2005中的报表导出到Excel？

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:

我正在使用Reporting Services 2005,并将报告导出到Excel中。除了被引用的单元格外,一切都很好。一个例子是:

textbox1 has the value 10
textbox2 has the value 20
the formula in textbox3 is

textbox1的值为10 textbox2的值为20,textbox3中的公式为

=ReportItems!textbox1.value + ReportItems!textbox2.value

textbox3 would have the correct result 30 on the reporting services display.

textbox3在报告服务显示上具有正确的结果30。

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.

但是当我将报告导出到excel时,textbox应该是的值是对excel表中textbox1和textbox2的位置的引用而不是值。

how can i export the value and not the references to the other two cells?

我如何导出值而不是其他两个单元格的引用?

Thank You,

1 个解决方案

#1

When referring to a textbox.value in a formula that adds two [numbers] together you need to change the datatype:

当引用一个将两个[数字]加在一起的公式中的textbox.value时,您需要更改数据类型:

textbox1.value =10 textbox2.value =20 textbox3.value =CInt(ReportItems!textbox1.value) + CInt(ReportItems!textbox2.value)

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.

当您将此报告导出到Excel时,您将获得每个值(10 | 20)和两者的总和 - 不引用它们占用的单元格。

I hope this helps.

我希望这有帮助。

#1