In Report Generation having 2 Components Jasper Reports , iReport. Jasper Reports Its Reporting engine and Report compiler, they Export result in Various types PDF, HTML, XLS, CSV, XML, RTF, TXT They also support Various data source types JDBC, EJB, POJO, Hibernate, XML. Jasper report Integrated with charting Its extension .jrxml for jasper report definition , .jasper is complied file format iReport iReport awareness can open both formats Step1: Choose Report Template open a new file then open one popup window there is five option like Report, Style, Chart theme ,Resource bundle, other file type Report wizard Its used to display values from data source that is refer or imported from database or xml file Style wizard Its used to define one or more styles, its to generate customized element Chart theme Its used to select various type of chart like 2D or 3D Application Resource bundle It is text document ,it used to translation for string Other file type Its used to run common file wizards Step 2: Name and Location Give Report name and file location, in file location can be changeable and final one is file path Step 3: Query Choose connection or data source , suppose there is no Query then Press New button to create Connection or database After select Query type then write a SQL Query ,Design SQL Query and Load SQL Query Step 4: Fields After Query execute result fields are shown in left side panel and then you can select Specified fields through Selection button ,selected fields are displayed in Right side Step 5: Group by Select Group by Result value in specified any fields Step 6: Finish Finial Step just press Finial Button then generation report
Difference between windows and linux
1. Linux is free. Windows are not free we have to pay.
2. Linux has high security than the window.
3. Linux is customizable but window is not.
4. Window is user friendly than Linux.
5.Windows allow user to store data in any where but linux allow to store in home directory . So taking backup is easy in linux.
6. Windows should boot from first hard disk but linux boot fron any hard disk in computer.
7. Network features are good in linux than windows.
8. Windows are based on DOS and Linux are based on Unix.
What do we do usually during boring lectures or when lectures are off? We play games on our multimedia cell phones. As cell phones are becoming more and more powerful and as number of phone and PDA users are increasing, a new software industry of mobile programming is on rise. Developing new applications for cell phones and converting applications to make them suitable for handheld devices is the main work area in this industry. But this field is not limited to big IT firms, any engineering guy can start studying mobile programming related languages like Java ME or Android and start developing games and applications without of much setup.
In old days of mobile computing, all manufacturers had their own platform for programming. But recently, Sun has come up with some common platform for handheld mobile devices which is now widely accepted by all major phone manufacturers. This is called as MIDP (Mobile Information Device Platform). The phones which support this platform are the ones which are 'java enabled' or 'WAP enabled'. To develop application in this platform, one needs to have JDK with J2ME (Java 2 Micro Edition) with WTK (Wireless Tool Kit). It can be downloaded from http://java.sun.com. To test our application on our computer, emulators for particular cell phones are available. Emulators are those which gives exact look and feel of a cell phone in which your application is run and from this, you will get to know that is your application performing correctly, does its user interface looking cool and others.These emulators can be downloaded from 'Club Nokia'. emulators for LG and Samsung are available at http://www.dadp.com
Once all these softwares are acquired, you can start writing java class file in any text editor , if you don't have an Eclipse software installed on your machine. This java code follows the same life cycle concept as the java applet, but this particular java code is known as java MIDlet. Once you are done with your java files, you will be able to compile them through Wireless Tool Kit toolbar. Once compiled these files , then you can run your code on any emulators of your choice, provided your code is error and warning free. You will be able to see actually the cell phone and the program running on its screen with full keypad support.
To be able to download your application on your real cell phone, the best possible way is to upload your program on WAP server. Many WAP servers are available for free where you can try this out.
- Hi Friends,
- Here we can learn How to record the macro in Excel.
-
Step1: On the Toolbar Click Tool
Step2: On the Tool menu -> Click Macro -> Record New Macro
Step3: After You Click Record New Macro. You can able to see this 'Record macro' Window. In this window we can Enter Macro name and description of macro.
Step4: Click Ok Button in Record Macro Window . Then you will see icon.
Step5: Then You can start Record by entering the data in excel sheet cell or performing some fuctions.
Step6: Once you finished the task. Then stop the recording marco by Click 'stop recording' icon.
Step7: View the macro code by clicking the Tool Menu -> Macro -> Visual Basic Editor
Step8: Then Visual Basic Editor window will open.
Step8: To View Macro Code Click Module - > Double Module1
These are the steps to Record Macro.
Database Design is very essential for all Softwares. We Know that database is used to store data.
Database is known as collection of tables. Table is collections of fields.
Primary key is used in tables to make the field unique and avoid repetation. The table should have only one primary key.
To design the database we are using Normalization. Normalization is used to remove repetations and increases the clarity in organizing data in a database.
There are 5 rules in normalization. They are
-
1st Normal Form - Each column type should be unique to eliminate duplication.
-
2nd Normal Form - Use 1st normal form and then remove subsets of data that apply to multiple rows of a table and place them in separate tables. Create relationship between tables.
-
3rd Normal Form - Use 2nd normal form and then delete column that are not dependent on primary key
-
4th Normal Form - Use 3rd normal form and check it has multi-value dependencies.
-
5th Normal Form - Use 4th normal form and check it should not have cyclic dependencies in a composite key
For more details and information we see the following site
http://en.wikipedia.org/wiki/Database_normalization
http://databases.about.com/od/specificproducts/a/normalization.htm
http://www.devshed.com/c/a/MySQL/An-Introduction-to-Database-Normalization/
More Articles …
Page 9 of 13