Repor=ng Lösungen für APEX

68 Pages·2014·12.84 MB·English

Repor&ng
 Lösungen
 für
 APEX
 –

wähle
 Deine
 Waffen
 weise

Dietmar
 Aust

Opal-­‐Consul&ng,
 Köln

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

► Erstellung
 von
 Oracle-­‐basierten
 Webapplika&onen
 seit
 1997

▪  Oracle
 Portal,
 Forms,
 Reports,
 OWA
 Toolkit

▪  Ausschließlicher
 Fokus
 auf
 Oracle
 APEX
 seit
 2006!

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

► 1997-­‐2000:
 Consultant
 bei
 Oracle
 Deutschland
 in
 Düsseldorf

► Blog:
 hVp://daust.blogspot.com/

► Regelmäßiger
 Speaker
 auf
 Oracle
 Konferenzen
 (ODTUG,
 DOAG,

OOW)

Reporting Solutions for APEX 19.11.2014 Page 2
Repor&ng
 …
 what
 do
 I

mean?

► Focus
 on
 APEX
 OLTP
 applica&ons

► Crea&ng
 print-­‐ready
 reports

► Expor&ng
 data
 to
 further
 process
 them
 in
 other
 tools
 to
 support
 the

business
 process

Reporting Solutions for APEX 19.11.2014 Page 3
Use
 Cases

Reporting Solutions for APEX 19.11.2014 Page 4
Use
 Cases

1.
 Standard
 Repor&ng

Reporting Solutions for APEX 19.11.2014 Page 5
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 APEX 19.11.2014 Page 6
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
 aher
 the
 genera&on

▪  Corporate
 design
 s&ll
 important

▪  Possibly
 frequent
 changes
 in
 the
 template

Reporting Solutions for APEX 19.11.2014 Page 7
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
 formaing

▪  Export
 mul&ple
 worksheets
 at
 the
 same
 &me

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

▪  Show
 /
 hide
 columns

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

Reporting Solutions for APEX 19.11.2014 Page 8
Use
 Cases

3.
 Data
 Export

Reporting Solutions for APEX 19.11.2014 Page 9
Strategies
 for
 APEX

Reporting Solutions for APEX 19.11.2014 Page 10