Planet Jaspersoft

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

June 3, 2015

A theme is the set of CSS (Cascading Style Sheets) and associated images that define the appearance of the Jaspersoft user interface, in this tech talk you'll learn how to create your first theme, some tips and tricks and more.

June 3, 2015

A theme is the set of CSS (Cascading Style Sheets) and associated images that define the appearance of the Jaspersoft user interface, in this tech talk you'll learn how to create your first theme, some tips and tricks and more.

June 3, 2015

The rise of the cloud and multi-tenanted databases is a popular topic today when it comes to building new applications and services. When it comes to Business Intelligence there are some special considerations to make. In this tech talk we explore the main models for multi-tenant databases and how to provide secure access to them within Jaspersoft. Two demos are shown. For more Jaspersoft Tech Talks, see: www.jaspersoft.com/tech-talks

June 3, 2015

The rise of the cloud and multi-tenanted databases is a popular topic today when it comes to building new applications and services. When it comes to Business Intelligence there are some special considerations to make. In this tech talk we explore the main models for multi-tenant databases and how to provide secure access to them within Jaspersoft. Two demos are shown. For more Jaspersoft Tech Talks, see: http://www.jaspersoft.com/tech-talks

June 3, 2015

Are you running Jaspersoft in a production environment? Monitoring is a critical function to make sure that your application is both up and running and available to its users. This Tech Talk covers common monitoring philosophies and shows how to monitor Jaspersoft with Icinga/Nagios and New Relic.

June 3, 2015

Are you running Jaspersoft in a production environment? Monitoring is a critical function to make sure that your application is both up and running and available to its users. This Tech Talk covers common monitoring philosophies and shows how to monitor Jaspersoft with Icinga/Nagios and New Relic.

June 3, 2015

May 20, 2015

The rise of the cloud and multi-tenanted databases is a popular topic today when it comes to building new applications and services. When it comes to Business Intelligence there are some special considerations to make. In this tech talk we explore the main models for multi-tenant databases and how to provide secure access to them within Jaspersoft. Two demos are shown. For more Jaspersoft Tech Talks, see: http://www.jaspersoft.com/tech-talks

May 20, 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