Java MasterReport.setDataFactory方法代码示例

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
protected MasterReport createCrosstabReport(final TableModel tableModel) {
  final MasterReport report = new MasterReport();
  report.setPageDefinition(new SimplePageDefinition(PageSize.A3, PageFormat.LANDSCAPE, new Insets(0, 0, 0, 0)));
  report.setDataFactory(new TableDataFactory("query", tableModel));
  report.setQuery("query");
  final DesignTimeDataSchemaModel dataSchemaModel = new DesignTimeDataSchemaModel(report);

  AggregationFunction dummy = createAggregateFunction("dummy", null, null);
  if (dummy == null) {
    return null;
  }

  final CrosstabBuilder builder = new CrosstabBuilder(dataSchemaModel);
  builder.addRowDimension(ROW_DIMENSION_A);
  builder.addRowDimension(ROW_DIMENSION_B);
  builder.addColumnDimension(COLUMN_DIMENSION_A);
  builder.addColumnDimension(COLUMN_DIMENSION_B);
  builder.addDetails(VALUE, dummy.getClass());
  report.setRootGroup(builder.create());
  return report;
}
 

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
protected MasterReport createRelationalReport(final TableModel tableModel,
                                              final String... additionalFields) {
  final MasterReport report = new MasterReport();
  report.setPageDefinition(new SimplePageDefinition(PageSize.A3, PageFormat.LANDSCAPE, new Insets(0, 0, 0, 0)));
  report.setDataFactory(new TableDataFactory("query", tableModel));
  report.setQuery("query");
  final DesignTimeDataSchemaModel dataSchemaModel = new DesignTimeDataSchemaModel(report);

  final RelationalReportBuilder builder = new RelationalReportBuilder(dataSchemaModel);
  builder.addGroup(ROW_DIMENSION_A);
  builder.addGroup(ROW_DIMENSION_B);
  builder.addGroup(COLUMN_DIMENSION_A);
  builder.addGroup(COLUMN_DIMENSION_B);
  builder.addDetails(VALUE, null, Color.lightGray);
  builder.addDetails("relational", null, Color.yellow);
  for (int i = 0; i < additionalFields.length; i++) {
    String additionalField = additionalFields[i];
    builder.addDetails(additionalField, null, null);
  }

  report.setRootGroup(builder.create());
  return report;
}
 

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
private MasterReport configureReport() {
  PlainParameter plainParam = new PlainParameter("text-parameter", String.class);
  plainParam.setDefaultValue("Hello World!");

  DefaultListParameter listParam = new DefaultListParameter
          ("param-query", "key", "value", "list-param", true, false, String.class);
  listParam.setDefaultValue(new String[]{"One", "Two", "Three"});

  DefaultParameterDefinition params = new DefaultParameterDefinition();
  params.addParameterDefinition(plainParam);
  params.addParameterDefinition(listParam);

  TypedTableModel model = new TypedTableModel();
  model.addColumn("key", String.class);
  model.addColumn("value", String.class);
  model.addRow("One", "First Row");
  model.addRow("Two", "Second Row");
  model.addRow("Three", "Third Row");
  model.addRow("Four", "Fourth Row");

  TableDataFactory dataFactory = new TableDataFactory();
  dataFactory.addTable("param-query", model);

  MasterReport report = new MasterReport();
  report.setDataFactory(dataFactory);
  report.getPageFooter().addElement(TableTestUtil.createDataItem("Dummy Item"));
  report.setParameterDefinition(params);
  return report;
}
 

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
@Override
public void doPost(
  HttpServletRequest request, 
  HttpServletResponse response)
  throws ServletException, IOException 
{

  try {

    // Declaring a report.
    MasterReport report = new MasterReport();

    // Loading the Table DataFactory.
    DefaultTableModel tableModel = new DefaultTableModel(
      new Object[][] {
        {"Product A", 123},
        {"Product B", 234},
        {"Product C", 345},
        {"Product D", 456}
      },
  	new String[] {"Product", "Cost"});
    TableDataFactory dataFactory = new TableDataFactory();
    dataFactory.addTable("default", tableModel);
    report.setDataFactory(dataFactory);

    // Getting the item band to host the elements.
    ItemBand itemBand = report.getItemBand();

    // Adding a text field for the product name, added to the item band.
    TextFieldElementFactory textFactory = new TextFieldElementFactory(); 
    textFactory.setFieldname("Product");
    textFactory.setX(1f);
    textFactory.setY(1f); 
    textFactory.setMinimumWidth(200f);
    textFactory.setMinimumHeight(20f);
    Element nameField = textFactory.createElement(); 
    itemBand.addElement(nameField);

    // Adding a number filed with the total cost of the products.
    NumberFieldElementFactory numberFactory = new NumberFieldElementFactory();
    numberFactory.setFieldname("Cost");
    numberFactory.setX(201f);
    numberFactory.setY(1f);
    numberFactory.setMinimumWidth(100f);
    numberFactory.setMinimumHeight(20f);
    Element totalCost = numberFactory.createElement();
    itemBand.addElement(totalCost);

    // Conversion to PDF and rendering.
    response.setContentType("application/pdf");
    PdfReportUtil.createPDF(report, response.getOutputStream());

  }
  catch (Exception e) 
  {
      e.printStackTrace();
  }
}
 

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
@Override
public void doPost(
  HttpServletRequest request, 
  HttpServletResponse response)
  throws ServletException, IOException 
{

  try {

    // Declaring a report.
    MasterReport report = new MasterReport();

    // Loading OLAP data.
    DriverConnectionProvider provider = new DriverConnectionProvider();
    provider.setDriver("mondrian.olap4j.MondrianOlap4jDriver");
    provider.setUrl("jdbc:mondrian: ");
    provider.setProperty("Catalog", "./resources/steelwheels.mondrian.xml");
    provider.setProperty("JdbcUser", "pentaho_user");
    provider.setProperty("JdbcPassword", "password");
    provider.setProperty("Jdbc", "jdbc:hsqldb:./resources/sampledata/sampledata");
    provider.setProperty("JdbcDrivers", "org.hsqldb.jdbcDriver");

    // Creating the factory.
    BandedMDXDataFactory factory = new BandedMDXDataFactory(provider);
    factory.setQuery("default", "SELECT {[Measures].[Sales]} ON COLUMNS, {Descendants([Time].Children, [Time].[Months])} ON ROWS FROM [SteelWheelsSales]");
    report.setDataFactory(factory);

    // Getting the item band to host the elements.
    ItemBand itemBand = report.getItemBand();

    // Adding a text field for the product name, added to the item band.
    TextFieldElementFactory textFactory = new TextFieldElementFactory(); 
    textFactory.setFieldname("[Time].[Months]");
    textFactory.setX(1f);
    textFactory.setY(1f); 
    textFactory.setMinimumWidth(200f);
    textFactory.setMinimumHeight(20f);
    Element nameField = textFactory.createElement(); 
    itemBand.addElement(nameField);

    // Adding a number filed with the total cost of the products.
    NumberFieldElementFactory numberFactory = new NumberFieldElementFactory();
    numberFactory.setFieldname("[Measures].[Sales]");
    numberFactory.setX(201f);
    numberFactory.setY(1f);
    numberFactory.setMinimumWidth(100f);
    numberFactory.setMinimumHeight(20f);
    Element totalCost = numberFactory.createElement();
    itemBand.addElement(totalCost);

    // Conversion to PDF and rendering.
    response.setContentType("application/pdf");
    PdfReportUtil.createPDF(report, response.getOutputStream());

  }
  catch (Exception e) 
  {
      e.printStackTrace();
  }
}
 

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
@Override
public void doPost(
  HttpServletRequest request, 
  HttpServletResponse response)
  throws ServletException, IOException 
{

  try {

    // Declaring a report.
    MasterReport report = new MasterReport();

    // Load report xpath data.
    XPathDataFactory factory = new XPathDataFactory();
    factory.setXqueryDataFile("file:./resources/xpathexample.xml");
    factory.setQuery("default", "/ExampleResultSet/Row", false);
    report.setDataFactory(factory);

    // Getting the item band to host the elements.
    ItemBand itemBand = report.getItemBand();

    // Adding a text field for the product name, added to the item band.
    TextFieldElementFactory textFactory = new TextFieldElementFactory(); 
    textFactory.setFieldname("NAME");
    textFactory.setX(1f);
    textFactory.setY(1f); 
    textFactory.setMinimumWidth(200f);
    textFactory.setMinimumHeight(20f);
    Element nameField = textFactory.createElement(); 
    itemBand.addElement(nameField);

    // Adding a number filed with the total cost of the products.
    NumberFieldElementFactory numberFactory = new NumberFieldElementFactory();
    numberFactory.setFieldname("SIZE");
    numberFactory.setX(201f);
    numberFactory.setY(1f);
    numberFactory.setMinimumWidth(100f);
    numberFactory.setMinimumHeight(20f);
    Element totalCost = numberFactory.createElement();
    itemBand.addElement(totalCost);

    // Conversion to PDF and rendering.
    response.setContentType("application/pdf");
    PdfReportUtil.createPDF(report, response.getOutputStream());

  }
  catch (Exception e) 
  {
      e.printStackTrace();
  }
}
 

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
@Override
public void doPost(
  HttpServletRequest request, 
  HttpServletResponse response)
  throws ServletException, IOException 
{

  try {

    // Declaring a report.
    MasterReport report = new MasterReport();

    // Loading MQL data source.
    PmdDataFactory factory = new PmdDataFactory();
    factory.setConnectionProvider(new PmdConnectionProvider());
    factory.setXmiFile("resources/metadata.xmi");
    factory.setDomainId("test");
    factory.setQuery(
      "default",
      "<?xml version='1.0' encoding='UTF-8'?>" + 
      "<mql>" + 
        "<domain_id>test</domain_id>" + 
        "<model_id>BV_ORDERS</model_id>" + 
        "<options>" + 
          "<disable_distinct>false</disable_distinct>" + 
          "<limit>-1</limit>" + 
        "</options>" + 
        "<selections>" + 
          "<selection>" + 
            "<view>CAT_PRODUCTS</view>" + 
            "<column>BC_PRODUCTS_PRODUCTNAME</column>" + 
            "<aggregation>NONE</aggregation>" + 
          "</selection>" + 
          "<selection>" + 
            "<view>CAT_PRODUCTS</view>" + 
            "<column>BC_PRODUCTS_MSRP</column>" + 
            "<aggregation>AVERAGE</aggregation>" + 
          "</selection>" + 
        "</selections>" + 
        "<constraints/>" + 
        "<orders/>" + 
      "</mql>",
      null,
      null);

    report.setDataFactory(factory);

    // Getting the item band to host the elements.
    ItemBand itemBand = report.getItemBand();

    // Adding a text field for the product name, added to the item band.
    TextFieldElementFactory textFactory = new TextFieldElementFactory(); 
    textFactory.setFieldname("BC_PRODUCTS_PRODUCTNAME");
    textFactory.setX(1f);
    textFactory.setY(1f); 
    textFactory.setMinimumWidth(200f);
    textFactory.setMinimumHeight(20f);
    Element nameField = textFactory.createElement(); 
    itemBand.addElement(nameField);

    // Adding a number filed with the total cost of the products.
    NumberFieldElementFactory numberFactory = new NumberFieldElementFactory();
    numberFactory.setFieldname("BC_PRODUCTS_MSRP");
    numberFactory.setX(201f);
    numberFactory.setY(1f);
    numberFactory.setMinimumWidth(100f);
    numberFactory.setMinimumHeight(20f);
    Element totalCost = numberFactory.createElement();
    itemBand.addElement(totalCost);

    // Conversion to PDF and rendering.
    response.setContentType("application/pdf");
    PdfReportUtil.createPDF(report, response.getOutputStream());

  }
  catch (Exception e) 
  {
      e.printStackTrace();
  }
}
 

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
@Override
public void doPost(
  HttpServletRequest request, 
  HttpServletResponse response)
  throws ServletException, IOException 
{

  try {

    // Declaring a report.
    MasterReport report = new MasterReport();

    // Data source provider.
    DriverDataSourceProvider dsProvider = new DriverDataSourceProvider();
    dsProvider.setDriver("org.hsqldb.jdbcDriver");
    dsProvider.setProperty("user", "pentaho_user");
    dsProvider.setProperty("password", "password");
    dsProvider.setUrl("jdbc:hsqldb:./resources/sampledata/sampledata");

    // Mondrian cube provider.
    DefaultCubeFileProvider cubeProvider = new DefaultCubeFileProvider();
    cubeProvider.setMondrianCubeFile("./resources/steelwheels.mondrian.xml");

    // Loading Mondrian data source.
    BandedMDXDataFactory factory = new BandedMDXDataFactory();
    factory.setDataSourceProvider(dsProvider);
    factory.setCubeFileProvider(cubeProvider);
    factory.setQuery("default", "SELECT {[Measures].[Sales]} ON COLUMNS, {Descendants([Time].Children, [Time].[Months])} ON ROWS FROM [SteelWheelsSales]");
    report.setDataFactory(factory);

    // Getting the item band to host the elements.
    ItemBand itemBand = report.getItemBand();

    // Adding a text field for the product name, added to the item band.
    TextFieldElementFactory textFactory = new TextFieldElementFactory(); 
    textFactory.setFieldname("[Time].[Months]");
    textFactory.setX(1f);
    textFactory.setY(1f); 
    textFactory.setMinimumWidth(200f);
    textFactory.setMinimumHeight(20f);
    Element nameField = textFactory.createElement(); 
    itemBand.addElement(nameField);

    // Adding a number filed with the total cost of the products.
    NumberFieldElementFactory numberFactory = new NumberFieldElementFactory();
    numberFactory.setFieldname("[Measures].[Sales]");
    numberFactory.setX(201f);
    numberFactory.setY(1f);
    numberFactory.setMinimumWidth(100f);
    numberFactory.setMinimumHeight(20f);
    Element totalCost = numberFactory.createElement();
    itemBand.addElement(totalCost);

    // Conversion to PDF and rendering.
    response.setContentType("application/pdf");
    PdfReportUtil.createPDF(report, response.getOutputStream());

  }
  catch (Exception e) 
  {
      e.printStackTrace();
  }
}
 

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
@Override
public void doPost(
  HttpServletRequest request, 
  HttpServletResponse response)
  throws ServletException, IOException 
{

  try {

    // Declaring a report.
    MasterReport report = new MasterReport();

    // Loading Kettle data source.
    KettleTransFromFileProducer producer = new KettleTransFromFileProducer (
      "resources/CSV Input - Reading customer data.ktr",
      "Dummy (do nothing)",
      new FormulaArgument[0], 
      new FormulaParameter[0]);
    KettleDataFactory factory = new KettleDataFactory();
    factory.setQuery("default", producer);
    report.setDataFactory(factory);

    // Getting the item band to host the elements.
    ItemBand itemBand = report.getItemBand();

    // Adding a text field for the product name, added to the item band.
    TextFieldElementFactory textFactory = new TextFieldElementFactory(); 
    textFactory.setFieldname("name");
    textFactory.setX(1f);
    textFactory.setY(1f); 
    textFactory.setMinimumWidth(200f);
    textFactory.setMinimumHeight(20f);
    Element nameField = textFactory.createElement(); 
    itemBand.addElement(nameField);

    // Adding a number filed with the total cost of the products.
    NumberFieldElementFactory numberFactory = new NumberFieldElementFactory();
    numberFactory.setFieldname("id");
    numberFactory.setX(201f);
    numberFactory.setY(1f);
    numberFactory.setMinimumWidth(100f);
    numberFactory.setMinimumHeight(20f);
    Element totalCost = numberFactory.createElement();
    itemBand.addElement(totalCost);

    // Conversion to PDF and rendering.
    response.setContentType("application/pdf");
    PdfReportUtil.createPDF(report, response.getOutputStream());

  }
  catch (Exception e) 
  {
      e.printStackTrace();
  }
}
 

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
@Override
public void doPost(
  HttpServletRequest request, 
  HttpServletResponse response)
  throws ServletException, IOException 
{

  try {

    // Declaring a report.
    MasterReport report = new MasterReport();

    // Defining the connection provider.
    DriverConnectionProvider provider = new DriverConnectionProvider();
    provider.setDriver("org.hsqldb.jdbcDriver");
    provider.setProperty("user", "pentaho_user");
    provider.setProperty("password", "password");
    provider.setUrl("jdbc:hsqldb:./resources/sampledata/sampledata");

    // Defining the query.
    SQLReportDataFactory dataFactory = new SQLReportDataFactory(provider);
    String sqlQuery = "SELECT PRODUCTNAME, QUANTITYINSTOCK FROM PRODUCTS";
    dataFactory.setQuery("default", sqlQuery);
    report.setDataFactory(dataFactory);

    // Getting the item band to host the elements.
    ItemBand itemBand = report.getItemBand();

    // Adding a text field for the product name, added to the item band.
    TextFieldElementFactory textFactory = new TextFieldElementFactory(); 
    textFactory.setFieldname("PRODUCTNAME");
    textFactory.setX(1f);
    textFactory.setY(1f); 
    textFactory.setMinimumWidth(200f);
    textFactory.setMinimumHeight(20f);
    Element nameField = textFactory.createElement(); 
    itemBand.addElement(nameField);

    // Adding a number filed with the quantity in stock of the products.
    NumberFieldElementFactory numberFactory = new NumberFieldElementFactory();
    numberFactory.setFieldname("QUANTITYINSTOCK");
    numberFactory.setX(201f);
    numberFactory.setY(1f);
    numberFactory.setMinimumWidth(100f);
    numberFactory.setMinimumHeight(20f);
    Element totalCost = numberFactory.createElement();
    itemBand.addElement(totalCost);

    // Conversion to PDF and rendering.
    response.setContentType("application/pdf");
    PdfReportUtil.createPDF(report, response.getOutputStream());

  }
  catch (Exception e) 
  {
      e.printStackTrace();
  }
}
 

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
@Override
public void doPost(
  HttpServletRequest request, 
  HttpServletResponse response)
  throws ServletException, IOException 
{

  try {

    // Declaring a report.
    MasterReport report = new MasterReport();

    // Defining the connection provider.
    Connection connection = DriverManager.getConnection("jdbc:hsqldb:./resources/sampledata/sampledata", "pentaho_user", "password");
    StaticConnectionProvider provider = new StaticConnectionProvider(connection);

    // Defining the query.
    SQLReportDataFactory dataFactory = new SQLReportDataFactory(provider);
    String sqlQuery = "SELECT PRODUCTNAME, QUANTITYINSTOCK FROM PRODUCTS";
    dataFactory.setQuery("default", sqlQuery);
    report.setDataFactory(dataFactory);

    // Getting the item band to host the elements.
    ItemBand itemBand = report.getItemBand();

    // Adding a text field for the product name, added to the item band.
    TextFieldElementFactory textFactory = new TextFieldElementFactory(); 
    textFactory.setFieldname("PRODUCTNAME");
    textFactory.setX(1f);
    textFactory.setY(1f); 
    textFactory.setMinimumWidth(200f);
    textFactory.setMinimumHeight(20f);
    Element nameField = textFactory.createElement(); 
    itemBand.addElement(nameField);

    // Adding a number filed with the total cost of the products.
    NumberFieldElementFactory numberFactory = new NumberFieldElementFactory();
    numberFactory.setFieldname("QUANTITYINSTOCK");
    numberFactory.setX(201f);
    numberFactory.setY(1f);
    numberFactory.setMinimumWidth(100f);
    numberFactory.setMinimumHeight(20f);
    Element totalCost = numberFactory.createElement();
    itemBand.addElement(totalCost);

    // Conversion to PDF and rendering.
    response.setContentType("application/pdf");
    PdfReportUtil.createPDF(report, response.getOutputStream());

  }
  catch (Exception e) 
  {
      e.printStackTrace();
  }
}
 

import org.pentaho.reporting.engine.classic.core.MasterReport; //导入方法依赖的package包/类
@Override
public void doPost(
  HttpServletRequest request, 
  HttpServletResponse response)
  throws ServletException, IOException 
{

  try {

    // Declaring a report.
    MasterReport report = new MasterReport();

    // Data source provider.
    DriverDataSourceProvider dsProvider = new DriverDataSourceProvider();
    dsProvider.setDriver("org.hsqldb.jdbcDriver");
    dsProvider.setProperty("user", "pentaho_user");
    dsProvider.setProperty("password", "password");
    dsProvider.setUrl("jdbc:hsqldb:./resources/sampledata/sampledata");

    // Mondrian cube provider.
    DefaultCubeFileProvider cubeProvider = new DefaultCubeFileProvider();
    cubeProvider.setMondrianCubeFile("./resources/steelwheels.mondrian.xml");

    // Loading Mondrian data source.
    BandedMDXDataFactory factory = new BandedMDXDataFactory();
    factory.setDataSourceProvider(dsProvider);
    factory.setCubeFileProvider(cubeProvider);
    factory.setQuery("default", "SELECT CrossJoin([Markets].Children, [Time].Children) ON ROWS, [Measures].[Sales] ON COLUMNS FROM [SteelWheelsSales]");
    report.setDataFactory(factory);

    // Defining the crosstab.
    CrosstabGroup crosstabGroup = new CrosstabGroup(); 

    // Defining the crosstab rows.
    CrosstabRowGroupBody rowBody = (CrosstabRowGroupBody) crosstabGroup.getBody(); 
    CrosstabRowGroup rowGroup = rowBody.getGroup();
    rowGroup.setField( "[Markets].[Territory]" );
    rowGroup.getTitleHeader().addElement( createDataItem( "[Markets].[Territory]" ) ); 
    rowGroup.getHeader().addElement( createFieldItem( "[Markets].[Territory]" ) ); 
 
    // Defining the crosstab columns.
    CrosstabColumnGroupBody columnGroupBody = (CrosstabColumnGroupBody) rowGroup.getBody(); 
    CrosstabColumnGroup columnGroup = columnGroupBody.getGroup(); 
    columnGroup.setField( "[Time].[Years]" ); 
    columnGroup.getTitleHeader().addElement( createDataItem( "[Time].[Years]" ) ); 
    columnGroup.getHeader().addElement( createFieldItem( "[Time].[Years]" ) ); 

    // Defining the crosstab details.
    CrosstabCellBody body = (CrosstabCellBody) columnGroup.getBody(); 
    CrosstabCell cell = new CrosstabCell(); 
    cell.addElement( createFieldItem( "[Measures].[Sales]" ) ); 
    body.addElement( cell );

    report.setRootGroup( crosstabGroup );

    // Conversion to PDF and rendering.
    response.setContentType("application/pdf");
    PdfReportUtil.createPDF(report, response.getOutputStream());

  }
  catch (Exception e) 
  {
      e.printStackTrace();
  }
}