fohnbit Posted March 26, 2014 Share Posted March 26, 2014 Hello!I install the Server and on my PC the iReport 5.5I 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! Link to comment Share on other sites More sharing options...
ybablyuk Posted March 26, 2014 Share Posted March 26, 2014 Hello You can do it in two way:1. Add JRXML to report from Ireport2. From jasperreport servercreate report and upload main jrxmlopen 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 Link to comment Share on other sites More sharing options...
fohnbit Posted March 26, 2014 Author Share Posted March 26, 2014 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. Link to comment Share on other sites More sharing options...
fohnbit Posted March 26, 2014 Author Share Posted March 26, 2014 I forgot: I also add in the report a parameter. How ask this at the webserver? Link to comment Share on other sites More sharing options...
Solution ybablyuk Posted March 26, 2014 Solution Share Posted March 26, 2014 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. Link to comment Share on other sites More sharing options...
fohnbit Posted March 26, 2014 Author Share Posted March 26, 2014 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")". Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now