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!
2 Answers:
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
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.
I forgot: I also add in the report a parameter. How ask this at the webserver?
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")".