Advertisement
Guest User

Untitled

a guest
Aug 25th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.48 KB | None | 0 0
  1. ColumnGroupBuilder groupSub;
  2. groupSub = grp.group(colObraSub).groupByDataType();
  3. ColumnGroupBuilder groupBanco;
  4. groupBanco = grp.group(banco).groupByDataType();
  5. ColumnGroupBuilder groupSubSub;
  6. groupSubSub = grp.group(colSubSub).groupByDataType();
  7.  
  8. AggregationSubtotalBuilder<BigDecimal> totalSumSub;
  9. totalSumSub = sbt.sum(colTotal).setHeight(45);
  10. report
  11. .setTemplate(Templates.reportTemplate)
  12. .title(cmp.text("Parcelas - Banco ").setStyle(Templates.bold9CenteredStyle))
  13. .columns(
  14. colObraSub.setStyle(Templates.shortCenteredStyle).setWidth(90).setHorizontalAlignment(HorizontalAlignment.LEFT),
  15. colSubSub.setStyle(Templates.shortCenteredStyle).setWidth(90).setHorizontalAlignment(HorizontalAlignment.LEFT),
  16. banco.setStyle(Templates.shortCenteredStyle).setWidth(90).setHorizontalAlignment(HorizontalAlignment.LEFT),
  17. col.column("Fornecedor", "fornecedor", type.stringType()).setStyle(Templates.shortCenteredStyle).setHorizontalAlignment(HorizontalAlignment.LEFT),
  18. col.column("NΒΊ OC", "numero", type.stringType()).setStyle(Templates.shortCenteredStyle).setWidth(25).setHorizontalAlignment(HorizontalAlignment.CENTER),
  19. col.column("B", "banco", type.stringType()).setStyle(Templates.shortCenteredStyle).setWidth(20).setHorizontalAlignment(HorizontalAlignment.CENTER),
  20. col.column("C", "corretiva", type.stringType()).setStyle(Templates.shortCenteredStyle).setWidth(20).setHorizontalAlignment(HorizontalAlignment.CENTER),
  21. col.column("NF", "nf", type.stringType()).setStyle(Templates.shortCenteredStyle).setWidth(30).setHorizontalAlignment(HorizontalAlignment.CENTER),
  22. col.column("Parc", "parcela", type.stringType()).setStyle(Templates.shortCenteredStyle).setWidth(30).setHorizontalAlignment(HorizontalAlignment.CENTER),
  23. col.column("Acumulado", "acumulado", type.stringType()).setStyle(Templates.shortCenteredStyle).setWidth(45).setHorizontalAlignment(HorizontalAlignment.RIGHT),
  24. colTotal.setStyle(Templates.shortCenteredStyle).setWidth(60).setHorizontalAlignment(HorizontalAlignment.RIGHT)
  25.  
  26. )
  27.  
  28. .groupBy(groupSub)
  29. .groupBy(groupSubSub)
  30. .groupBy(groupBanco)
  31. .subtotalsAtGroupFooter(groupBanco, totalSumSub)
  32.  
  33. .setDataSource(createSubreportDataSourceParcelas());
  34. return report;
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement