title: Generate report with specific date
body: <p>I'm generate report using <em>iReport 4.7.0</em></p>
  
  <p>I want to generate the report by searching between 2 day,Example : from when to when. </p>
  
  <p>And this is my code:</p>
  
  <pre><code>java.util.Date utilStartDate = date1.getDate();
  java.sql.Date start = new java.sql.Date(utilStartDate.getTime());
  
  java.util.Date utilStartDate2 = date2.getDate();
  java.sql.Date end = new java.sql.Date(utilStartDate2.getTime());
  
  try {
      JasperDesign jd = JRXmlLoader.load("C:\\Users\\admin\\Desktop\\Sales Report.jrxml");
      String sql = "Select * from Order1 Where Order_Date between "+start+" and "+end+"";
  
      JRDesignQuery newQuery = new JRDesignQuery();
      newQuery.setText(sql);
      jd.setQuery(newQuery);
      JasperReport jr = JasperCompileManager.compileReport(jd);
      JasperPrint jp = JasperFillManager.fillReport(jr,null,conn);
      JasperViewer.viewReport(jp,false);
  } catch(Exception e) {
      JOptionPane.showMessageDialog(null,e.getMessage());
  </code></pre>
  
  <p>I have error say that the document have no pages.</p>
  
  <p>This is my first time doing this because previously I just generate the report without specific something. </p>
  
  <p>Any could help? </p>