ReportServer Forum

Stéphane

Member

Registered: 2020-09-30

jasper and script datasource

Hello,
I am using a script datasource.
In a dynamiclist report I am using the query "select * from $! {_ RS_TMP_TABLENAME}" and it works fine.
I wanted to do the same with a Jasper report. So I put this request in the jrxml but it doesn't work. I get an error message for the SQL when using in reportserver.
Can someone help me ?

Tobias F

Administrator

Registered: 2020-02-07

Re: jasper and script datasource

Hi Stéphane,

could you tell me, which Reportserver version you are using? Because in Reportserver 3.7.0 we added some jasper libraries, which maybe could solve your problem.

You could look it up here
https://forum.reportserver.net/viewtopic.php?id=2779
and maybe also find some help here
https://reportserver.net/en/guides/admi … arameters/

Keep me posted, if that works.

Regards,
Tobias

eduardo

Administrator

Registered: 2016-11-01

Website

Re: jasper and script datasource

Hi Stéphane,

pls take a look here:
https://reportserver.net/en/guides/scri … tasources/

6.1.1. Using Script Datasources with Jasper Reports

you can try with:

select * from  $P!{_RS_TMP_TABLENAME}

if this does not work, pls post the complete error stack you get.

Regards,
Eduardo

Stéphane

Member

Registered: 2020-09-30

Re: jasper and script datasource

Hello eduardo,
I used 6.1.1 and it's OK
Thanks