Databases
StackOverflow2013
Postsdbo
POiReport subreports
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POiReport subreports
    primarykey
    data
    text
    <p>I'm not sure what thread to put this in, please direct me to the correct one if this one isn't it.</p> <p>I'm struggling with a sub report in iReport. </p> <p>I have a report that selects from a MSSQL database, and uses a sub report to do a select from a MySQL database. I've successfully done it the other way around (report selects from MySQL, sub report selects from MSSQL), but doing it this way around has me stumped.</p> <p>This is how I'm doing it currently: Main report (just the sub report tags, let me know if I need to post more info about the main report. I replaced some of the variables, my work requires me to):</p> <pre class="lang-xml prettyprint-override"><code>&lt;subreport&gt; &lt;reportElement x="360" y="0" width="100" height="20"/&gt; &lt;subreportParameter name="ID"&gt; &lt;subreportParameterExpression&gt;&lt;![CDATA[$F{pkiCandidateID}]]&gt;&lt;/subreportParameterExpression&gt; &lt;/subreportParameter&gt; &lt;connectionExpression&gt;&lt;![CDATA[java.sql.DriverManager.getConnection("jdbc:mysql://&lt;ip address&gt;:3306/&lt;db name&gt;","&lt;username&gt;","&lt;password&gt;")]]&gt;&lt;/connectionExpression&gt; &lt;subreportExpression class="java.lang.String"&gt;&lt;![CDATA["repo:/Enterprise/jrxml/Candidates/report1_subreport1.jrxml"]]&gt;&lt;/subreportExpression&gt; &lt;/subreport&gt; </code></pre> <p>The error I am receiving:</p> <pre><code>Error filling print...  Error executing SQL statement for : report1_subreport1 net.sf.jasperreports.engine.JRException:  Error executing SQL statement for : report1_subreport1     at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:143)     at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:684)     at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605)     at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:901)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)     at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:877)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'tCandidate'.     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)     at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)     at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:137)     ... 11 more Print not filled. Try to use an EmptyDataSource... </code></pre> <p>Please let me know if I need to give any more information, and please, if you know what I'm doing wrong, help me out. This has stumped me for 2 days now.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBoltClock
    1. USSkytiger
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POiReport subreports
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POiReport subreports
      1. USAlex K
      1. VTFavorite
    3. VO
      singulars
      1. POiReport subreports
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COPlease, post the subreport's snippet
      singulars
      1. POiReport subreports
      1. USAlex K
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload