try {
        JasperDesign jasperDesigner = JRXmlLoader.load("G:\AssessmentRecordSystem\src\assessmentrecordsystem\reports\report1.jrxml");
        String sql = "SELECT ... FROM ... WHERE";
        JRDesignQuery jrDesignQuery = new JRDesignQuery();
        jrDesignQuery.setText(sql);
        jasperDesigner.setQuery(jrDesignQuery);
        JasperReport rep = JasperCompileManager.compileReport(jasperDesigner);
        JasperPrint print = JasperFillManager.fillReport(rep, null, connect);
        JasperViewer.viewReport(print);
    }  catch (JRException ex) {
        JOptionPane.showMessageDialog(null, ex.getMessage());
    }