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