Lately i was working in Jasper report so its time for me to share my experience with particular tool.
I did use Xsl-Fo for printing as you can find post here Print from local - xsl-fo
Limitation of using Xsl-fo is when you try to use your local Language fonts in printing(pdf) it will give you something like this ### instead of you'r actual character.
Let's begin our Jasper Report Journey.
First of all you need to download jasper from Jasper Tool.
After successfully downloading it just unzip it you will see the following structure.
Click on bin folder and click on ireport(application).
First thing first we will create report data source
Click on blue round and it will open connections/datasources. We can create new datasource connection-type and.
From above list you can select any datasource connection you want and click next.(be careful what you are selecting)
Give you'r datasource a name. Select JDBC driver you wanted(if you are using Oracle(oracle.jdbc.driver.OracleDriver) and its in RED color format then you need to download war file and upload it in appropriate directory.(restart your ireport tool and you will see RED format colour is gone.
(put file(ojdbc6) in Drive:\iReport-5.1.0\ireport\libs)
Download it from here :ojdbc-for oracle driver
You can give a name to Database Connection.Select jdbc driver from give list of values.
Using JDBC URL you can connect your database environment to ireport tool
Replace below lines with given data
@localhost = your hosting enviornment and database name = Schema name
It's time for testing connection if you inserted all data correctly then you are good to go.
I followed : Dietmar Aust
I did use Xsl-Fo for printing as you can find post here Print from local - xsl-fo
Limitation of using Xsl-fo is when you try to use your local Language fonts in printing(pdf) it will give you something like this ### instead of you'r actual character.
Let's begin our Jasper Report Journey.
First of all you need to download jasper from Jasper Tool.
After successfully downloading it just unzip it you will see the following structure.
Click on bin folder and click on ireport(application).
First thing first we will create report data source
Click on blue round and it will open connections/datasources. We can create new datasource connection-type and.
From above list you can select any datasource connection you want and click next.(be careful what you are selecting)
Give you'r datasource a name. Select JDBC driver you wanted(if you are using Oracle(oracle.jdbc.driver.OracleDriver) and its in RED color format then you need to download war file and upload it in appropriate directory.(restart your ireport tool and you will see RED format colour is gone.
(put file(ojdbc6) in Drive:\iReport-5.1.0\ireport\libs)
Download it from here :ojdbc-for oracle driver
You can give a name to Database Connection.Select jdbc driver from give list of values.
Using JDBC URL you can connect your database environment to ireport tool
Replace below lines with given data
@localhost = your hosting enviornment and database name = Schema name
It's time for testing connection if you inserted all data correctly then you are good to go.
I followed : Dietmar Aust
No comments:
Post a Comment