Reporzng Soluzons for Oracle APEX

62 Pages·2014·11.64 MB·English

Repor&ng
 Solu&ons
 for
 Oracle
 APEX
 -­‐

Choose
 Your
 Weapons

Dietmar
 Aust

Opal-­‐Consul&ng,
 Köln

www.opal-­‐consul&ng.de
Vorstellung
 Opal
 Consul&ng

► Building
 Oracle
 based
 Web
 Applica&ons
 since
 1997

▪  Portal,
 Forms,
 Reports,
 OWA
 Toolkit,
 now
 APEX!

► Dipl.-­‐Inform.
 Dietmar
 Aust,
 Freelance
 Consultant

▪  Master's
 Degree
 in
 Computer
 Science
 (MSCS)

► 1997-­‐2000:
 Consultant
 at
 Oracle
 Germany

► Since
 09/2000:
 Freelance
 Consultant,
 Since
 2006
 –
 APEX

only!

► Blog:
 h[p://daust.blogspot.com/

► Regular
 presenter
 at
 Oracle
 conferences
 (ODTUG,
 DOAG,

OOW)

► Author
 of
 the
 JasperReportsIntegra&on
 toolkit

▪  h[p://www.opal-­‐consul&ng.de/tools

Reporting Solutions for Oracle APEX 25.03.2014 Page 2
Major
 Use
 Cases

Reporting Solutions for Oracle APEX 25.03.2014 Page 3
Major
 Use
 Cases

1.
 Standard
 Repor&ng

Reporting Solutions for Oracle APEX 25.03.2014 Page 4
Major
 Use
 Cases

1.
 Standard
 Repor&ng

► What
 is
 it
 /
 Examples?

▪  Crea&ng
 Invoices,
 Order
 Confirma&ons,
 Contracts

▪  Management
 reports
 /
 dashboards
 /
 charts

► Characteris&cs

▪  Client-­‐independence,
 can
 possibly
 be
 downloaded
 from
 your
 website

▪  Not
 easily
 modifyable

▪  Need
 pixel
 perfect
 layout
 /
 corporate
 design

▪  Fixed
 layout,
 infrequent
 changes

▪  Generate
 as
 BLOB,
 can
 be
 stored
 in
 the
 database
 together
 with
 the

client
 /
 order
 entry,
 etc.

Reporting Solutions for Oracle APEX 25.03.2014 Page 5
Major
 Use
 Cases

2.
 Flexible
 Repor&ng

► What
 is
 it
 /
 Examples

 -­‐
 two
 situa&ons:

1.  Genera&ng
 a
 MS
 Word
 document
 for
 further
 modifica&on
 (e.g.
 flexible

customer
 communica&on),
 E.g.
 flexible
 offer
 crea&on
 where
 you
 need
 to

add
 calcula&ons
 from
 MS
 Excel
 or
 add
 images,
 etc.

2.  The
 template
 does
 already
 exist
 as
 a
 MS
 Word
 document

► Characteris&cs

▪  Needs
 to
 be
 modifyable
 aier
 the
 genera&on

▪  Corporate
 design
 s&ll
 important

▪  Possibly
 frequent
 changes
 in
 the
 template

Reporting Solutions for Oracle APEX 25.03.2014 Page 6
Major
 Use
 Cases

3.
 Data
 Export

► What
 is
 it
 /
 Examples?

▪  The
 users
 want
 to
 export
 the
 data
 to
 further
 process
 it

► Characteris&cs

▪  Proper
 data
 types
 –
 CSV
 format
 problema&c

▪  Perhaps
 formajng

▪  Export
 mul&ple
 worksheets
 at
 the
 same
 &me

▪  Using
 na&ve
 features
 like
 autofilter,
 macros,
 condi&onal
 formajng

▪  Show
 /
 hide
 columns

▪  Charts,
 Pivot-­‐tables,
 password
 protec&on
 for
 files
 and
 worksheets

Reporting Solutions for Oracle APEX 25.03.2014 Page 7
Major
 Use
 Cases

3.
 Data
 Export

Reporting Solutions for Oracle APEX 25.03.2014 Page 8
Integra&on
 Strategies
 for

APEX

Reporting Solutions for Oracle APEX 25.03.2014 Page 9
Integra&on
 Strategies
 for
 APEX

1.
 Out
 of
 the
 Box

► APEX
 out-­‐of-­‐the-­‐box
 support
 :

► Interac&ve
 Reports:

► Classic
 Reports:

▪  CSV

▪  XML

Reporting Solutions for Oracle APEX 25.03.2014 Page 10