JasperDesign jd=JRXmlLoader.load("src\steplizerelectronics\printBillReport.jrxml");
        String sql="SELECT *from sale where sale.cus_id='"+search1.getText()+"'";
        JRDesignQuery desginquery=new JRDesignQuery();
        desginquery.setText(sql);
        jd.setQuery(desginquery);

        JasperReport jr = JasperCompileManager.compileReport(jd);
        JasperPrint jp = JasperFillManager.fillReport(jr, null, con);
        JasperViewer jv=new JasperViewer(jp);
        JasperViewer.viewReport(jp,false);



    } catch (JRException ex) {
       JOptionPane.showMessageDialog(null, ex.getMessage());
       System.out.println(ex.getMessage());
    }