Creating a Domain Report from iReport Tutorial

Verify that a connection to theJasperServer repository is defined and the domain plug-in activated:

• Go to Window > JasperServer repository
• Go to Window > Domains

The Repository Navigator window (red arrow) and the Domains Window (green arrow) will be visible, as indicated in the image below:

In the Repository Navigator window, click Add new server icon.

Result: The JasperServer Plugin window appears:

A JasperServer Plugin window will appear. Enter the following:

• Name: Name of your server
• JasperSrver URL: Specify the url of your server repository: Http://[ip-adress]:[port]/jasperserver-pro/services/repository
• Organization: Enter the organization_id
• Username: Enter the username
• Password: Enter the password.

Click Save

Result: Your server is added to list in the Repository Navigator section. Report developers can now interact with various resources that are contained in the JasperServer repository.
 

 In the New wizard, select the server containing the Domain you wish to use, then click Next.

Example: In the example, use SupermartDomain

 From the available groups of fields, double click to open the groups and display fields or subgroups within that group.

Example: For this example, open the group and subgroups: Expenses > Stores > Regions

 To create a condition, select the desired field and click Create Condition

Example: For this example, select Country

The Condition Editor proposes operators based on field type  (Text, Dates, …)

Example: For this example, select Equals

To complete the condition definition, click the (…) icon

Result: A popup window appears to prompt you for the available values.

Select a value then click OK.

Example: For this example select USA
 

Best Practice: Select multiple values using the control key. The ability to select multiple values will be driven by the selected operator.

Example:  is one of …
 

The condition is defined and added to the query.

The condition can also be used to prompt the user. If this is approach is taken, the condition is treated as a parameter.

• Example: Prompt the user to select a different country.
• Check the is for prompt box
• Click add/update condition button.
• The condition is now listed. Note the (for prompt) indicates that a parameter and a input control have been created for this condition.

From now you can add new conditions (repeat from step 4) or update an existing one (simply click on the condition listed, change settings then click add/update button).

Note: Once you have selected a field within a given ‘data island’, fields that are part of another ‘data island’ will be greyed out.

Click Next when prompted, enter a name and location for the report, then click Finish.

Notice that the fields are listed in the Domain window but none of them are listed in the field list on the report inspector. The field node, within the Report Inspector window, will be populated with fields used by the report.

You can add a field to the report by dragging and dropping a field from the Domain window to the desired location in the report.

Example:  For this example, drag the field “Country” to the top left of the title bland. Notice the fields list in the report inspector now contains the Country field.

Repeat the previous steps with the following fields listed below.
Drag each field into the detail band:

• City
• Expense Date
• Expense Amount
   

Create a variable that counts the stores in a country.

Prior to defining the variable, we have to add store_name field to  the report.

There are two ways for adding a field to a report.

• Drag-and-drop, OR
• Right-click on the field name in the Domain window and then select Add field to report

Example: For our example, right-click on Store_name and select Add field to report

Example: For our example, create a variable store_count and then assign the values below:

For the variable expression select the field $F{expense_fact.exp_store.exp_store__store_name}

Select a folder for storing the report (in our sample the public folder).

Click Finish

Result: The report has been published to JasperServer repository.

Test the report within iReport

Go on the repository navigator then open the folder containing the report. Right-click on the report unit and select “Run Report Unit”.

The report is being executed and filled by the server and the result will be displayed in iReport.

• You can edit the filters anytime by clicking the Edit Filter button in the Domain Windows

• You can see the Domain query using the report query icon; this will display the semantic layer query.
  • You can modify it here if you wish:
  • 
• iReport cannot use Domains alone; reports have to be published on the server as only JasperServer understands Domain queries
  • Which is why some automated features of iReport cannot work
• Create conditions between two fields:
  • In the Condition Editor, select two fields by holding the control key
  • Click Create Condition
  • You can switch the field position; use the swap button on the right side
  •