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/23 03:00] – [Catalog Restoration] ghachey | jasperreports_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 | ||
| </ | </ | ||
| + | |||
| + | ===== 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 59: | Line 68: | ||
| </ | </ | ||
| </ | </ | ||
| - | ===== Helical Notes ===== | + | ==== Folder Structure |
| + | |||
| + | The folders follow a simple convention to make integration with the Pacific EMIS easy. First, resources folders: | ||
| + | |||
| + | * **Images** Includes all the images which we used in all the .jrxml file. So images in reports should point to the repo: link before they are deployed in the JasperReport Server. This does require a annoying switching of the images links in the report when working between development in JasperSoft Studio and production in JasperServer. | ||
| + | * **Templates** Similarly to images, this folder includes all the .jrtx files which is used to apply particular styles in reports. The advantage of centralizing styles are well known. The same annoying switching of the links is reports is require before deploying. | ||
| + | |||
| + | Then there are all the folders that hold the reports. The Pacific EMIS is usually made up of simple modules (e.g. Schools, Teachers, Exams). Each of those modules typically have individual entities (e.g. an individual School, an individual Teacher.) Reports can be designed and place in particular folders to automatically appear in the Pacific EMIS through the RESTful API. | ||
| + | |||
| + | 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. | ||
| - | <note warning> | + | {{ : |
| - | Folder Structure | + | 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 " |
| + | {{ : | ||
| - | * **Images** This Folder Includes all the images which we used in all the .jrxml file,If we used any new image in report so need to add that in Images Folder and image path in the report should be this folder image path. | + | The same will work for any other module (i.e. Indicators, Exams, Teachers, Individual Teachers, etc.) |
| - | * **Templates** This Folder includes all the .jrtx files which is used to apply particular styles in reports. | + | ==== Required Libraries ==== |
| - | * **Indicators** Their is Two sub folder in Indicators | + | |
| - | * Indicators Report National This folder includes all .jrxml files related Indicators by Nation | + | |
| - | * Indicators Report by State This folder includes all .jrxml files related Indicators by State | + | |
| - | * School It contains one sub folder and few other individual reports | + | |
| - | * School Report Card This folder includes all .jrxml files related to School Report Card | + | |
| - | * Schools This folder includes all .jrxml files related to Schools | + | |
| - | * Students This folder includes all .jrxml files related to Students | + | |
| - | * 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 | + | |
| - | SQL Property Update: We need to disable the SQL validation property | + | Some or all reports require some additional jar files in essence small dependencies. They are listed and described here. |
| - | Path: …\< | + | |
| - | File Name: security-config.properties | + | |
| - | Property: security.validation.sql.on | + | |
| - | Update the above property to false and restart the server | + | |
| - | Required Libraries: | + | * **font-extension.jar**: Used to support the new custom fonts in jasper server. Can be added directly in **< |
| - | | + | |
| - | * reporting-1.0.jar: | + | * **sqljdbc-VERSION.jar**: Used for JBDC connection |
| - | * sqljdbc4-2.0.jar: This is used for creating jdbc 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 178: | Line 179: | ||
| I have found useful to temporarily change the passwords as using it later cause me more problem then I wanted to solved (special characters not handling well on the windows command line). | I have found useful to temporarily change the passwords as using it later cause me more problem then I wanted to solved (special characters not handling well on the windows command line). | ||
| - | Change password of the keystore. | + | Change password of the keystore. I made it a convenient easy to type password since it is temporary and the keystore will be disposed later. |
| < | < | ||
| Line 184: | Line 185: | ||
| </ | </ | ||
| - | Change password of the key of interest. | + | 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 after ward for tighter security. Another approach is to make it a good password right away and as it gets imported it keeps this password. |
| < | < | ||
| Line 208: | Line 209: | ||
| < | < | ||
| - | > | + | > |
| </ | </ | ||
jasperreports_systems_administrator_guide.1711162858.txt.gz · Last modified: 2024/03/23 03:00 by ghachey