jasperreports_systems_administrator_guide
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| jasperreports_systems_administrator_guide [2024/03/24 03:37] – [Helical Notes] ghachey | jasperreports_systems_administrator_guide [2024/12/15 04:51] (current) – [Catalog Restoration] ghachey | ||
|---|---|---|---|
| Line 6: | Line 6: | ||
| Unless you want to not use the bundled Tomcat and PostgreSQL then the only dependency to install is the Java Development Kit (JDK). The JasperSoft Platform Support Guide is the best place to look to decide what version to install. The JDK version 8 is our preferred choice at more recent Java are still only use to runtime only and need version 8 compatibility for compiling reports. | Unless you want to not use the bundled Tomcat and PostgreSQL then the only dependency to install is the Java Development Kit (JDK). The JasperSoft Platform Support Guide is the best place to look to decide what version to install. The JDK version 8 is our preferred choice at more recent Java are still only use to runtime only and need version 8 compatibility for compiling reports. | ||
| + | |||
| + | Here is a good time to set the JAVA_HOME environment variable. On windows you can do this permanently from start menu "Edit the system environment variables" | ||
| ==== Microsoft Visual C++ Redistributable ==== | ==== Microsoft Visual C++ Redistributable ==== | ||
| Line 41: | Line 43: | ||
| security.validation.sql.on=false | security.validation.sql.on=false | ||
| </ | </ | ||
| + | |||
| + | ===== 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> | ||
| + | ==== 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 81: | ||
| 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. | ||
| + | {{ : | ||
| + | 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 " | ||
| + | {{ : | ||
| + | The same will work for any other module (i.e. Indicators, Exams, Teachers, Individual Teachers, etc.) | ||
| - | * Students This folder includes all .jrxml files related to Students | + | ==== Required Libraries ==== |
| - | * 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: | + | Some or all reports require some additional jar files in essence small dependencies. They are listed and described here. |
| - | * font-extension.jar: | + | |
| - | * reporting-1.0.jar: | + | |
| - | * sqljdbc4-2.0.jar: This is used for creating jdbc connection. | + | |
| + | * **sqljdbc-VERSION.jar**: Used for JBDC connection | ||
| | | ||
| - | Add both the jar files in jasper | + | Restart |
| - | Path: …\< | + | |
| - | Restart the server | + | ==== Fonts ==== |
| - | You also need to install | + | 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:// |
| - | * 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 |
| - | * Install in JasperSoft Studio | + | |
| {{: | {{: | ||
| Line 177: | Line 187: | ||
| </ | </ | ||
| - | Change password of the key of interest. This password could also be made simple and convenient but then you would be best to change it in the production stored | + | Change password of the key of interest |
| + | |||
| + | <note important> | ||
| < | < | ||
jasperreports_systems_administrator_guide.1711251436.txt.gz · Last modified: 2024/03/24 03:37 by ghachey