Popular Posts

Installing BIRT Viewer server and BIRT report designer

11:46 AM 20 Comments A+ a-

If you want to use BIRT reporting as alternative to Microsoft SSRS you can easily do it by instaling BIRT on any linux distro. There are several tricks you have to do before everything will be fine. We will show you how to install BIRT Eclipse designer, BIRT Runtime server with apache 2 and tomcat 7 and how to add mysql JDBC driver to Eclipse so you can add dataset to BIRT reports and connect to data.

First you must download Eclipse IDE, you can download it from here:http://download.eclipse.org/birt/downloads/

Choose All in one
On the same page you can download BIRT runtime, runtime is important because apache and tomcat use birt runtime to run your reports like SSRS and it is like BIRT Report Viewer.
Here is link(I recommend you to go to main web page and download latest): http://www.eclipse.org/downloads/download.php?file=/birt/downloads/drops/R-R1-4_2_1-201209181113/birt-runtime-4_2_1.zip


Also download Latest BIRT Runtime



After you download package extract it somewhere on your disk so you can easily access it later.

Now download MySQL JDBC driver for Eclipse and Java so you can make connection to MySql database. Here is link: https://www.mysql.com/downloads/connector/j/

Download JDBC MySQL driver


Now install apache2 and tomcat7 on your Linux distro. Here we use Ubuntu derivate Lubuntu 12.10. But the same thing is for Mint, Snow, Lubuntu, Kubuntu, Xubuntu, Ubvuntu Server and versions Ubuntu 10.10 , Ubuntu 10.04 LTS, Ubuntu, 11.04, Ubuntu 11.10, Ubuntu 12.04, Ubuntu 12.10....

Installing in Synaptic






When you finished installing apache and tomcat you must configure it.
Open /etc/tomcat7 folder and open file tomcat-users.xml with root permisions.





Open it in some text editor, remmember that you must be root to edit this file!
Uncomment lines on botton and add selected roles to your user.
In file tomcat-users.xml go to bottom and you will see default users config commented. Uncoment it , add your users and add roles to your admin user. Add this roles: manager-gui, manager-script, manager-jmx, manager-status.

Then restart tomcat. Enter command: sudo service tomcat7 restart


Now go to http://localhost:8080/manager/html and enter password you entered in tomcat-users.xml file. DON'T enter localhost instead localhost:8080 because tomcat runs only on localhost:8080. You can change that later of course but that is default. 

Click "Choose File"

Choose birt.war in folder of BIRT runtime
Then click "Deploy" to deploy BIRT Viewer nad make it active.


You can see BIRT installed when you refresh localhost:8080/manager/html

Copy WebViewerExample to /var/lib/tomcat7/webapps/ROOT

When you copy WebViewerExample to /var/lib/tomcat7/webapps/ROOT, RENAME folder  to birt.



Now open http://localhost:8080/birt and then click View Example. It should display you something like this:
BIRT Report Example


























Now open Eclipse from the location where you extracted it, you don't have to install it , just run the file eclipse. After that Go to File-> New->Other...


Choose Bussines Intelligence and Reporting Tools , and then Report Project











Click on button in right upper corner

Choose MySQL JDBC Driver Version 5.1
Click "Edit JAR/Zip"

Choose mysql-connector-java you downloaded and extracted previously at begining of this tutorial


Set connection string to database


.... now design report and enjoy :)

20 komentari

Write komentari
mac
AUTHOR
April 17, 2013 at 9:58 AM delete

This is the latest link to download eclipse with BIRT - http://www.eclipse.org/downloads/packages/eclipse-ide-java-and-report-developers/junosr2

Reply
avatar
suresh666
AUTHOR
December 9, 2016 at 7:34 AM delete

thank you for offering such a nice content.very useful blog for learnesrs .easy to understand.very unique content.one of the recommanded blog

Birt report Online Training

Birt report Online Training in hyderabad

Reply
avatar
Unknown
AUTHOR
May 21, 2018 at 9:54 AM delete

Hi There,

In debt to you for making my learning on the Linux migration tutorials area so hassle-free! I lay my faith on your writings.
I recently encountered Linux Ubuntu and I am in love! I also love how much helpful information there is out there, and how helpful the community is out there as well!
Now here's the problem: I format a partition using Ubuntu, I install Ubuntu onto that partition, Ubuntu tells me that it's been successfully installed. However, when I re-boot, it won't boot from HDD.
I am so grateful for your blog. Really looking forward to read more.

MuchasGracias,
Preethi.

Reply
avatar
Unknown
AUTHOR
May 22, 2018 at 2:23 PM delete


Hello There,

Thanks for highlighting this and indicating about Linux migration tutorials where more study and thought is necessary.


im new to linux and i need help with a couple of things. i have linux 12 by the way.
i just need to know, what is the alterate to notepad on linux?
i need more things but ill post them in this thread when i get home if i need anything.

Very useful article, if I run into challenges along the way, I will share them here.


Cheers,

Radhey

Reply
avatar
Smith John
AUTHOR
February 25, 2019 at 1:17 PM delete

Hi there thanks for sharing with us. looking for how to uninstall Avast from your PC? visit this link https://www.how-to-uninstall.us/avast/

Reply
avatar
July 15, 2019 at 8:39 AM delete

Our Amazon Customer Support Team is Available 24x7. Call us +1-855-424-9807 for tech support for Amazon Support Number. Not able to fix tech issues of Amazon Service due to not having the correct help out.
https://www.optcustomerservice.com/amazon-customer-service-number.html
Amazon Support Number

https://www.optcustomerservice.com/amazon-customer-service-number.html

Reply
avatar
July 17, 2019 at 10:58 AM delete


If you have Any issue in your Cash App like you do not change your password and you do not send money by cash app then you can call us toll-free number +1-855-504-2121 here solve your all issue by our Cash App customer service.
https://www.optcustomerservice.com/blog/why-is-cash-app-being-scammed/

Reply
avatar
Unknown
AUTHOR
August 6, 2019 at 2:17 PM delete

Nice blog, it so gripping and communicative post. If you are facing any kind of problems associated with , Brother Printer Support, then you may go to our website or call us our Brother Printer Support . Thanks
epson printer offline

Reply
avatar
September 2, 2019 at 1:02 PM delete

If your fund destroyed from coinbase without any information then you contact our coinbase customer service and call us our toll-free number +1(855)-504-2315 will we solve your problem.
https://classifieds.panbo.com/viewlisting.php?view=688
Coinbase Support Number

Reply
avatar
Jessica Smith
AUTHOR
September 19, 2019 at 3:32 PM delete

Enjoyed reading the article above , really explains everything in detail,the article is very interesting and effective.Thank you and good luck for the upcoming articles. For More, Visit: Epson Printer in Error State Issue

Reply
avatar
willsion
AUTHOR
October 6, 2019 at 10:56 AM delete

Your blog is very informative, meaningful and to the point. Being a technical support blogger. I find you have a very good writing sense due to which you explain details about technical support perfectly, for more exploring your knowledge about Support For HP Printer | Number +1-877-760-6133, HP Printers Support | HP Printers Support Number
error code 0x803c010b

Reply
avatar
December 5, 2019 at 11:55 AM delete

Performed the installation as advised. Everything runs smoothly, thanks!

Reply
avatar
January 3, 2020 at 11:07 AM delete

#AriesRashifal2020, #TaurusRashifal2020, #GeminiRashifal2020, # CancerRashifal2020, #LeoRashifal2020, #VirgoRashifal2020, #LibraRashifal2020, #ScorpioRashifal2020, #SagittariusRashifal2020, #CapricornRashifal2020, #AquariusRashifal2020, #PiscesRashifal2020
#meshrashifal2020, #vrshabhRashifal2020, #mithunRashifal2020, #karkRashifal2020, #singhRashifal2020, #kanyaRashifal2020, #tulaRashifal2020, #vrshchikRashifal2020, #dhanuraashiRashifal2020, #makarRashifal2020, #kumbhRashifal2020, #meenRashifal2020
Regarding form: Astroindusoot
Information website: https://astroindusoot.com/dailyhoroscope
Call & What’s App No On +91-9068311666.

Reply
avatar
Brucehank12
AUTHOR
April 17, 2020 at 5:48 PM delete

Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with more information? It is extremely helpful for me. Error Code 0xc0000034

Reply
avatar
August 26, 2020 at 10:19 AM delete

Nice Post!
Simply enact the YouTube on Roku gadgets which is truly basic as it just builds up a couple of moment’s minutes to the arrangement. On the off chance that you need to initiate YouTube on the screen simply sign in to the record from youtube.com/activate. You will sign in to the record from YouTube.com/activate and enter a digit to the Roku interface.

Reply
avatar
Anonymous
AUTHOR
March 30, 2022 at 1:30 PM delete

Installing Birt Viewer Server And Birt Report Designer - Linux Migration Tutorials >>>>> Download Now

>>>>> Download Full

Installing Birt Viewer Server And Birt Report Designer - Linux Migration Tutorials >>>>> Download LINK

>>>>> Download Now

Installing Birt Viewer Server And Birt Report Designer - Linux Migration Tutorials >>>>> Download Full

>>>>> Download LINK

Reply
avatar