Popular Posts

Installing BIRT Viewer server and BIRT report designer

11:46 AM 44 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 :)

44 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
February 10, 2017 at 9:19 AM delete

Thank you so much for this wonderful article really!

sccm asset management
upgrade from ie8 to ie11

Reply
avatar
Unknown
AUTHOR
March 25, 2017 at 6:14 AM delete

www.msoffice365setup.com is www.office.com/setup support for you to enhance ... Call us this 24X7 toll free no 1800-214-7583 and our Microsoft Office setup...Call us this 24X7 toll free no 1800-214-7583 and our Microsoft Office setup assistant will call you and ask the issue right now. www.msoffice365setup.com is MS...MS Office Helpline number AUS, UK Website: www.msoffice365setup.com MS Office Product Key Support Website: www.msoffice365setup.com Toll free Number 1800-214-7583….Office Setup Support I www.office.com/setup I office.com/setup...
And Click Here: http://www.msoffice365setup.com

Reply
avatar
Unknown
AUTHOR
March 6, 2018 at 1:59 PM delete

Norton Support Number provides tech support whenever you meet any trouble. They helped me improve/recover my account settings and most conspicuously, they help you create a strong password so that your Facebook account is safe from easy hacking. One call at Norton Support Number +1-844-821-5790 and your doubts intend to be chalked out.some of the services provided by them:
Facebook Support
Hotmail Support
Email Support
Antivirus Support
HP Printer Support
PayPal Support
Gmail Support
AT&T Support
Support for HP printers
Antivirus Support

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
August 14, 2018 at 12:47 PM delete

Thanks for such articles it really helped me after reading your posts i must say that you are doing awesome work.You've performed a fantastic process in this topic!

Regards-www.office.com/setup

Reply
avatar
PremKishor
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
June 20, 2019 at 11:47 AM delete

Wonderful blog! I found it while browsing on Yahoo News

Regards= office.com/setup

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
Mike Smith
AUTHOR
August 28, 2019 at 12:22 AM delete

Nice one! This post is amazing and very important. Geek squad support Thanks for sharing.

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
September 24, 2019 at 9:24 AM delete

If your fund destroyed from Binance without any information then you contact our Binance customer service and call us our toll-free number +1(855)424-9821 will we solve your problem.
https://www.onesearchpoint.com/binance-support-number
Binance support number

Reply
avatar
September 26, 2019 at 9:03 AM delete


+1-888-330-0764 is the toll-free number you can call this number to solve your problem which comes with Binance account.
https://binancesupportus.blogspot.com/
Binance support number
https://binanceexchange-support-number.blogspot.com

Reply
avatar
Kaitlynjohn
AUTHOR
October 3, 2019 at 8:01 AM delete

Google is known by everyone in the world. Most of the time many people use it to do their activities and instantly they get solutions, Google Play is giving so many apps and guys are using it. Google Play keeps on launching apps but one of them Pay app is making online transactions & transferring money to someone in an easy way while using safe and secure transactions and Google Pay Customer Executive gives you solutions if we have any kind issue regarding Google Pay app. Google Pay Customer Service Number +1-888-330-0764 or you can visit on Website
https://www.onesearchpoint.com/googlepay-customer-service#
Google Pay Customer Service Number

Reply
avatar
October 4, 2019 at 12:27 PM delete

If you have Any issue in your Google Pay like you do not change your password and you do not send money by Google Pay then you can call us toll-free number +1-888-330-0764.here solve your all issue by our Google Pay customer service.
https://www.onesearchpoint.com/googlepay-customer-service
Google Pay Customer Care Number

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
November 5, 2019 at 12:21 PM delete

If you are facing the issues like you did not send money, or incorrect password correction, etc, you can approach Cash App customer service and toll-free Phone Number +1-833-260-7367.
https://www.onesearchpoint.com/cash-app-customer-service/
Cash-App-Customer-Service

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

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

Reply
avatar
Marry Cotson
AUTHOR
December 19, 2019 at 6:45 AM delete

Really it is very great information that you have shared and thanks for sharing the information with us.
Lexmark printer support
Lexmark printer customer service
Lexmark printer technical support

Reply
avatar
Mr. Fix It
AUTHOR
December 20, 2019 at 1:46 PM delete

Looking for Epson Printer drivers then epson.com/connect is best place for you. Visit to get latest & updated drivers for all Epson Printer models.

Reply
avatar
Mr. Fix It
AUTHOR
December 20, 2019 at 1:54 PM delete

Looking for help with Epson Printer issues then call Epson Printer tech Support phone number. Call us to get help & support for all Epson Printer models.

Reply
avatar
Mr. Fix It
AUTHOR
December 20, 2019 at 2:00 PM delete

Looking for help with Malware bytes issues then call Malware bytes tech Support phone number. Call us to get help & support for all Malware bytes related issues.

Reply
avatar
Mr. Fix It
AUTHOR
December 20, 2019 at 2:03 PM delete

Looking for help with Gmail Password recovery issues then call Gmail Password recovery phone number. Call us to get help & support for all Gmail Password related issues.

Reply
avatar
Mr. Fix It
AUTHOR
December 20, 2019 at 2:14 PM delete

You can communicate with McAfee Total Protection Support Number and get hold of problems related to the antivirus program

Reply
avatar
Mr. Fix It
AUTHOR
December 20, 2019 at 2:15 PM delete

Epson Printer Offline issue can hamper your work related to your printer. You can find these issues addressed if you visit the page.

Reply
avatar
Mr. Fix It
AUTHOR
December 20, 2019 at 2:21 PM delete

There can be various problems you can encounter while using your printer and the Epson Printer Offline issue is one of them. You can visit the page and get immediate answers.

Reply
avatar
Mr. Fix It
AUTHOR
December 20, 2019 at 2:29 PM delete

McAfee Tech Support Number is available at all times if you have any queries related to the antivirus program. You can contact the number and find the required solutions.

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
Mazechit
AUTHOR
February 5, 2020 at 2:00 PM delete

Mazenet Technologies is a comprehensive IT service provider for enterprise security solutions, offering a full range of Networking to support business infrastructure. Our 18+ years of expertise in storage optimization, cloud migration, and managed security services have aided the timely delivery of solutions by enhancing operational excellence in clients’ business. IT Infrastructure Service Provider | Managed Infrastructure Service Provider, IT Infrastructure Service | Infrastructure management Service & Network Consulting Service | IT Infrastructure Consulting | Network Consulting Get quote now or contact us : 7397723052.

Reply
avatar
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