Reports Repository

A few weeks back I made a call for templates for a demo of the new Reports Repository demo at OpenWorld. As I mentioned this is going to be a repository for us and hopefully you to share your templates with the Publisher community at large. I got a few templates but I'd love to get more.


RR4:


Doug Fortnam at Protege Software Services contacted me with a great example of a sharable template - its not for an invoice report but actually a custom report but its very useful. I'll share his insights here.


This XML Publisher Report is a report to document any Forms Personalizations present in Oracle Apps 11.5.10. I presented it at the New England OAUG in Massachusetts in June of this year. I think it is a good example of a useful, shareable template because it documents the setup of Forms Personalizations, either select Personalizations or all Personalizations in the database. The sql query to generate the flat file was developed in TOAD and then used in the Report Wizard to create the data template. This example makes extensive use of re-grouping and conditional logic to display the data in a fashion similar to what is displayed in the Oracle Forms. If I had to do it over again, I would develop a data template with grouping to simplify the rtf template. Not sure if there is a performance hit because of all the re-grouping.


Doug shared the template and you can get it here.


 

Comments:

I can't seem to find the link to the Reports Repository site. Was the site ever made public? I think that this would be a useful site.

Posted by John Bray on July 09, 2009 at 04:23 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today