Without using the Report Designer, you can also pass data via parameters to the Report Viewer applet. That is, you can use the Report Viewer to directly view a data file, or pass the data directly in the form of lines of data, in the HTML code. The following is a list of parameters:

Example: With the parameter RefreshInterval you can insert the following line:

<PARAM name="RefreshInterval" value="60">
      

In the above example, Report Viewer applet will fetch data from the specified data source (with the help of the ERES Server) and redraw the report every 60 seconds - all transparently. It is useful for accessing databases, which are updated frequently. Note that when specifying parameters that can have multiple values (or needs to be have multiple values), the separator is a space (“ ” without the double quotes). For example:

<PARAM name="RowBreak" value="0 1 2">
      

In the above example, the Row Break is set on Column 0, Column 1 and Column 2 of the Column Mapping (i.e., the first three columns). The values for the parameter have a space (" " without the double quotes) separating them.

Using parameters, you can specify a data source for the Report Viewer in order to display different data with a report template.

<applet code="quadbase.reportdesigner.ReportViewer.Viewer.class" width=640 height=480>

      <PARAM name="sourceDB" value="jdbc:odbc:DataSource, sun.jdbc.odbc.JdbcOdbcDriver, username, password, select * from products">
      <PARAM name="ColInfo" value="0 1 3">
      <PARAM name="ReportType" value="SummaryBreak">
      <PARAM name="RowBreak" value="0">
      <PARAM name="Aggregation" value="SUM"> 

</applet>
        

<applet code = "quadbase.reportdesigner.ReportViewer.Viewer.class" width=640 height=480>

      <PARAM name="sourceFile" value="http://.../test.dat">
      <PARAM name="ColInfo" value="1 0 2 3">
      <PARAM name="ReportType" value="SimpleColumnar">

</applet>
        

<applet code = "quadbase.reportdesigner.ReportViewer.Viewer.class" width=640 height=480>

      <PARAM name="sourceData" value="int, string, int | value, name, vol | 10, 'John', 20 | 3, 'Mary', 30 | 8, 'Kevin', 3 | 9, 'James', 22">
      <PARAM name="ColInfo" value="1 0 2">
      <PARAM name="ReportType" value="SimpleColumnar">

</applet>
        

Using the Report Viewer, you can browse through the report using the Pop-Up Menu. Right-clicking on the report displays a Pop-Up Menu which can be used to traverse the report.

Report Viewer Window with Pop-Up Menu

The Pop-Up Menu can show the following options:

In addition to the Pop-Up Menu, you can also

In order for the Report Viewer applet to connect to the ERES Server (to fetch the report data, and save exported files) you will need to specify the following parameters in your HTML code:

<PARAM name="comm_protocol" value="servlet">
<PARAM name="comm_url" value="http://machine:port">
<PARAM name="servlet_context" value="ERES/servlet">
      

Adding the above params to your HTML code will make Viewer connect to the server at http://machine:port/ERES/servlet.

A JFC/Swing version of the Report Viewer can also be used by referring to SwingReportViewer.jar instead of ReportViewer.jar in the lib directory under the ERES install directory. Call the following class when using the Swing viewer: quadbase.reportdesigner.ReportViewer.swing.Viewer.class. You can also specify to use the Swing Viewer when creating an applet page in the Report Designer.

This section pertains to exporting from the viewer in an Applet only. When using the Report Viewer API to create a Component that displays a report, the user can right-click on the Component to launch a pop-up menu with various options. One of the options (Output → Server → Generate...) is for exporting the report to different file formats. This will result in creating the exported file on the server side. However, there is an API feature that utilizes a server-side Java Servlet to stream back the exported content to the client's browser. The following describes how to use this feature.

In the code that retrieves the report Component, two lines of code need to be added:

Viewer viewer = new quadbase.reportdesigner.ReportViewer.Viewer();
Component comp = viewer.getComponent(report);
viewer.setExportServlet("http://host:port/ERES/servlet/ViewerExportServlet");
viewer.setDynamicExport(true, "host", port, "ERES/servlet/");
      

The argument for the setExportServlet method is the url location of your deployed ViewerExportServlet. Please see the javadoc Specification for more details about the arguments of these two methods.

Then, when the user views the report Component, there will be new options under Output → Client → (Generate...). All of these options will result in a pop-up browser window that contains the streamed content of the report.