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