Wednesday Mar 05, 2014

Internal Links

Another great question today, this time, from friend and colleague, Jerry the master house re-fitter. I think we are competing on who can completely rip and replace their entire house in the shortest time on their own. Every conversation we have starts with 'so what are you working on?' He's in the midst of a kitchen re-fit, Im finishing off odds and ends before I re-build our stair well and start work on my hidden man cave under said stairs. Anyhoo, his question!

Can you create a PDF document that shows a summary on the first page and provides links to more detailed sections further down in the document?

Why yes you can Jerry. Something like this? Click on the department names in the first table and the return to top links in the detail sections. Pretty neat huh? Dynamic internal links based on the data, in this case the department names.

Its not that hard to do either. Here's the template, RTF only right now.


The important fields in this case are the ones in red, heres their contents.

TopLink

<fo:block id="doctop" />

Just think of it as an anchor to the top of the page called doctop

Back to Top

<fo:basic-link internal-destination="doctop" text-decoration="underline">Back to Top</fo:basic-link>

Just a live link 'Back to Top' if you will, that takes the user to the doc top location i.e. to the top of the page.

DeptLink

<fo:block id="{DEPARTMENT_NAME}"/>

Just like the TopLink above, this just creates an anchor in the document. The neat thing here is that we dynamically name it the actual value of the DEPARTMENT_NAME. Note that this link is inside the for-each:G_DEPT loop so the {DEPARTMENT_NAME} is evaluated each time the loop iterates. The curly braces force the engine to fetch the DEPARTMENT_NAME value before creating the anchor.

DEPARTMENT_NAME

<fo:basic-link  internal-destination="{DEPARTMENT_NAME}" ><?DEPARTMENT_NAME?></fo:basic-link>

This is the link for the user to be able to navigate to the detail for that department. It does not use a regular MSWord URL, we have to create a field in the template to hold the department name value and apply the link. Note, no text decoration this time i.e. no underline.

You can add a dynamic link on to anything in the summary section. You just need to remember to keep link 'names' as unique as needed for source and destination. You can combine multiple data values into the link name using the concat function.

Template and data available here. Tested with 10 and 11g, will work with all BIP flavors.

Wednesday Apr 18, 2012

BI Publisher at Collaborate 2012

Wow - There are over 30 fantastic presentations that cover BI Publisher at Collaborate this year.  Interest and use of BI Publisher continues to spread across the growing family of Oracle Applications and products.

See Focus On BI Publisher at Collaborate 2012
for a day by day view of all the sessions.

Come and visit us at the Oracle Business Intelligence Foundation demo station (kiosk 14) to chat and see BI Publisher 11g live.

If you want to try BI Publisher 11g, show up for the Hands On Lab - early !
Last year we had over 200 people show up for 40 seats.
We are running 2 sessions this year to accommodate more people but still expect this to be a sold out event.

Here is a breakdown of BI Publisher sessions organized by Application area of interest.
Follow the link or see Focus On BI Publisher for time, location and speaker info.


General Interest for All

Building Reports and Data Models in Oracle Business Intelligence Publisher Hands On Lab -- 2nd session
BI Publisher 11g: Only Good News
Oracle Analytics & Performance Management Strategy and Road Map
Oracle BI Publisher: The Reporting Platform for Oracle Applications
OBIEE 11g - Using the New Features of Answers and BI Publisher
Oracle BI Publisher: Anatomy of an RTF Template
Migrating Discoverer to Oracle BIEE: Take Your Reporting to the Next Level
The Right Information, The Right Tool, the Right Time
Project and HR Analytics + OBIEE 11g + Exadata = Operational Efficiency


E-Business Suite

Jump Start Your Custom Reports with E-Business Suite R12's Seeded BI Publisher Templates
Upgrading to R12 Payments Funds Disbursement: An iRobot Case Study
Introduction to BI Publisher in Oracle EBS R12- Getting Started
Look Before You Leap! Issues to Consider When Migrating Discoverer Reports to BI Publisher 11g
Making Sense of Parent-Child Relationships – The Oracle Kind, Not the Human Kind
Adding Data Elements to BI Publisher Documents
Printing PDF Documents in Self Service Made Easy By Integrating BI Publisher With OAF
Oracle Payments in Release 12 - Take it to the Bank!



JD Edwards Enterprise One

I Bleed Red, Oracle Red Stack that Is...
Using Oracle BI Publisher for JD Edwards Operational and Financial Reporting
JD Edwards: Let's Get Going with BI Publisher
JD Edwards EnterpriseOne XE to 9.0 in Less Than 100 Days
Choosing the Right Solution to Transform Data to Actionable Information - Oracle EPM, BI and Reporting
Using Oracle BI Publisher to E-mail Customer ACH Payment Confirmations


Primavera

Transitioning From InfoMaker to BI Publisher
Introduction to Primavera Contract Management, Business Intelligence Publisher Edition
Understanding the Px Schema and Writing Reports for Primavera P6 Using Oracle BI Publisher
Oracle Primavera and BPM - The Power of Integration
Reporting from Contract Management 14.0 Using BI Publisher 11g
Primavera P6 Release 8 - Web Innovation & So Much More


JD Edwards Enterprise World

Import/Export – Electronic Document Delivery – BI Publisher Gateway
BI Publisher and World
Delivering Value through EDD and BI Publisher in World A9.2


PeopleSoft

XML Publisher - Become an Expert in an Hour


Siebel

A Case Study of a Migration to BI Publisher From Actuate at a Leading Healthcare Company



Hope to see you in Vega$,
Mike, Leslie and Nikos

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
« April 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
   
       
Today