Planet Jaspersoft

January 6, 2017

Want to change the look of JasperReports Server for each of your tenants or organizations? Check out this tutorial to learn more.

January 6, 2017

January 5, 2017

Want to change the look of JasperReports Server? Jaspersoft themes allow you to modify CSS and images to customize any aspect of the server including colors, logos, fonts and object placement.

January 5, 2017

July 20, 2016

How to create hyperlinks on HTML 5 charts using Jaspersoft Studio Pro version 6.1 or newer

July 20, 2016

Step-by-step tutorial that explains how to set up an Eclipse project containing custom code that extends JasperReport Server capabilities and then debug that code using a remote Tomcat server.

July 20, 2016

March 24, 2016

The TIBCO Maps component is available in the Professional edition of Jaspersoft Studio. In this example we show how to overlay polygons (e.g. "closed" paths or geographical areas) of US States on top of a map available via TIBCO GeoAnalytics. Alternatively you can use "open" paths to represent roads/routes or markers to represent specific points on the map, rather than areas. You can load data from any shapefile / geography, as per the article mentioned in the video: http://community.jaspersoft.com/wiki/how-generate-map-data-postgis-or-shapefiles-use-reports This is based on Jaspersoft Studio 6.1.1. It should work since release 6.1.0. For further details, including a sample file, see here: http://community.jaspersoft.com/wiki/how-use-tibco-maps-jaspersoft-studio-pro Thanks!

March 24, 2016

December 21, 2015

Create reports, views, dashboards and gain insights from any Cloudera Impala data, no matter how complex. This video walks you through connecting to data, building a domain and creating views on top of the data by non-technical users.

December 21, 2015

Create reports, views, dashboards and gain insights from any MongoDB data, no matter how complex. This video walks you through connecting to data, building a domain and creating views on top of the data by non-technical users.

December 21, 2015

August 17, 2015

This is an error which you get while exporting the data from the Jasperserver in the Excel Format.

Something of this sort






For resolving this you should check some of these errors:

1. Number to string cast exception:
This means that a number is wrongly appended to a string in which wrongly cast number into string.
In order to fix this, you will have to use the command as

new DecimalFormat("##,#0.00").format(number).toString()
This will cast your number into two decimal places with the thousand separator.


2. Another error that can be checked is of any other cast errors, or formatting of the data in the report.


Cheers!!


August 17, 2015

February 11, 2015


I wanted to document the process from a long time but due to crunch of time I could not, but now I will like to explain the process in simple easy to follow steps.

First of all I would like to give an idea to problem addressed in the blog, basically when a report runs as a daily status or daily count one need not run it manually it could be scheduled, but when the report is scheduled the export in desired form is exported on jasper server.

But wait a minute do we really login and see what the results came as in the PDF, Excel etc. export, no we need not the problem is handled by mail subscription attached to the scheduler, which will automatically send the Exports to the subscribers on their email accounts and send a confirmation to the administrator.

So lets cut the explanation and lets jump directly into how to do.

Prerequisites -

1. You should have working copy of JasperServer community/pro
2. You should have uploaded a report to the server
3. Choose you favourite text editor  (Windows(default) - Notepad/MacOS(default) - TextEdit)
4. Shut down the jasper server so that no sort of errors come in case of Editing/Saving documents.

after following the above prerequisites now we head on to edit two files as follows.
Both these files will be found at the location
<directory of Jasperserver on Disk>/apache-tomcat/webapps/jasperserver/WEB-INF/

1. js.quartz.properties
   - Edit the file with the Text Editor
 
Change the portion of the document as (Please select your own server details I have used a gmail account )

report.scheduler.mail.sender.host=smtp.gmail.com
report.scheduler.mail.sender.username=testpanda@gmail.com
report.scheduler.mail.sender.password=password
report.scheduler.mail.sender.from= testpand@gmail.com
report.scheduler.mail.sender.protocol= smtp
report.scheduler.mail.sender.port= 587
  - Make the changes and save the file.

2.   applicationContext-report-scheduling.xml

  -  Locate the bean reportSchedulerMailSender
  -  Locate the property javaMailProperties
  -  Do the changes as below - This will enable java to interact the smtp/startls authentication.      

         <props>
                <prop key="mail.smtp.auth">true</prop>
<prop key="mail.smtp.starttls.enable">true</prop>
            </props>
  - Now save the document.

Now the report subscription is ready for run, just start the Jasper Server and you are good to go.

Cheers!!

February 11, 2015

January 20, 2015

In this blog I have explained the steps to import and export the JasperServer Repository (In the steps below I have used a Remote Linux Machines accessed via windows machine)

Before following the steps there would be requirement of following softwares-
1. WinSCP - To browse the files in Linux machine
2. PuTTy - To run the commands for export/import in the Linux shell



Steps Export reports in Jasper Reports

1. Open PuTTy - and key in the IP address 
2. Enter the username and password.
3. Navigate to the folder /opt/jasperreport-server-5.0/buildomatic
4. Run the command  ./js-export.sh --uris <Path of the Report>  --output-dir <Name of the folder to be exported>
5. Open the WinSCP, and key in the  IP Address as well as the credentials and set the Protocol as SFTP .
6. Navigate to the folder /opt/jasperreport-server-5.0/buildomatic
7. Drag and drop the folder created earlier to the local machine.



Steps Import reports in Jasper Reports

1. Open the WinSCP, and key in the  IP Address as well as the credentials and set the Protocol as SFTP .
2. Navigate to the folder /opt/jasperreport-server-5.0/buildomatic
3. Drag and drop the folder downloaded with the report.
4. Now Open PuTTy - and key in the IP address 
5. Enter the username and password.
6. Navigate to the folder /opt/jasperreport-server-5.0/buildomatic
7. Run the command  ./js-import.sh --input-dir <name of the folder copied earlier>

January 20, 2015

Pages

Feedback