How to deploy a report to JasperServer with JSON file as Datasource

Hello Everyone,

I am trying to generate a report using json file as datasource.

I have successfully created the report and able to see the report with values from json file using iReport.

Now i want to deploy this report to JasperServer.  I know to deploy reports to jasperserver with other data source like with postgresql

but not able to deploy this report to jasperserver with json datasource.

I am using iReport 5.5.0 and Jasperserver 5.5.0.

Please help me.

admin.vizexperts's picture
Joined: Feb 25 2014 - 2:53am
Last seen: 8 years 11 months ago

As a progress i have added a parameter for json file url, which is on remote server.

After that i have deployed this report into jasperreport server without passing any datasource.

Now i am passing the remote json file url to that parameter.

It is showing blank report.

I am trying to make it work like remote xml datasource.

Guys help me to tell where i am doing wrong.

admin.vizexperts - 9 years 1 day ago

2 Answers:

Hi all i have somehow solved the problem.

I have added a property in my jrxml file:

<property name="net.sf.jasperreports.json.source" value="http://localhost:port/jsonfilepath"/>

In which i have passed remote JSON file url.

by this report is working fine.

Now, i want to change/pass this(my json file url) value from webapplication at run time.

can i use a parameter field for this(if yes how), or there is something else what i am missing.

admin.vizexperts's picture
Joined: Feb 25 2014 - 2:53am
Last seen: 8 years 11 months ago

I have tried to use an property expression to no avail.

vote4me - 8 years 8 months ago

Were you able to resolve this?

akothari - 7 years 6 months ago

It works for me after 2 long days looking for what my report was always blank.
Thanks

micael.geiss - 5 years 8 months ago

Hi,

Can you put your jrxml and json dataource file.

Thanks !

 

manulachathurika's picture
Joined: Aug 12 2015 - 9:16pm
Last seen: 6 years 11 months ago
Feedback