#1 2021-10-01 09:11:36

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 ?

Offline

#2 2021-10-06 09:21:14

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

Offline

#3 2021-10-11 08:29:25

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

Offline

Board footer

Powered by FluxBB