Jasper Reports from a written query of Java

[Jacky Luk]

private void printSalesReportBtnActionPerformed(ActionEvent evt) throws SQLException {
             
   try {
          InputStream in = 
             getClass().getResourceAsStream("/Reporting/SalesReport.jrxml");
             JasperDesign jd = null;
              String sql = "select * from customers";

             jd = JRXmlLoader.load(in);
             JRDesignQuery newQuery = new JRDesignQuery();
                         
             newQuery.setText(sql);
             jd.setQuery(newQuery);
                         
             JasperReport jr = JasperCompileManager.compileReport(jd);
                        
             JasperPrint jp = JasperFillManager.fillReport(jr, null, db.getConnection());
             JasperViewer.viewReport(jp);
      }
      catch (Exception e)
     {
            e.printStackTrace();
     }

 }

I have simply created an empty report (jrxml) file and put some headers, I am not sure if I need
to put fields into my report. But I guess jasper reports will generate the rest for me.
Here this coding, I just can see the headers without details.
Do you know if I actually have to produce something when I worked on the report.
I don't want to dead set the query in iReport
Thanks
Jack

[K. Tsang]

What's wrong with setting the query inside IReport? In fact weighing maintenance issue, changing the report itself vs changing java code and recompiling and deploying. Which one would you prefer.

Besides having the query in IReport can cater for requirement change such as add in a new field or remove one field, add a summary section or whatever you or the client can think of.

The java side for all report generation is basically the same. The only difference is the number of parameters (from your app) you need to pass into the report if any.

[Jacky Luk]

K. Tsang wrote:What's wrong with setting the query inside IReport? In fact weighing maintenance issue, changing the report itself vs changing java code and recompiling and deploying. Which one would you prefer.

Besides having the query in IReport can cater for requirement change such as add in a new field or remove one field, add a summary section or whatever you or the client can think of.

The java side for all report generation is basically the same. The only difference is the number of parameters (from your app) you need to pass into the report if any.

Actually I would like to run some queries like this, so that the customerID would be different each time
the parameter is fed into iReport.
String sql = "select * from customers where customers.CustomerID = " + customerID;

[Jacky Luk]

Hello K Tsang,
I managed to get it work now.
But the problem is the render of text in Simplified/Traditional Chinese.
When I save the report to a pdf, the Chinese characters are gone.
The English words are okay.
https://coderanch.com/t/63485/open-source/Referencing-image-Jasper-Report

I had another issue, when I placed my report image in the same folder as the jrxml, there is error saying
Byte data not found at : ICJB.png

Thanks
Jack

[Maneesh Godbole]

Sounds like a font issue.
Check out http://mdahlman.wordpress.com/2010/05/28/jaspersoft-v3-7-font-extensions/

[Jacky Luk]

Maneesh Godbole wrote:Sounds like a font issue.
Check out http://mdahlman.wordpress.com/2010/05/28/jaspersoft-v3-7-font-extensions/

I want to know another thing, is that how do you set the $V{REPORT_NAME}
once I put into the report, also like labels with name like "G1Label"

http://www.youtube.com/watch?v=-UJylgZHLK4
Thanks
Jack