当我选择任何需要按 Jasper 报告中按组打印到第 it_print 列的项目时,我需要Mr_items表格是我需要的名称
item_sn | item_name | it_print
---------------------------------
1 | pepsi | drinks
2 | sandwiches | foods
3 | water | drinks
4 | burger | foods
我尝试通过此代码打印
///print invoice cashier
public void PrintInvoiceSection() throws JRException, IOException {
try {
/////////print///////////////////
HashMap parameters = new HashMap();
parameters.put("nameilll", cashier_name.getText().trim());
parameters.put("datevist", sysdate_invc.getText().trim());
parameters.put("timevist", systime_invc.getText().trim());
parameters.put("invoice_type", InvoiceType.getText());
parameters.put("invoiceno", inv_id);
parameters.put("cus_name", cusName.getText().trim());
parameters.put("cus_mobile", cusMobile.getText().trim());
parameters.put("cus_address", cusAddrss.getText());
parameters.put("inv_remark", customerBehestRemark.getText());
parameters.put("inv_remark", invoiceRemark.getText());
InputStream ul = getClass().getResourceAsStream("/printer/Printsection.jasper");
java.util.Vector collection = new java.util.Vector();
collection = new Vector(itemslist);
JasperPrint jasperPrint = JasperFillManager.fillReport(ul, parameters, new JRBeanCollectionDataSource(collection));
JasperViewer jv = new JasperViewer(jasperPrint, false);
jv.setVisible(false);
PrintReportToPrinterSection(jasperPrint);
} catch (JRException ex) {
Logger.getLogger(SalesinterfaceController.class.getName()).log(Level.SEVERE, null, ex);
}
}
并且此代码也用于选择打印机
private void PrintReportToPrinterSection(JasperPrint jp) throws JRException {
// getSectionPrint();
// TODO Auto-generated method stub
PrintRequestAttributeSet printRequestAttributeSet = new HashPrintRequestAttributeSet();
// printRequestAttributeSet.add(MediaSizeName.ISO_A4); //setting page size
printRequestAttributeSet.add(new Copies(1));
PrinterName printerName = new PrinterName(cashPrint.getText(), null); //gets printer
PrintServiceAttributeSet printServiceAttributeSet = new HashPrintServiceAttributeSet();
printServiceAttributeSet.add(printerName);
JRPrintServiceExporter exporter = new JRPrintServiceExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp);
exporter.setParameter(JRPrintServiceExporterParameter.PRINT_REQUEST_ATTRIBUTE_SET, printRequestAttributeSet);
exporter.setParameter(JRPrintServiceExporterParameter.PRINT_SERVICE_ATTRIBUTE_SET, printServiceAttributeSet);
exporter.setParameter(JRPrintServiceExporterParameter.DISPLAY_PAGE_DIALOG, Boolean.FALSE);
exporter.setParameter(JRPrintServiceExporterParameter.DISPLAY_PRINT_DIALOG, Boolean.FALSE);
exporter.getPrintService();
}
我尝试这种语法
SELECT item_sn, item_name, it_print,
IF($P{consolidate_loc}, concat(itemname, ', ', itemprice, ' ', itemprint ), Mr_items) AS groupField
FROM
GROUP BY groupField;
我不能将其包含在 Jasper 报告中,因为我不知道 Jasper 的领域我是新 bie :)
最后我找到了解决方案
此类用于将表单打印到打印机中
public void PrintReportToPrinterSection(JasperPrint jp, String pp) throws PrinterException {
try{
// TODO Auto-generated method stub
PrintRequestAttributeSet printRequestAttributeSet = new HashPrintRequestAttributeSet();
// printRequestAttributeSet.add(MediaSizeName.ISO_A4); //setting page size
printRequestAttributeSet.add(new Copies(1));
PrinterName printerName = new PrinterName(pp, null); //gets printer
PrintServiceAttributeSet printServiceAttributeSet = new HashPrintServiceAttributeSet();
printServiceAttributeSet.add(printerName);
PrinterJob printerJob = PrinterJob.getPrinterJob();
PrintService[] services = PrintServiceLookup.lookupPrintServices(null, null);
PrintService selectedService = null;
if(services.length != 0 || services != null)
{
for(PrintService service : services){
String existingPrinter = service.getName().toLowerCase();
Object selectedPrinter = pp;
if(existingPrinter.equals(selectedPrinter))
{
selectedService = service;
break;
}
}
if(selectedService != null)
{
printerJob.setPrintService(selectedService);
boolean printSucceed = JasperPrintManager.printReport(pp, false);
}}
JRPrintServiceExporter exporter = new JRPrintServiceExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp);
exporter.setParameter(JRPrintServiceExporterParameter.PRINT_REQUEST_ATTRIBUTE_SET, printRequestAttributeSet);
exporter.setParameter(JRPrintServiceExporterParameter.PRINT_SERVICE_ATTRIBUTE_SET, printServiceAttributeSet);
exporter.setParameter(JRPrintServiceExporterParameter.DISPLAY_PAGE_DIALOG, Boolean.FALSE);
exporter.setParameter(JRPrintServiceExporterParameter.DISPLAY_PRINT_DIALOG, Boolean.FALSE);
exporter.exportReport();
} catch (JRException e) {
System.out.println(e);
}
}
打印部分打印机表单
然后我将类调用到打印部分表单类中然后我做 while 循环以按打印机名称分组逐行获取每一行
public void PrintInvoiceSection() throws JRException, SQLException, PrinterException {
try {
String sql2 = "select pr_id as printId, pr_printer as printName from invoices_items where tr_inv_no='" + inv_id + "' Group BY pr_id";
rs = con.createStatement().executeQuery(sql2);
while (rs.next()) {
int prind = rs.getInt("printId");
String prnam = rs.getString("printName");
JasperDesign jasperdesign = JRXmlLoader.load("C:\Users\Wael\Documents\NetBeansProjects\resrr\resturnopos\src\printer\Printsection.jrxml");
String sql = "SELECT resturno.mr_printsection.pr_section,n" +
" resturno.invoices_items.tr_it_name,n" +
" resturno.invoices_items.tr_date,n" +
" resturno.invoices_items.tr_inv_issued,n" +
" resturno.invoices_items.tr_it_price,n" +
" resturno.invoices_items.tr_vat,n" +
" resturno.invoices_items.tr_it_qty,n" +
" resturno.invoices_items.tr_it_tot,n" +
" resturno.invoices_items.tr_inv_no,n" +
" resturno.mr_invoicetyp.inv_name1,n" +
" resturno.invoices_items.inv_typ_id,n" +
" resturno.invoices_items.tr_it_name,n" +
" resturno.invoices_items.tr_it_price,n" +
" resturno.invoices_items.tr_vat,n" +
" resturno.invoices_items.tr_it_tot,n" +
" resturno.invoices_items.tr_it_qty,n" +
" resturno.mr_invoicetyp.inv_name1,n" +
" resturno.mr_invoicetyp.inv_name2,n" +
" resturno.mr_printsection.pr_section,n" +
" resturno.invoices_items.pr_id,n" +
" resturno.invoices_items.pr_printern" +
"FROM resturno.invoices_itemsn" +
" INNER JOIN resturno.mr_invoicetyp ON n" +
" resturno.mr_invoicetyp.inv_typ_id = resturno.invoices_items.inv_typ_id n" +
" INNER JOIN resturno.mr_printsection ON n" +
" resturno.mr_printsection.pr_id = resturno.invoices_items.pr_id n" +
"WHERE n"
+ " resturno.invoices_items.tr_inv_no = '" + inv_id + "' n"
+ " AND resturno.invoices_items.pr_id = '" + prind + "'"
+ " AND resturno.invoices_items.pr_printer = '" + prnam + "'";
JRDesignQuery jrq = new JRDesignQuery();
jrq.setText(sql);
jasperdesign.setQuery(jrq);
JasperReport jsp = JasperCompileManager.compileReport(jasperdesign);
JasperPrint jasperPrint = JasperFillManager.fillReport(jsp, new HashMap(), con);
// List jpList = new ArrayList();
// jpList.add(j.loadObjectFromFile("build/reports/Report1.jrprint"));
JasperViewer jv = new JasperViewer(jasperPrint, false);
jv.setVisible(true);
PrintReportToPrinterSection(jasperPrint, prnam);
}
} catch (JRException ex) {
System.out.println(ex);
}
}