ReportServer Forum

joedhcs

Member

Registered: 2020-01-30

Report Server 3.1 and JXLS 2.x problem

I'm performing and evaluation of RSE 3.1 and would like assistance with the JXLS 2.x feature.  I understand this a new feature and the documentation is not up to date. I have a running installation of ReportServer and when I attempt to configure and execute a JXLS report the template content is not replace with the value in the data source.

Screens shots:

JXLS Template

Data Source

Report Manager

Template Render

Last edited by joedhcs (2020-01-31 20:26:37)

joedhcs

Member

Registered: 2020-01-30

Re: Report Server 3.1 and JXLS 2.x problem

From Jan:

To use JXLS2 Templates on a dynamic list you have to reference - somehow - the data of the dynamic list. This is done via the predefined names data and row. In your example:

jx:area(lastCell="F4")

jx:each(items="data" var="row" lastCell="F4")

jalbrecht

Administrator

Registered: 2016-10-21

Re: Report Server 3.1 and JXLS 2.x problem

thank you joedhcs !
jan