ReportServer Forum

Johann

Member

Registered: 2022-05-30

JXLS Report - `SUM()` function not working on generated rows

I am trying to do a SUM() calculation on one of the columns generated by my SQL query, and following the GitHub example shown here: https://ibb.co/2KchrC1 (https://github.com/infofabrik/reportser … eries.xlsx)

Say cell A2 I have the Excel note with a valid SQL query, then:

in A2 I have: ${product.quantity}
in cell A3 I have: SUM(A2)

When the report is executed, the result shows 0 in cell A3 instead of the sum of the values of the rows generated. The method I have used seems correct and looks in line with the JXLS documentation here http://jxls.sourceforge.net/samples/excel_formulas.html and here https://reportserver.net/en/guides/admi … S-Reports/

In fact, trying out the JXLS reports in the demo instance, it seems the same issue there: https://ibb.co/9TZSGGP

Link to demo: https://demo.raas.datenwerke.net/?local … 7d554e08d2

Any ideas what could be the issue?

Last edited by Johann (2022-06-09 07:17:57)

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: JXLS Report - `SUM()` function not working on generated rows

Hi Johann,

your screenshot shows only the preview window. If you click on excel export, which is what jxls is about, it should work. The preview is just a rough preview to see what happens in the report, but the real jxls report is the excel export.

Regards,
Eduardo

Johann

Member

Registered: 2022-05-30

Re: JXLS Report - `SUM()` function not working on generated rows

Ah, no wonder. Thank you!