将公式添加到BIRT Report Excelsheet结果 [英] Adding formula to BIRT Report Excelsheet Result

问题描述

我正在使用BIRT和新的，并且我坚持在这种情况下，请任何人帮助了解我的假设有什么错误。

Hi I am using BIRT and new also, and I stuck in this situation, Please anyone help to understand what wrong in my assumption..

上述图像是我的报告布局，我试图获得三个主题总数，所以在计算列的帮助下，JavaScript函数我已经计算了总计，参考下面的图像。

The above image is my report layout, and i am trying to get three subject total, so with the help of computed columns javascript functions i have calculated the total,refer below image.

其实我按预期得到了总值（见下文图像为结果）

Actually i got the Total value as expected.(see below image for result)

我的问题是，我想在Excel中使用公式总计字段中的公式总计。

My Question is I would like to have the Total with formula in excel sheet for my "Total with formula" field.

如何实现这一点，我已经尝试了一整天的谷歌搜索，还没有任何结果。

How can i achieve this, I have tried and googled one whole day for this, still not got any results.

从googl阅读一些我在下面知道的文章，

From googling and reading some articles i got to know below things,

ExcelEmitter.ValueAsFormula = true //UserProperty for a label makes a formula and it will reflect in the BIRT excel report.

ExcelEmitter.DisplayFormula = true //for Sheets set to true.

Label value =[subject1][subject2][subject3]

做了上述两件事情，我没有得到预期的结果。

I did the above two things and i didn't get the expected result.

我需要做什么才能在BIRT excel工作表输出中获得这个公式。

What are the necessary things i need to do to get this formula in the BIRT excel sheet output..

编辑

我尝试设置值如下，结果不是我的预期..
布局

用户参数

I tried set values as below and the result is not what i expected.. Layout Userparameter

浏览器中的结果

如果有任何网站或文章有解决方案，那么请分享这篇文章。

If any websites or article that has a solution for this,then please share in this post.

推荐答案

您需要在标签上创建几个UserProperties，如以下屏幕所示。

You need to create a few UserProperties on the label, such shown on the screen below.

此示例可从此处获得。注意有一个报告参数允许启用/禁用公式列，默认情况下它被禁用。真正的Excel公式有点复杂，我简化了截图。这可以避免使用行号和分页符的问题：

This sample is available here. Take care there is a report parameter allowing to enable/disable the formula column, by default it is disabled. The real Excel formula is a little bit more complicated, i simplified it for the screenshot. This one allows to escape issues with row number and pagebreaks:

=INDIRECT("E"&ROW())/INDIRECT("C"&ROW())

这篇关于将公式添加到BIRT Report Excelsheet结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！