本文介绍了将公式添加到BIRT Report Excelsheet结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在使用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..LayoutUserparameter

浏览器中的结果

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

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结果的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-31 08:17