Skip to main content

Posts

How To: Generating Table Report via JSON data-source in Jasper Report

Recently, I got a chance to generate reports using JSON data source in Jasper Report via Java Spring application. As I was newbie in Jasper Report; I tried to find out tutorials to get started with JSON data source and populate JSON data in table. I thought it will be smooth but its not; you need to do some configuration in JRXML to populate the data fields. In this How - To, I will try to explain how to setup JSON data source and pull data field in iReport (Jasper Report - Report Designer Tool) and then generate a table.   Note: For Java 8 users, refer this link to open iReport http://stackoverflow.com/questions/23902977/ireport-not-starting-using-jre-8 First we create static JSON file student.json: [{"name" : "ABC", "age" : 23, "address" : "11 street", "taking_hostel" : "No"},{"name" : "DEF", "age" : 22, "address" : "1 street", "taking_hostel" : &q
Recent posts

How To: Share Internet from dongle or from LAN cable over Wi-Fi

If you want to share internet from your data card or from your LAN cable over Wi-Fi, then you are in right place. Two small steps are involved in this process:- 1.        Create a Wi-Fi network: We need to create an adhoc network from your laptop from where other devices can connect. In windows (7) there is an option to “create an adhoc network”, you can choose this option and create an adhoc network with password. Sometimes it creates problem if your system can’t handle IP addressing (DHCP) properly. To avoid this, download this  tool which takes care everything, all you need to do provide an adhoc network name and password.   Wi-Fi Adhoc Manager This tool is good and helps in creating adhoc network in windows 8. Microsoft had removed “creating adhoc network” option in windows 8.   2.        Enable Internet Connection Sharing: After that open “Network and sharing center”, there you able to see data card or LAN cable connection. Click on that network, you will

How To: Automate MS Excel

MS Excel, sometimes we got some task which is time taking and require good manual effort. To automate these kind of task and making our life easy there are two ways - 1) Macro - MS Excel provide Macros functionality to automate tasks in Excel. We can record our steps ( go to 'View' tab then Record Macro) then run this recorded Macro to perform the same task again. It will be good if you know VB Scripting to write general algorithm Macros. 2) Python - Python has excel API xlrd and xlwt for reading and writing Excel documents. Python is easy to use and you can code easily as compare to VB Scripting. With Python Excel API we can easily automate the excel task. I) Setup the environment - Download Eclipse  - Eclipse is a Intergrated Development Environment in which we can easily write code. Download Python . Download Python Excel API . Open Eclipse - then go to Help menu bar - then Eclipse Marketplace Search pydev and install the Pydev - Python IDE for Eclipse  Afte