First Step to publish a report

0

Hello!

I install the Server and on my PC the iReport 5.5

I generate a report (with 4 subreports) and so I have 5 Files.

 

How can I now publish/upload this Masterreport (with all Subreports) to the server?

 

When I log in, I can upload a report. But how I have to handle the subreport? May someone has a good tutorial?

 

What I want:

Create reports (where they get data´s from MSSQL and MYSQL) and publish this to a webserver. where User can read and download anytime actual reports.

 

Thank you!

fohnbit's picture
13
Joined: Nov 11 2011 - 4:20am
Last seen: 5 years 4 months ago

2 Answers:

1

When you add subreport to report you able choose other datasource as in main report. So for subreport you able specify other datasource.

About report parameters: you need create input control with same name as your parameter in Controls & Resources page.

 

 

ybablyuk's picture
128
Joined: Oct 17 2012 - 12:51am
Last seen: 10 months 1 week ago

Hello!

I was able now for the one subreport, who connect to MYSQL:
Connection Expression:
"java.sql.DriverManager.getConnection("jdbc:mysql://localhost/jasperserver", "username", "password")".

fohnbit - 5 years 5 months ago
1

Hello You can do it in two way:

1. Add JRXML to report from Ireport

2. From jasperreport server

  • create report and upload main jrxml
  • open tab "Controls & Resources"
  • Click "Add Resource…" link 

My proposition: you can use Jaspersoft Studio, from this report designer you can publish your report with all subreports in one click

 

ybablyuk's picture
128
Joined: Oct 17 2012 - 12:51am
Last seen: 10 months 1 week ago

Hello! Thank you! I Upload now within iReports to the JasperServer. Now the next problem. I have one MSSQL and one MYSQL Database Connection in the subreport.
After upload I add a Datasource at the server. But I can only one!
How can I work with 2 databases? Before I upload to the server, local it run.

fohnbit - 5 years 5 months ago

I forgot: I also add in the report a parameter. How ask this at the webserver?

fohnbit - 5 years 5 months ago
Feedback