ReportServer Forum

unsi_2

Member

Registered: 2020-06-24

birt datasource in jxls report

hi

when i try to use a birt datasource in a jxls report, i dont see where to specify the report, the parameter/dataset and the name.

it is possible to use it somehow?

if not, could you provide an example of how to create a script datasource that uses a jdbc connection?

kind regards

eduardo

Administrator

Registered: 2016-11-01

Website

Re: birt datasource in jxls report

Hi unsi_2,

this is not possible out-of-the-box.

But you can use scripting for this. Script datasources can use any groovy constructs, so you can use groovy sql for this:
https://docs.groovy-lang.org/latest/htm … l/Sql.html
https://groovy-lang.org/databases.html

You can see specific uses of Groovy's Sql in ReportServer here: https://github.com/infofabrik/reportser … /tools/sql

Here you see the datascript documentation:
https://reportserver.net/en/guides/scri … tasources/

Regards,
Eduardo