* Fields I used for store table are : store_number,store_city,store_country
Do this first
Go to window->Click on Domains –> we can observe the window appearing just below to the Report Inspector window which is known as Domain Window.
File->New->Click on Domain Report(appears at left side)->Click on BlankA4->Click on Finish.
* We will navigate to the following window.
* Give all the details
Connection : This is nothing but connection from iReport to JasperServer
( We connect from Repository panel of iReport)
Domain : Select a domain which you have already created in jasper server.
( In this tutorial I have already created a domain and named it as foodmart_domain, and I’ve not shown the procedure of creating domain in this tutorial b’z we are learning how to create a report using domain but not domain creation )
Filters : Filters are nothing but input controls in the domain based report.
* We can select the field which we want to use as input control
* In this tutorial I have used two filters(input controls).
Find the images below for filters creation.
* Available fields : As we successfully connected to our foodmart_domain we can observe that the tables(of course fields also.. just double click on the folder of employee or store.. we can observe the fildes also ) available with the domain left side of the above image.
* Condition Editor : To use the filters concept we just have to
–> highlight(click on the field) the field from Available fields panel
–> then click on create condition
–> Field name : When you highlight the field from available fields panel it will automatically appear here.
–> Comparison : give the condition from the drop down list.
–> Value(s) : give some value ( Like we give in the parameter default expression in general reports)
–> Check the is prompt ( This is used for popping up the filters)
* In this way we can add as many filters(input controls=parameters) to the report before we design the report itself.
* We can add the filters in the middle of the designing of the report also.
* We can also change, delete, add/update the filters and corresponding conditions.
In our example I have given two filters. They are : i) gender ii) store_country
1st filter :
Field Name : gender
Comparison : Equals
Value(s) : M
2nd filter :
Field Name : store_country
Comparison : Equals
Value(s) : USA
* Click on next
* Give the name for the report and location to save the report.
Step 3 :
When you click on finish you are ready to design your report….
* You can observe the tables and fields available within the domain in Domains Window
* From there you can drag and drop the fields to the details band of the design area.
* The complete design of the report you can find in the below image.
That’s it we are done with report … A domain report..
* When we designing domain report , the iReport engine generates domain query language on it’s own( defaultly)
* This you can observe at Report Query Area.
* Find the image below for our example
* We have not provided any SQL query to generate the report.
* We have not added any parameters in the Report Inspector of Parameters section.
* But the iReport engine has provided the domain query and parameters from jasperserver.
* When we work with domain based Reports from iReport these all things done by iReport Engine.
How to see the preview of the report in Report Designer ?
We can directly preview the output in the designer by clicking on preview tab
You need to export this report to jasperserver and have to see the preview as follows.
* Right click on the Folder-> click on Run JasperServer Report
* You can see the output(preview) in new a new window(Report Viewer Window)
How to see the preview of the report in the JasperServer ?
upload the report to the server and see the preview.
The filter which we gave at the time of report design become input controls in the server and looks like in the following image.
Now click on Ok and see the preview.
We are done with simple domain based report from iReport.
Welcome with any queries at email@example.com or in this blog.
Thanks for reading this article 🙂
Best Open Source Business Intelligence Software Helical Insight is Here
What are the Levels of Software Testing? In this blog,we are going to understand the various levels of software testing In Software Testing,we have four different levels of testing,which are as mentioned below: Unit Testing Integration Testing System Testing Acceptance...
Introduction Pentaho is a business intelligence and data integration platform, and you can use “Get subfolder names” in transformations, The ability to retrieve subfolder names from a directory is often required when dealing with dynamic or changing file structures. Here...
In Bugzilla, Graphical reports encompass bar,line and pie charts,serving various purposes.For instance,when a user needs to identify the Severity of the bugs for the particular component and intends to visualize this data graphically,they have two available options to choose from...