Tuesday, August 21, 2012

SQL Joins Graphical Illustration



http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

Oracle Toad database configuration

# tnsnames.ora Network Configuration File: C:\Oracle\product\11.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

CONFIGNAME=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=192.162.129.141)
        (PORT=1521)
      )
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=192.165.119.161)
        (PORT=1521)
      )
    )
    (CONNECT_DATA=
      (SERVICE_NAME=ServiceName)
    )
  )

In Oracle Toad, it needs to configure Toad to connect to Oracle database. Store "tnsnames.ora" file at "C:\Oracle\product\11.2.0\client_1\network\admin\" directory. Then connect via Oracle Toad.

Wednesday, August 8, 2012

Jasper subreport duplicate values

When you printing a collection of data, you have to use a subreport to print data.

There are parameters, that you can use to customize your printing.

But, default parameters set subreport to print duplicate values. To avoid that change following parameters as mentioned below.

In subreport component,

Print When Detail Overflows true
Stretch Type Relative to Tallest Object

In the components inside the subreport,

Print Repeated Values true
Remove Line When Blank  false
Print In First Whole Band         false
Print When Detail Overflows false
Blank When Null    true
Stretch With Overflow true
Stretch Type Relative to Tallest Object

This changes works fine in both iReport 3.5 & 3.7 versions.