User Tools

Site Tools


jasperreports_systems_administrator_guide

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
jasperreports_systems_administrator_guide [2024/03/24 03:37] – [Helical Notes] ghacheyjasperreports_systems_administrator_guide [2024/04/10 07:05] (current) – [Required Libraries] ghachey
Line 41: Line 41:
 security.validation.sql.on=false security.validation.sql.on=false
 </code> </code>
 +
 +===== Firewall =====
 +
 +Tomcat bundled with the JasperServer is already configured to be able to listen on external interfaces. But the windows firewall would block it by default. The safest is to only open the port 8080 to those who will access the JasperServer directly. This usually means administrators and developers as all reports are made available directly in the Pacific EMIS web application.
  
 ===== Integration with Pacific EMIS ===== ===== Integration with Pacific EMIS =====
 +
 +A powerful feature of the Pacific EMIS is its seamless integration with a high end enterprise grade reporting server called JasperReport Server (aka. JasperServer).
 +
 +<note warning>JasperServer until recently (end of 2023) been developing and release JasperServer as open source. Unfortunately, they now only release their JasperSoft Studio to design the reports and no longer release the JasperServer without the enterprise license. But all previously released versions are extremely stable and will continue working for years.</note>
 +==== Configuration of the Web Application ====
  
 To effectively integrate the JasperReport server with the Pacific EMIS you need to make sure the relevant part of the Web.Config is edited accordingly (i.e. jasperUrl, jasperUser, jasperPass). This would likely be different whether you are working in development or deploying to production. To effectively integrate the JasperReport server with the Pacific EMIS you need to make sure the relevant part of the Web.Config is edited accordingly (i.e. jasperUrl, jasperUser, jasperPass). This would likely be different whether you are working in development or deploying to production.
Line 70: Line 79:
 For example, if you want a new report to go under the Schools (e.g. List of school without annual census submission this year) module you would design it and put in a a folder **Schools**. When published all the published reports in here will appear in the Pacific EMIS' Schools module as shown in the figure below. For example, if you want a new report to go under the Schools (e.g. List of school without annual census submission this year) module you would design it and put in a a folder **Schools**. When published all the published reports in here will appear in the Pacific EMIS' Schools module as shown in the figure below.
  
 +{{ :sysadmin-manual:jasperreports-integration-1.png?nolink |}}
 +
 +Now if you wanted to have a report for individual schools (e.g. A School Report Card). You would locate it in a folder called **School** (not without the plural "s"). In this case, it would appear in any of the individual school as shown below.
 +{{ :sysadmin-manual:jasperreports-integration-2.png?nolink |}}
  
 +The same will work for any other module (i.e. Indicators, Exams, Teachers, Individual Teachers, etc.)
  
 +==== Required Libraries ====
  
-  * Students This folder includes all .jrxml files related to Students +Some or all reports require some additional jar files in essence small dependenciesThey are listed and described here.
-  * Teacher This folder includes all .jrxml files related to Teacher +
-  * Teachers Their is Two sub folder in Indicators +
-    * Teachers Report by Summary This folder includes all .jrxml files related Teachers reports by Nation +
-    * Teachers report by Nation This folder includes all .jrxml files related Teachers reports by State+
  
-Required Libraries: +  * **font-extension.jar**Used to support the new custom fonts in jasper server. Can be added directly in **<Jasper Server>\apache-tomcat\webapps\jasperserver\WEB-INF\lib** 
-  * font-extension.jar: It is used to support the new custom fonts in jasper server +  * **reporting-1.0.jar**Used as a chart customizer to customize the look of exams reports among potentially others. Can be added directly in **<Jasper Server>\apache-tomcat\webapps\jasperserver\WEB-INF\lib** 
-  * reporting-1.0.jar: This jar is used for chart customizer to customize the chart colors +  * **sqljdbc-VERSION.jar**Used for JBDC connection to interact with the MS SQL ServerOften loaded directly from the UI of JasperServer when creating the data source or in JasperSoft Studio.
-  * sqljdbc4-2.0.jar: This is used for creating jdbc connection. We can add this driver in both Jasper server and Jaspersoft studio if sql jdbc driver not imported+
      
-Add both the jar files in jasper server library folder +Restart the server when adding the jars for the first time.
-Path: …\<Jasper Server>\apache-tomcat\webapps\jasperserver\WEB-INF\lib+
  
-Restart the server+==== Fonts ====
  
-You also need to install open-sans fonts in Windows and Jasper:+Reports have been standardized using the Open Sans famliy of fonts so those will need to be installed on the Windows Server. Just download them from https://fonts.google.com/specimen/Open+Sans or https://www.1001fonts.com/open-sans-font.html, extract and double click each one of them to install. Maybe now is a goo time to restart the server before testing out some reports.
  
-  * Go to Window -> Preferences -> Jaspersoft Studio -> Fonts. Click on Add from path and select the zip file.  +Note that if you are designing reports you will also need to install them on your own workstation and you could also install them directly in the JasperSoft Studio. To do this you would go to **Window -> Preferences -> Jaspersoft Studio -> Fonts**. Click on Add from path and select the zip file. Install in JasperSoft Studio as shown below.
-  * Install in JasperSoft Studio+
  
 {{:developer-manual:jasper-add-font.png?nolink|}} {{:developer-manual:jasper-add-font.png?nolink|}}
jasperreports_systems_administrator_guide.1711251436.txt.gz · Last modified: 2024/03/24 03:37 by ghachey