FreshDeliveryDemo

This is a demo site that embeds JasperReports Server using the Visualize.js framework

Code: https://github.com/marianol/FreshDeliveryDemo

Author(s): See list of Contributors

Version: 0.2

##Description The sample is designed to showcase the features of the Jasper Visualize.js framework to embed BI in web applications. Ibe used with a set of reports that are included in this sample that depend on the Foodmart Sample dataset that is provided in the standard trial instalation of JasperServer Professional 5.6.

Essentially contains a demo site (Fresh Delivery) a set of reports integrated within. It runs form a WebServer since it only uses HTML and Javascript so there is no specific requirements for the webserver.

##Install the Sample ###Requirements / Dependencies

• A JasperReports Server v5.6 installed
• A web server to host this sample. I use Apache HTTPD you use whatever floats your boat.

Instalation Steps

1. Unzip the release (or clone the repo) into your web server's web root. The instrucctions assume that this location is called 'FRESHDELIVERY_PATH'
2. Import /JapserServerResources/freshDelivery-RepositoryExport.zip to your JasperServer 5.6 Pro instance. Check this link if you do not know how. and if you like the command line go to your JRS buildomatic folder and just ./js-import.sh --input-zip FRESHDELIVERY_PATH/JasperServerResources/freshDelivery-RepositoryExport.zip
3. Modify your jasperreports.properties to allow JavaScript functions in the HTML5 Charting Library
   1. Locate your jasperreports.properties in JasperReportsServer <tomcat-home>/webapps/jasperserver-pro/WEB-INF/classes/jasperreports.properties
   2. Add this line at the end of the file: com.jaspersoft.jasperreports.highcharts.function.properties.allowed=true
4. This sample needs to add Lat/Long coordinates to the store table on the foodmart database
   1. the sql file with this changes is located in the repo FRESHDELIVERY_PATH/JasperServerResources/foodmart-store-update.sql
   2. use that sql script to update your DB, at the command prompt: psql -U postgres -d foodmart -a -f FRESHDELIVERY_PATH/JasperServerResources/foodmart-store-update.sql
5. The pages expect JasperServer to be accessible in http://localhost:8080/jasperserver.pro since that is normally not the case you will need to change this. For example if your jasperserver is located in http://my.jasperserver.com:8080/jasperserver.pro just open a terminal and do:

$ sed -i 's~localhost~my.jasperserver.com~' /var/www/html/freshdelivery/go-green.html
$ sed -i 's~localhost~my.jasperserver.com~' /var/www/html/freshdelivery/top-sellers.html
$ sed -i 's~localhost~my.jasperserver.com~' /var/www/html/freshdelivery/healthy-choices.html

1. The script is hardcoded to login using jasperadmin/jasperadmin if you need to change this, do so in /js/visualizeHelper.js
2. Go to http:///FreshDeliveryDemo/
3. Enjoy!!!

Some lessons learned

This is just work in progress and should probably be in another file...

####How to turn off the chart selector icon for specific charts in JRS

• In JSS go to the main properties panel and on the Property Expressions select the "…” button.
• Select Add and for the Property Name use: com.jaspersoft.jasperreports.highcharts.interactive
• Set the value to true. Do not select “use an Expression” unless you are going to use one for setting this property.

####Resource not found error

• You may see from time to time a resource not found error appear in the GoGreen.html page. This is because of a bad implementation in the sample. We call an update on the report parameters right after we init the report. In this case a race condition exists and if the report is not fully rendered before the updateTable() and changeChartCity() get executed you will see that 404 error but after accepting it all will work as expected. We need to fix this by runnin this functions in the OnReportFinished Event

LICENSE AND COPYRIGHT NOTIFICATION

Copyright (C) 2005 - 2012 Jaspersoft Corporation - All rights reserved.

Unless you have purchased a commercial license agreement from Jaspersoft, the following license terms apply:

This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details.

You should have received a copy of the GNU Affero General Public License along with this program. If not, see http://www.gnu.org/licenses/.