Creating and displaying a report using JasperReports and iReport involves several steps. First, you need to install iReport, which is a report designer for creating Jasper reports. After installation, open iReport and click on the icon for report data source to create a new database connection. Enter the database name, JDBC URL, server address, database, username, and password, then test the connection to ensure it is successful . Next, use the report wizard to start creating a report by specifying the report name and storage location. Then, select the previously created connection and enter the query for the report. Choose the fields to display and decide on a layout, such as tabular layout . Once the report is complete, use JasperDesign to load the *.jrxml file, compile it with JasperManager to create a JasperReport object, fill the report using a data source into a JasperPrint object, and finally, display it using JasperViewer's viewReport method .

JasperViewer is used to display a report by calling its viewReport method with a JasperPrint object and a boolean indicating whether the viewer should exit on close. It renders the compiled and filled report, allowing users to view it in a GUI window. JasperViewer's significance lies in its ability to provide a preview of the report, facilitating verification and printing directly from the application, enhancing user experience with interactive viewing options .

When generating a report with JasperReports, potential exceptions include connection issues, invalid file paths for the *.jrxml design file, SQL syntax errors, and issues during compilation of the report design. These are commonly handled by enclosing the report generation code in a try-catch block and displaying error messages using JOptionPane.showMessageDialog to inform users of the issue .

Compiling a report design in JasperReports is necessary because the report design file (*.jrxml) is written in XML, which needs to be compiled into a JasperReport object before it can be executed and filled with data. This compilation process translates the XML-based design into a format that can interact with the data source and can be rendered by JasperViewer for display or export .

JasperManager plays a crucial role in managing JasperReports by providing key methods such as loadXmlDesign, compileReport, and fillReport. loadXmlDesign loads the XML design file (*.jrxml) for the report, compileReport compiles the loaded design into a JasperReport object, and fillReport fills the compiled report with data from the specified connection and parameters into a JasperPrint object, which can then be displayed or exported .

To call a report from a Java Swing application's main menu, first ensure that the database connection is established. Use the main menu event handler method, such as mnLapBarangActionPerformed, to instantiate a new report object using the report constructor and pass the filename of the *.jrxml report and the established database connection variable. This setup makes the report display within the Java application upon menu item selection .

To establish a connection to a MySQL database in iReport for JasperReports, start by clicking on the icon for report data source in iReport. Create a new connection by clicking 'New' and fill out the required fields: database connection name, JDBC URL, server address, database name, username, and password. After entering these details, click on the test button to verify the connection .

Using iReport as an IDE for JasperReports streamlines the report development workflow by providing an integrated environment for designing, testing, and refining reports. It offers a graphical interface for creating complex report layouts, managing data sources, and editing SQL queries visually. This can reduce development time and errors compared to manually editing XML files, and allows developers to focus on report logic and presentation. Furthermore, iReport's ability to test database connections and preview reports facilitates iterative development and debugging, improving overall efficiency and quality .

Report parameters in JasperReports are integrated by creating a Map to store parameter names and values. These parameters can be set using the JRDesignQuery setText method, where they can be incorporated into the SQL query. When filling the report using JasperManager's fillReport method, the parameters are passed along with the database connection to generate the report content as specified by the parameter values .

To modify the SQL query of an existing report in iReport, you need to update the query through the JRDesignQuery object. You set the new query using the setText method on the JRDesignQuery instance associated with the JasperDesign object. After setting the new query, re-compile the report design using JasperManager to generate the updated JasperReport object that reflects the new query changes .