Planet Jaspersoft

Filter by tags:

September 8, 2015

Hi Folks,

Below explained tip is very useful for getting images(usually logos of companies/clients) when exporting reports to Excel(Excel Paginated).

Software used to test this tip : Jasper Design Studio Pro 6.1 and Jasper Server 6.01 Pro
1) Click on the Report Name in outline section. (Highlight the report name).
2)  Go the properties and from the list of drop down choose
net.sf.jasperreports.export.xls.ignore.graphics
3) By default above property value is true
4) Make it false i.e,
net.sf.jasperreports.export.xls.ignore.graphics = false

Find the image below for quick understanding.


Sample output : Excel Export



Reference :
http://community.jaspersoft.com/wiki/no-images-xls-export
http://jasperreports.sourceforge.net/sample.reference/xlsfeatures/

:-) :-)  
 

September 8, 2015

August 27, 2015

Hello Readers,

This post will teach you how to install latest TIBCOJaspersoft 6.1 Professional in Ubuntu 15.04 server and access it from client machines like Mac, Windows.

I had already published a post earlier on installation  procedure on Ubuntu ( you can find here http://jasper-bi-suite.blogspot.in/2014/02/installation-of-jasper-server-55-pro-in.html)

Though the installation steps would be the same, the approach & the environment setup is completely different.

Environment : 
1) Server machine ( Ubuntu 15.04 - 64 bit)
2) Client machines ( Windows 10 -  64 bit -Developers/Users can access the jasperserver installed on                                   Ubuntu server locally).
3) I used my local machine for Server and Client machines where I installed VMware 10.0.1 and installed Ubuntu 15.04 server (not desktop ubuntu )  as Guest and used my regular windows 10 as Host.
4) Web browsers - Microsoft Edge

Now follow below steps if you are looking for the same setup in your local environment or for your office environment.


Quick Steps
1) Identify Ubuntu server CPU type (64 bit or 32 bit).
2) Check 8080 opened in Ubuntu server or not. If not opened, open it
3) Create a folder in Ubuntu server directory and download the Jasperserver software and apply chmod 777 command for downloaded file.

4) Install the Jasperserver software
5) Check the VMware internet routing between Host(Windows 10)  and Guest(Ubuntu).
6) Access the Jasperserver in Microsoft Edge browser in Windows 10.


Steps Explained in detail :

1) Identify Ubuntu server CPU type (64 bit or 32 bit)

    #  Type uname -m command on terminal
    #  Check the OS is 64 or 32 bit

2) Check 8080 opened in Ubuntu server or not. If not opened, open it

    # Type netstat -an | grep 8080| grep LISTEN on terminal
    # If it returns nothing, that means you can use 8080 (If it been used by any other server, hmmm
        take network admin help or google(my approach) ).

    A Quick snapshot on above 2 points


3) Create a folder in Ubuntu server directory and download the Jasperserver software and apply chmod 777 command for downloaded file. 

   # Create a folder to keep the software (lets say "jasper" )

   # Download the jasperserver using wget command.
    Example :
   wget https://community.jaspersoft.com/modal_forms/nojs/jf-user-login-register?optoutdest=https://d2ev2buidpvgfo.cloudfront.net/6.1/Installers/jasperreports-server-6.1.0-linux-x64-installer.run

   # Once the download is completed apply chmod 777 command
   Example
     chomod 777 *.run
     



4) Install the Jasperserver software

 # Use below command to install the Jasperserver
 # Example :
    ./ jasperreports-server-6.1.0-linux-x64-installer.run


# Follow the on screen steps, accept the licence, click on continue to agree the licence terms and click on Y(yes) or enter till you get the progress ( in #####) of installation.
# Choose full or custom installation options (1 or 2)




5) Check the VMware internet routing between Host(Windows 10)  and Guest(Ubuntu).

# On the Menu bar go to VM -> Settings and then click on "Network Adapter" in HardwareTab
# Check "NAT" option and check "Connected" and "Connect at power on" in Device status.
# Check the ip address of Ubuntu (Guest in our case) using "ifconfig" command on the terminal.



6) Access the Jasperserver in Microsoft Edge browser in Windows 10.
   
   #  Be in Host machine (windows 10) and open Microsoft Edge browser
   # call the Jasper server URL and login with superuser/superuser credentials
   #  Example : http://192.168.1.128:8080/jasperserver-pro/





We are done ...!!!

Did you find it useful ? Share it for other community folks...!!!

Cheers.!

Regards
Sadakar Pochampalli

August 27, 2015

August 26, 2015

Hi Folks,

Are you looking to understand, learn and work on Jasper Servers server side reporting ?
Here you go ! Find the content and samples slides in below images & ask for a demo/knowledge transfer session.

Software used : 
TIBCOJaspersoft 6.1 Professional
Postgresql foodmart database

NOTE : Click on images to get the best view of content placed.


Agenda 
 Sample Slides 





Lets connect and learn together - The Enterprise features of TIBCOJaspersoft 6.1 :-) :-) 

Thank you for your time on this page.!

Cheers!
Regards,
Sadakar Pochampalli

August 26, 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

July 31, 2015

June 23, 2015

Hello All!!! Was bit busy with my work and could not find much time to do this. But this made […]

June 23, 2015

June 22, 2015


Click images to get better view of the content

Core Jasper Design Studio reporting concepts + Advanced Jasper Designer reporting concepts.

Construction of full content in progress. 





Samples :





June 22, 2015

June 17, 2015


Download Link : https://community.jaspersoft.com/project/jasperreports-server/releases

Landing Page of 6.1 CE : ( New features in community : Left side of image)

Home Page : 
Jaspersoft Editions comparison :  http://www.jaspersoft.com/editions

Jaspersoft CE capabilities : 





:-)

June 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

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

Pages

Feedback