StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8832651
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-01-12T09:26:27.080
FavoriteCount
0
LastActivityDate
2012-10-02T08:08:56.507
LastEditDate
2012-10-02T08:08:56.507
LastEditorUserId
876298
OwnerUserId
876298
ParentId
8831747
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<blockquote> I need an editor to create some reports, all reports have header (company name, address, phone, image) that is read from a table called companies and have a detailed, example all customers of the company. How could i do this in iReports? </blockquote> You can look at <a href="http://jasperreports.sourceforge.net/sample.reference.html" rel="nofollow noreferrer">this samples</a>. The <a href="http://sourceforge.net/projects/jasperreports/files/jasperreports/JasperReports%204.5.0/" rel="nofollow noreferrer">JasperReports distribution package</a> contains many others samples (in folder %jasperreports%\demo\samples). The iReport has also several samples in folder %iReport%\ireport\samples. Your sample report is very simple. The steps for creating the such report can be like this: <ol> <li>Adding image element (with company logo) and several (or one) staticText elements (with company contact information) to the Title band.</li> <li>Adding query (for getting data from MySQL DB) with fields (idClient, name, address in your sample)</li> <li>Adding staticText elements with columns header to the Column header band - it will be the columns header for data grid</li> <li>Adding textField elements with fields to the Detail band - it will be the data in grid</li> </ol> You should read the <a href="http://jasperreports.sourceforge.net/JasperReports-Ultimate-Guide-3.pdf" rel="nofollow noreferrer">JasperReports Ultimate Guide</a>. It is a great tutorial. The sample jrxml file (designed in iReport): <pre class="lang-xml prettyprint-override"><code><?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="sample_company" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <queryString> <![CDATA[SELECT idClient, name, address FROM customers_table]]> </queryString> <field name="idClient" class="java.lang.Integer"/> <field name="name" class="java.lang.String"/> <field name="address" class="java.lang.String"/> <title> <band height="108" splitType="Stretch"> <staticText> <reportElement x="171" y="53" width="183" height="55"/> <textElement textAlignment="Center" verticalAlignment="Middle" markup="styled"/> <text><![CDATA[<style isBold="true" forecolor="blue">ABC COMPANY</style> Main Avenue and 9th Street Tel: (593) 4 - 2066765 e-mail: info@abc.com]]></text> </staticText> <image> <reportElement x="245" y="3" width="41" height="50"/> <imageExpression><![CDATA["abc_logo.png"]]></imageExpression> </image> </band> </title> <columnHeader> <band height="20"> <staticText> <reportElement x="11" y="0" width="160" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Id Client]]></text> </staticText> <staticText> <reportElement x="171" y="0" width="183" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Name]]></text> </staticText> <staticText> <reportElement x="354" y="0" width="172" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Address]]></text> </staticText> </band> </columnHeader> <detail> <band height="20" splitType="Stretch"> <textField> <reportElement x="11" y="0" width="160" height="20"/> <box leftPadding="10"/> <textElement/> <textFieldExpression><![CDATA[$F{idClient}]]></textFieldExpression> </textField> <textField> <reportElement x="354" y="0" width="172" height="20"/> <box leftPadding="10"/> <textElement/> <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression> </textField> <textField> <reportElement x="171" y="0" width="183" height="20"/> <box leftPadding="10"/> <textElement/> <textFieldExpression><![CDATA[$F{address}]]></textFieldExpression> </textField> </band> </detail> </jasperReport> </code></pre> The result will be (the report exported to pdf format): <img src="https://i.stack.imgur.com/11ZjG.png" alt="The report in PDF format"> UPDATE: For filling header with company info you can use the Group band. You can read info about groups <a href="http://jasperreports.sourceforge.net/sample.reference/jasper/index.html#groups" rel="nofollow noreferrer">here</a>. You query will be like this: <pre class="lang-sql prettyprint-override"><code>SELECT c.idClient, c.name, c.address, cmp.name AS companyName, cmp.contactInfo, cmp.id AS idCompany FROM customers c, companies cmp WHERE cmp.id=c.idCompany SORT BY cmp.id </code></pre> You should also add report's fields for data from <code>companies</code> table (<code>companies.name</code>, <code>companies.contactInfo</code>, <code>companies.id</code>, for example): <pre><code> <field name="companyName" class="java.lang.String"/> <field name="contactInfo" class="java.lang.String"/> <field name="idCompany" class="java.lang.String"/> </code></pre> After that you should add group by <code>idCompany</code> (the unique key from <code>companies</code> table). And then put the textField elements with fields (<code>companyName</code>, <code>contactInfo</code>) to the Group band.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHeaders and details from database tables
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USAlex K
UserOwnerUserId
1. USAlex K
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COThanks Alex, but the header is not static text, the header and detail are dinaymic with information from database tables
 singulars
 PostPostId
 PO
 UserUserId
 USNestorInc

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.