Skip to main content

Post 8: iReport: Using dynamic titles that can change during report processing: Part-2

Create a table named CustomerInvoices
Following steps will help you create a table named CustomerInvoices with five columns (InvoiceID, CustomerName, InvoicePeriod, ProductName, and InvoiceValue).
You need to follow the procedure described below to create a database instance, create table, and copy sample data in it.

Run SQL Shell
Click PostgreSQL 9.3 -> SQL Shell (psql), from Programs menu of your Windows installation, to run SQL Shell for PostgreSQL server.



You will see SQL Shell consol window. SQL Shell window will prompt you for server location, database, port and username, press Enter for each prompt.You will be logged to postgres database. 
 
Create Database instance
Copy following SQL command in SQL shell to create a database instance.
-> CREATE DATABASE jasperdb1;


Your jasperdb1 database instance will be created.
Now follow the steps in next section to copy data in the jasperdb1 database.

Comments

Popular posts from this blog

Index: JSF

Java Server Faces Basics Post 1: JSF : Introduction to JSF  Post 2: JSF:  configuration files  Post 3: JSF: Installation Post 4: JSF: Your first JSF project   Standard JSF Tags Post 1: JSF: textbox example Post 2: JSF: password example Post 3: JSF: textarea example JSF 2 GraphicImage Example Post 4: JSF: GraphicImage Example Post 101 : JSF : The valueChangeListener Attribute Example

Index: iReport

iReport for Java ------------------------------------------------------------ Titles and Headers ------------------------------------------------------------ Post 1: iReport : Downloading, installing, and running JasperReports and iReport Post 2: iReport : Creating your first "Hello World" report   Post 3: iReport : Understanding iReport Elements Post 4: iReport : Creating and sizing the title for your report Post 5: iReport: Inserting a company logo in the title of your report  Post 6: iReport : Installation of PostgreSQL Post 7: iReport : Creating a report from relational data Post 8: iReport : Using dynamic titles that can change during report processing. Post 9: iReport : Adding a simple header to your report Post 10: iReport : Setting margins for your report and aligning the report header relative to report margins  ------------------------------------------------------------ Body and Footer ---------------------------------------------------------...