techmaddy.com

• Output in PDF, RTF, XML, XLS, CSV, HTML, XHTML, text, DOCX or OpenOffice.
• Reports can include Graphs also, Renders through JFreeChart
• The Type of charts are Pie, Bar, Stacked Bar, Line, Area, Scatter Plot, Bubble, and Time series
• Advanced Flash based visualization with mapping, animation, and improved interactivity^*
• Various forms of DataSources like JDBC, XML, POJO, EJB, MDX, CSV and custom
• Seperate Extensions to support Oracle PL/SQL
• Scriptlets which the report definition can invoke at any point to perform additional processing. The scriptlet is built using Java, and has many hooks that can be invoked before or after stages of the report generation, such as Report, Page, Column or Group.
• Sub report, where in the for drill down analysis
• Crosstabs, for Dynamic Columns in the report

• iReport - An Open Source jasper report designer and maintained by Jasper soft. This was designed by the jasper report developers. It provides most extensive options to design the jasper report.
• DynamicReports - Yet another open source report designer for jasper reports.
• WebReportBuilder,an open source Java EE web application that allows web based developers and non developers to create basic and advanced Reports based on JasperReports to be used as a Web Report Server
• And it can be easily integrated to popular IDE’s like Eclise and Netbeans for report design. There are plugins available for these IDE’s.

• <jasperReport> – the root element.
• <title> – its contents are printed only once at the beginning of the report
• <pageHeader> – its contents are printed at the beginning of every page in the report.
• <detail> – contains the body of the report.
• <pageFooter> – its contents are printed at the bottom of every page in the report.
• <band> – defines a report section, all of the above elements contain a band element as its only child element.
All of the elements are optional, except for the root jasperReport element.

<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="DBReport" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<queryString>
		<![CDATA[SELECT
     tblbm_issuedetails.`issue_number`,
     tblbm_issuedetails.`issue_createddate`
FROM
     `tblbm_issuedetails` tblbm_issuedetails]]>
	</queryString>
	<field name="issue_number" class="java.lang.String"/>
	<field name="issue_createddate" class="java.sql.Timestamp"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="38" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="200" height="38"/>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="24"/>
				</textElement>
				<text><![CDATA[My First DB Report]]></text>
			</staticText>
		</band>
	</title>
	<columnHeader>
		<band height="20" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="100" height="20" isRemoveLineWhenBlank="true" backcolor="#D4D0C8"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Tahoma" isBold="true"/>
				</textElement>
				<text><![CDATA[Issue Number]]></text>
			</staticText>
			<staticText>
				<reportElement x="100" y="0" width="100" height="20" isRemoveLineWhenBlank="true" backcolor="#D4D0C8"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Tahoma" isBold="true"/>
				</textElement>
				<text><![CDATA[Created Date]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="21" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="100" height="20" isRemoveLineWhenBlank="true"/>
				<textElement>
					<font fontName="Tahoma"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{issue_number}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="100" y="0" width="100" height="20" isRemoveLineWhenBlank="true"/>
				<textElement>
					<font fontName="Tahoma"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{issue_createddate}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>

1. Create a User DSN in Administrative Tools -> Data Sources (ODBC)
2. Set-up the ODBC Bridge Details for Oracle. These two steps creates the DSN for you.
3. Go to DataBase -> Reverse Engineer in Visio.
4. In Reverse Eng Wizard -> Select the Appropriate Installed Visio Drivers -> Setup
5. In ODBC Generic Driver Setup -> Select your associated Drivers and Select the DSN also
6. In Reverse Eng Wizard -> Select the DSN added -> Next
7. In Reverse Eng Wizard -> Select the Objects to Reverse Engineer -> Next
8. In Reverse Eng Wizard -> Select the table to Reverse Engineer -> Finish