This section describes functionality that can be restricted by the software license for JasperReports Server. If you don’t see some of the options described in this section, your license may prohibit you from using them. To find out what you're licensed to use, or to upgrade your license, contact Jaspersoft. |
Domains are structures for managing data in JasperReports Server. They connect to a normal data source and select tables and colums, join them to others, arrange the results into business-related sets, give them meaningful labels, and provide access security based on users and roles. Through the server UI, users can then create reports interactively with the Ad Hoc editor, and the Domain acts as the data source, providing a curated view of your database.
Jaspersoft Studio can also create reports based on Domains defined in JasperReports Server. Such reports use a data adapter to load data accessed through a Domain. Then there are two different query languages you can use with a Domain: the "jasperQL" query language and the earlier "domain" query language.
The jasperQL language was introduced in version 7.8 and has better support for input controls and lets you order records by a field and limit the number of records shown. You can also group by one or more fields in the Dataset and Query dialog. Jaspersoft recommends using the more advanced jasperQL language.
Before your report can access a Domain with either query language, consider the following requirements:
• | Make sure your Domain is fully defined and saved on the server. For information about creating Domains, see TIBCO JasperReports Server Data Management Using Domains. The examples in this section use the supermart sample Domain. |
• | Make sure your JasperReports Server is online. |
• | Optional: Define the server profile or connection object, as described Connecting to JasperReports Server. You do not need the server profile to create and run a Domain report, but you will need it to publish the report back to the server. |
• | Create a data adapter for the server connection, as described in the next section. The data adapter may also identify the Domain on the server, or the report may specify the Domain. |
Creating a Domain Data Adapter
A data adapter for a Domain identifies your instance of JasperReports Server and the Domain in its repository.
1. | In the Repository Explorer, click |
Creating a New Data Adapter |
Alternatively, you can edit the empty Jaspersoft Server Data Adapter that is created by default as a template. Double-click it in the Repository Explorer panel to open it for editing in the Data Adapter Wizard.
Entering Server and Domain Information |
2. | Enter a name for the data adapter, usually the name of the Domain. |
3. | Enter the URL to access your server, ending in jasperserver-pro/, or click |
4. | Enter the username and password to access your server. If you access a Domain in an organization, specify the credentials of a user or administrator in the organization, including the organization name or alias. It is good practice to use the creditials of the least permitted user who still has access to the Domain or Domains you want to access. If you have reports with different Domains using the same data adapter for this server, make sure the user has access to all Domains and all the data that you need in the Domains. |
A Domain may restrict access to its data based on the user who accesses the data. Restrictions can be based on usernames, roles, attributes, or any combination of these. Depending on how your Domain is defined, the credentials you choose here may affect the data that appears in reports that use this adapter. If you access multiple Domains, the data from each of them may be affected by the user given here. |
5. | Click Test to make sure your server is accessible and the credentials are valid. |
6. | Optional: enter the repository URL of your Domain or click |
When browsing, you can enter a name and select it from the results, or navigate the repository tree that is accessible to the user you specified. Mouse over a resource to see its description and details.
Creating a New Data Adapter |
7. | Click Finish to create the data adapter for your Domain. |
Creating a Domain Report
As of Jaspersoft Studio 7.8, the jasperQL query language is the default query language for a Domain report. You can create a query when you first create the report or you can add it later using the Dataset and Query dialog.
To create a new report based on a Domain:
1. | Make sure you have defined a data adapter for accessing the Domain on your instance of JasperReports Server. For more information, see Creating a Domain Data Adapter. |
2. | Click |
3. | Select a template and click Next. |
4. | Select a location to save your report, enter its name, and click Next. |
5. | Select the data adapter for your Domain or server, in this example we use "Supermart Domain." |
The wizard refreshes to show the query language, the pathname of the Domain and the fields of the Domain that are available.
Fields of a Domain Available Through the Data Adapter |
The default query language is jasperQL. You can select a different Domain on the server if needed, and the dialog updates the available fields. The Domain being used is stored in the report itself, therefore it may be different from the one in the data adapter.
6. | Select fields or folders in the Domain on the left of the dialog, and drag them to the Fields item on the right to create fields. For example, drag Sales > Stores. |
The items are added as a flat list, using the labels from the Domain. At this point, you can refine the query by adding fields to filters, group by, and order by headings. These actions are covered in detail in then next section, Using the jasperQL Query Designer.
7. | When done, click Next to select the dataset fields. These are the fields that appear in the report outline for use in creating the report. In this simple example, click |
Fields of the Query Result Selected for the Report |
8. | Click Finish and the report appears in a new tab with a blank canvas. The elements and fields of the report appear in the report outline. When you mouse over the fields, you see the field's label from the Domain. |
Fields of a Domain in the Report Outline |
9. | Define your report as usual, using the Palette and Outline to add and organize components. |
10. | Click Preview to test your report. Jaspersoft Studio compiles your report; if it's successful your report is filled and displayed. |
11. | You will be prompted to publish your report upon save, or click |
Using the jasperQL Query Designer
The jasperQL query language is a JSON-based syntax for defining a query used to access data through a Domain on JasperReports Server. In practice, you define your query interactively through the UI of the New Report dialog or later in the similar Dataset and Query dialog. In the previous sections, we created the data adapter to access the Domain and a report that uses the data adapter. In this section, we explain how to create a query interactively in the designer.
After a Domain-based report has been created, you can always go back and change or refine the query by right-clicking the root of the report in the Outline panel, and selecting Dataset and Query... If you want to use input controls in your report, define the corresponding parameters in your report before adding them as a filter in this dialog. When the report uses a Domain data adapter and the jasperQL query language, the center of the dialog contains the jasperQL query designer:
Editing a jasperQL Query in the Dataset and Query Dialog |
The panel at the bottom of the Dataset and Query dialog displays the fields that are selected from the query results (the dataset) for use in the report. If you configure the jasperQL query fully, you will reduce the results so they contain exactly the fields you need. In that case, click the Read Fields button, to "read" all the query result fields into the report, and they will replace any in the Fields tab at the bottom.
The panel at the bottom also has a Data Preview tab for testing the query. Use its controls to run the query and see the values returned for the fields you've chosen or created. For example, this lets you check your aggregation, grouping, and expected calculated field values. This is particularly useful to test any DomEL expressions in your query elements.
The query designer has a Text tab that displays the text of the current query for information purposes. The jasperQL query is a JSON text that is sent to the server through a private API. The syntax of the JSON is also private, and editing the query on the text tab is not recommended.
JSON Text View of a jasperQL Domain Query |
On the Designer tab, you can create a query of your Domain by dragging and dropping fields, entering expressions, and clicking for certain actions. The elements of the query are structured like an SQL query. The result is a query that is easy to create and easy to interpret:
Visual representation of a jasperQL Domain Query |
Use the following interactive features of the jasperQL query designer to create your query:
Selecting Fields
Select fields or folders in the Domain on the left of the dialog, and drag them to the Fields heading on the right to create fields. These are the fields that will be returned by the query. You can have many fields, and later use only the ones you need in the report, or you can select exactly the fields that you need for the report. The items are added as a flat list, using the labels from the Domain.
You can mouse over a field name to see its name, ID, and type:
Information About a Field from the Domain |
To remove a field from the list under the Fields heading, or any other heading on the right side, right-click the field and select Delete from the context menu. You can also select the field and use the Delete key.
To specify distinct values for all fields returned by the query, right-click the Fields heading and select Set/Reset DISTINCT. You can also double-click the Fields heading to toggle the setting.
Using Field Aliases
To create an alias for a field, double-click the field in the right-hand panel, enter the alias in the AS text box, and click OK:
Creating an Alias for a Field |
The alias is also useful for giving fields a simple name wherever they appear in Jaspersoft Studio, otherwise the fields are known by their ID, for example: sales_fact_ALL.sales.store_features.store_sqft.
Defining Aggregate Functions
To create an aggregate function on a field, right-click it on the left or right panel, and select Add Aggregate Function from the context menu. Choose the function from the drop-down menu, and optionally give the field an alias in the AS text box. The available functions depend on the field type. To modify the function on an existing aggregate field, double-click the field.
Aggregate Function dialog |
Defining Calculated Fields
If you need a calculated field that is not in your Domain, you can create it in the query so that it is available in your report. Calculated fields are defined using the Domain Expression Language (DomEL) language, described in the TIBCO JasperReports Server Data Management Using Domains.
To create a calculated field, right-click on an item in the left-hand panel and select Add Calculated Field from the context menu. Enter a valid DomEL expression and enter a name for the field in the AS text box. For example, the following expression concatenates two string fields to make the location easier to display in the report:
Defining a Calculated Field |
Filtering Results
Defining a filter in the query reduces the size of the results and means that your report processes only the rows of data you are interested in. To define a filter, drag a single item from either side to the Filters heading on the right, or right-click on the item and select Add to Filters. Choose the comparison operator from the drop-down menu; the available operators depend on the field type.
Defining a Filter |
Type the comparison value for the filter or click ... to select from a list of available values. Jaspersoft Studio queries the data through the Domain to display the list. The results include rows of data for other fields chosen so far. Double-click any row to insert the bolded value as the comparison value in the filter.
Choosing Filter Values |
Alternatively, you can right-click the comparison value field and select Parameter or Function to use JasperReports parameters or functions that you have already defined. Each of those options brings up a dialog where you can specify the parameter or function. For example, parameters can be used to compare values against input controls that you have defined in the report. When using parameters in filters, be sure to define default values for the parameters to avoid unexpected errors.
For more information on parameters, see Parameters.
Repeat these steps for each filter you want. For the second filter and each one thereafter, a menu in the filter expression dialog lets you choose to AND or OR your filter with the previous one.
Adding a Second Filter |
To change the operator or value of a filter, double-click it on the right-hand panel. You can also drag filters to change the order of composition. Finally, you can double-click the Filters heading and select Replace DomEL Filter. This special filter allows you to write DomEL expressions on both sides of the operator and compare them.
Grouping Rows
To group by a field, drag the field from the left to the Group By heading on the right, or right-click on the item and select Add to Group By. Unlike SQL queries, the field being grouped by must not be selected in the list of fields on the right. In the Group By dialog you can enter an alias for the field in the AS text box, but it is not required:
Defining a Group |
Ordering Rows
To order the results by the value of a field, drag the field to the Order By heading on the right, or right-click on the item and select Add to Order By. The default ordering is ascending, but you can double-click the item and change the direction of ordering.
Defining a Descending Order |
Limiting Rows
To limit the number of items shown in your report, double-click the Limit heading in the right-hand panel and enter the maximum number of rows to return from the query. For example, if you are working with a large dataset, you might want to limit time it takes to run while you are designing your report.
Defining a Row Limit |
Using the domain Query Language
The domain query language is the older query language for a Domain report. The interface is similar to the jasperQL query language, but it does not support as many features in the query. You can still use and edit reports that use a domain-language query, but Jaspersoft recommends using the jasperQL query designer for all new reports.
Because the two query languages are not compatible, you cannot switch between them once you have started creating your query. If you want to upgrade a report with the domain-language query to use the features of a jasperQL query, you will need to rewrite the query after switching the language setting. In some cases such as aggregation where the report had to be configured a certain way because the domain-language did not support aggregation, you will need to rewrite parts of the report. However, the report will be simplified because the aggregation can be done by the query.
Recommended Comments
There are no comments to display.