Previous Page Next Page

Creating Page Reports

Creating a banded report

Creating a table report

Creating a crosstab report

Creating a chart report

In Page Report Studio, you can create page reports or add new report tabs to the current page report if the corresponding catalog contains predefined business views. Before you can create page reports, you should make sure that the Pop-up Blocker is not enabled on your web browser.

A JReport Live license for JReport Server is required in order to use this feature. If you do not have the license, contact your Jinfonet Software account manager to obtain it.

To create a page report:

1. Do any of the following:
   • In the JReport Server Start page, click Page Report in the Create category. In the displayed page, specify the folder in which to create the report, then the catalog that contains the required business view. Click OK.
   • In the JReport Server console, go to the Resources page, open a folder that contains catalogs, select the catalog for the new page report from the Catalog drop-down list, then click New > Page Report on the task bar.
   • In Page Report Studio, click Menu > File > New Page Report.

   The New Page Report dialog appears for you to create a page report with the first report tab in it.

   

2. Specify the title of the report tab as required in the Report Title text box.
3. In the Choose Report Layout box, select the required layout with which you want to create the report tab.
4. Click OK to create the report tab.
   • If Blank is selected as the layout, a report tab which is blank will be created. You can then use the Toolbox and the Resource View panels to add objects and view elements to the report tab.
   • If you select the layout as Banded, Table, Chart, or Crosstab, the corresponding report wizard will then be displayed. Specify the settings according to your requirements.

     Tip: In the report wizard, if there is only one business view in the current catalog, this business view will be used to create the report tab by default, and the Data screen will be hidden from the wizard. This is the same case when there is only one style available to be applied to the report tab.

You can also use URL command to directly open the New Page Report dialog to create a page report.

To create a report tab in an existing page report, in Page Report Studio, click Menu > File > New Page Report Tab or the button on the toolbar. In the New Report Tab dialog, specify the title and layout of the report tab, then click OK.

The following shows in detail how to create a report tab from a particular layout.

Creating a banded report

A banded object is a kind of component that can present grouped data and detailed data, and is composed of several banded panels with which you can easily organize data fields and other elements.

To create a banded report:

1. In the New Page Report dialog, select Banded as the layout and click OK to display the Banded Wizard.
2. In the Data screen, select the business view in the current catalog, on which to create the banded object.

   

3. In the Display screen, add detail objects or group objects from the Resources box to be displayed as detail fields in the banded object. To edit the display order of the objects, select one and click or . By default the display names of the added objects will be used to label the corresponding detail columns; to edit the label text for a detail column, click in the Display Name text box and enter a new one; if you want to automatically map the label text to the dynamic display name of the object, check the Auto Map Field Name checkbox beside the text box.

   

4. In the Group screen, add group objects as the grouping criteria, then specify the sort direction of each group in the Sort column. To adjust the group levels, select a group and click or .

   

5. In the Summary screen, add aggregation objects to summarize data in the banded object as follows: in the right box, specify the group to which the aggregation will be applied, then select an aggregation object in the Resources box and add it to the right box. You can add several aggregations for any group level. Click or to adjust the order of the aggregations in the current group or move an aggregation to another group if needed. By default the display names of the added objects will be used to label the corresponding summaries; to edit the label text for a summary, click in the Display Name text box and enter a new one; if you want to automatically map the label text to the dynamic display name of the object, check the Auto Map Field Name checkbox beside the text box.

   

6. In the Query Filter screen, specify the filter you want to apply to the business view. If the selected business view contains parameters, you would be prompted with the Enter Parameter Values dialog to specify values to the parameters before the Query Filter screen is displayed.

   

7. In the Style screen, apply a style to the banded object.
8. Click Finish to create the report.

Creating a table report

Tables give you great control over how to present data, including placing fields, grouping them, and sorting them.

To create a table report:

1. In the New Page Report dialog, select the desired table type in the Choose Report Layout box, then click OK to display the Table Wizard.
   • Table (Group Above)
     Creates a table with group information above the detail row.
   • Table (Group Left)
     Creates a table with group information left to the detail row.
   • Table (Group Left Above)
     Creates a table with group information left above the detail row.
   • Summary Table
     Creates a table with only group and summary information. In a summary table, all the group names will be put in the group header of the innermost group.
2. In the Data screen, select the business view in the current catalog, on which the table will be built.
3. In the Display screen, add detail objects or group objects from the Resources box to be displayed as detail fields in the table. To edit the display order of the objects, select one and click or . By default the display names of the added objects will be used to label the corresponding detail columns; to edit the label text for a detail column, click in the Display Name text box and enter a new one; if you want to automatically map the label text to the dynamic display name of the object, check the Auto Map Field Name checkbox beside the text box. Note that for a summary table, the detail fields specified on the Display screen will not be shown in the generated table by default.

   

4. In the Group screen, add group objects as the grouping criteria, then specify the sort direction of each group in the Sort column. To adjust the group levels, select a group and click or .

   

5. In the Summary screen, add aggregation objects to summarize data in the table as follows: in the right box, specify the group to which the aggregation will be applied, then select an aggregation object in the Resources box and add it to the right box. You can add several aggregations for any group level. Click or to adjust the order of the aggregations in the current group or move an aggregation to another group if needed. For the Group Left table, you can use the Row and Column columns to control the position of the aggregations in the table. By default the display names of the added objects will be used to label the corresponding summaries. If the table is not Group Left type, you can edit the label text for a summary: click in the Display Name text box and enter a new one; if you want to automatically map the label text to the dynamic display name of the object, check the Auto Map Field Name checkbox beside the text box.

   

6. In the Query Filter screen, specify the filter you want to apply to the business view. If the selected business view contains parameters, you would be prompted with the Enter Parameter Values dialog to specify values to the parameters before the Query Filter screen is displayed.
7. In the Style screen, apply a style to the table.
8. Click Finish to create the report.

Creating a chart report

A chart organizes and graphically presents data in a way that makes it easy for end users to see comparisons, trends, and patterns in data. It represents the report data in a visually straightforward form.

For details about the chart types JReport supports, see Chart Types in the JReport Designer User's Guide.

For how charts present data, see How Data Is Represented in a Chart in the JReport Designer User's Guide.

For the elements that compose a chart, see Chart Elements in the JReport Designer User's Guide.

To create a chart report:

1. In the New Page Report dialog, select Chart as the layout and click OK to display the Chart Wizard.

1. In the Data screen, select the business view in the current catalog, on which the chart will be built.
2. In the Type screen, specify the chart type as required.

   

   A default chart type exists in the Chart Type Groups box. To replace it with another one, select a chart type from the Chart Type box. The thumbnails of the subtypes in this type will then be displayed in the Subtype box. Select the required subtype to replace the default chart type.

   If you want to create a combo chart, click <Add Combo Type> of Primary Axis or Secondary Axis in the Chart Type Groups box, and an additional subtype will be added. To replace the additional subtype, select it, then specify the required type and subtype respectively in the Chart Type and Sub Type boxes.

   To add more subtypes, repeat the procedures. To remove a subtype, select it and click .

3. In the Display screen, select a group object in the Resources box and add it to the Category or Series box, the data of which will be displayed on the corresponding axis. Select a subtype in the Show Values box, then add an aggregation object or an additional value as the data of the subtype. You can add more than one aggregation object or additional value to a subtype. Each added subtype shall have at least one aggregation object or additional value. For a subtype that is a bubble chart, you can add two or three aggregation objects to the subtype.

   

   To add an additional value to a subtype:

   1. Select the subtype in the Show Values box.
   2. In the Resources box, expand the Additional Values node, then select Constant Value/Average Value.
   3. Click beside the Show Values box. The Edit Additional Value dialog appears.
   4. In the Name text box, specify the display name for the constant/average value.
   5. Input the constant value with numeric type in the Value text box, or select a field based on which the average value will be calculated from the Based On drop-down list.
   6. Click OK, and the defined constant/average value will be added to the subtype.

      If you want to further modify a constant/average value, select the value in the Show Values box, then click . In the Edit Additional Value dialog, edit the value as required.

4. If you want to customize the sort order and define Select N condition for values displayed on the category/series axis of the chart, click the Order/Select N button below the Category/Series box in the Display screen, then define the condition in the Order/Select N dialog.

   

   1. In the Order box of the Order/Select N dialog, specify in which order values on the category/series axis will be sorted.
   2. In the Select N box, specify the Select N condition to All, Top or Bottom. If All is selected, all category/series values will be shown in the chart; if Top or Bottom is selected, the text box next to it will be enabled and you can specify an integer here, which means that the first or last N category/series values will be shown on the chart.
   3. Check the Based On checkbox and specify values for the two drop-down lists that follow according to your requirement.

      If Based On is unchecked, the order of the first or last N category/series values will be based on what you specify in the Order box of the dialog; if you check it, the order will be based values of a field on the value axis and the sort direction you specify in the drop-down lists next to the Based On checkbox.

   4. If you have selected Top or Bottom from the Select N drop-down list, you can check the Other checkbox and the type a string in the next text box, so that the category/series values beyond the first or last N range will be merged into the group with the name as that string.
   5. Click OK to accept the settings.
5. In the Query Filter screen, specify the filter you want to apply to the business view. If the selected business view contains parameters, you would be prompted with the Enter Parameter Values dialog to specify values to the parameters before the Query Filter screen is displayed.
6. In the Style screen, apply a style to the chart.
7. Click Finish to create the report.

Creating a crosstab report

A crosstab summarizes data and presents the summaries in a compact row and column format. JReport also supports a unique compound crosstab that allows you to put multiple compound row groups and column groups together and define summaries for every combination of a compound row group and column group. This makes far more sophisticated crosstab analysis possible.

1. In the New Page Report dialog, select Crosstab as the layout and click OK to display the Crosstab Wizard.
2. In the Data screen, select the business view in the current catalog, on which the crosstab will be built.
3. In the Display screen, specify the fields you want to display in the crosstab.

   

   From the Resources box, add group objects to the Columns/Rows box to display on the column/row headers of the crosstab. If you want to display compound column/row groups in the crosstab, click under the bottom right corner of the Columns/Rows box to create the groups, then select each group and add the required group objects to it. You can specify a sort manner on each group object in the Sort column. Add aggregation objects from the Resources box to the Summaries box to create aggregations in the crosstab. If you have created compound column/row groups in the crosstab, you can create aggregations for each combination of the compound groups by selecting a compound column group and a compound row group and then adding the required aggregation objects.

   For each column/row/summary field, you can click in the Display Name text box and input a name to label the corresponding column header/row header/summary, or check the Auto Map Field Name checkbox beside the text box if you want to automatically map the label text to the dynamic display name of the field (when the text box is blank and the checkbox is not selected, no label will be created).

   If you want to remove a group object, an aggregation object, or a compound column/row group, select it and click . To adjust the order of them, select one and click or .

4. In the Query Filter screen, specify the filter you want to apply to the business view. If the selected business view contains parameters, you would be prompted with the Enter Parameter Values dialog to specify values to the parameters before the Query Filter screen is displayed.
5. In the Style screen, apply a style to the crosstab.
6. Click Finish to create the report.

Previous Page Next Page