> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/pdia-admin/9.3-administer/embed-and-extend-pentaho-functionality-cp/embed-reporting-functionality/advanced-topics/sample-3-dynamically-generated-jdbc-input-swing-output.md). # Sample 3: Dynamically generated, JDBC input, swing output `Sample3.java` generates the same report as created in `Sample1.java` (using the PRPT file generated with Report Designer, connecting to the file-based HSQLDB database, and using a few parameters), but it uses a Swing helper class defined in the Pentaho Reporting engine to render the report in a Swing preview window. This basic functionality allows for: * Runtime dynamic changing of report input parameters (in the Swing window, changes to the parameters can be submitted by clicking on the **Update** button) * Pagination of the report (showing one page at a time) * Exporting the report in different formats (PDF, HTML, XLS, etc.) The details of how to use Swing to preview the report are contained in the following engine classes (see the source files included with the SDK for more information): * org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewDialog: The dialog window that contains the preview pane and handles basic menu functionality * **org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane**: The pane that handles the report generation, page switching, printing, and report export functionality ``` /* * This program is free software; you can redistribute it and/or modify it under the * terms of the GNU Lesser General Public License, version 2.1 as published by the Free Software * Foundation. * * You should have received a copy of the GNU Lesser General Public License along with this * program; if not, you can obtain a copy at http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html * or from the Free Software Foundation, Inc., * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. * * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. * See the GNU Lesser General Public License for more details. * * Copyright 2009 Pentaho Corporation. All rights reserved. * * Created July 22, 2009 * @author dkincade */ package org.pentaho.reporting.engine.classic.samples; import java.net.URL; import java.util.HashMap; import java.util.Map; import org.pentaho.reporting.engine.classic.core.ClassicEngineBoot; import org.pentaho.reporting.engine.classic.core.DataFactory; import org.pentaho.reporting.engine.classic.core.MasterReport; import org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewDialog; import org.pentaho.reporting.libraries.resourceloader.Resource; import org.pentaho.reporting.libraries.resourceloader.ResourceException; import org.pentaho.reporting.libraries.resourceloader.ResourceManager; /** * Generates a report using a paginated Swing Preview Dialog. The parameters for this report * can be modified while previewing the dialog and the changes can be seen instantly. *

* The report generated in this scenario will be the same as created in Sample1: *

    *
  1. The report definition file is a .prpt file which will be loaded and parsed *
  2. The data factory is a simple JDBC data factory using HSQLDB *
  3. There are no runtime report parameters used *
*/ public class Sample3 { /** * @param args */ public static void main(String[] args) { // initialize the Reporting Engine ClassicEngineBoot.getInstance().start(); // Get the complete report definition (the report definition with the data factory and // parameters already applied) Sample3 sample = new Sample3(); final MasterReport report = sample.getCompleteReportDefinition(); // Generate the swing preview dialog final PreviewDialog dialog = new PreviewDialog(); dialog.setReportJob(report); dialog.setSize(500, 500); dialog.setModal(true); dialog.setVisible(true); System.exit(0); } /** * Generates the report definition that has the data factory and * parameters already applied. * @return the completed report definition */ public MasterReport getCompleteReportDefinition() { final MasterReport report = getReportDefinition(); // Add any parameters to the report final Map reportParameters = getReportParameters(); if (null != reportParameters) { for (String key : reportParameters.keySet()) { report.getParameterValues().put(key, reportParameters.get(key)); } } // Set the data factory for the report final DataFactory dataFactory = getDataFactory(); if (dataFactory != null) { report.setDataFactory(dataFactory); } // Return the completed report return report; } /** * Returns the report definition which will be used to generate the report. In this case, the report will be * loaded and parsed from a file contained in this package. * * @return the loaded and parsed report definition to be used in report generation. */ private MasterReport getReportDefinition() { try { // Using the classloader, get the URL to the reportDefinition file // NOTE: We will re-use the report definition from SAMPLE1 final ClassLoader classloader = this.getClass().getClassLoader(); final URL reportDefinitionURL = classloader .getResource("org/pentaho/reporting/engine/classic/samples/Sample1.prpt"); // Parse the report file final ResourceManager resourceManager = new ResourceManager(); resourceManager.registerDefaults(); final Resource directly = resourceManager.createDirectly(reportDefinitionURL, MasterReport.class); return (MasterReport) directly.getResource(); } catch (ResourceException e) { e.printStackTrace(); } return null; } /** * Returns the set of runtime report parameters. This sample report uses the following three parameters: * * * @return null indicating the report generator does not use any report parameters */ private Map getReportParameters() { final Map parameters = new HashMap(); parameters.put("Report Title", "Simple Embedded Report Example with Parameters"); parameters.put("Col Headers BG Color", "yellow"); parameters.put("Customer Names", new String[] { "American Souvenirs Inc", "Toys4GrownUps.com", "giftsbymail.co.uk", "BG&E Collectables", "Classic Gift Ideas, Inc", }); return parameters; } /** * Returns the data factory which will be used to generate the data used during report generation. In this example, * we will return null since the data factory has been defined in the report definition. * * @return the data factory used with the report generator */ private DataFactory getDataFactory() { return null; } } ``` --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.pentaho.com/pdia-admin/9.3-administer/embed-and-extend-pentaho-functionality-cp/embed-reporting-functionality/advanced-topics/sample-3-dynamically-generated-jdbc-input-swing-output.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.