Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
 

ss

Oracle Tips by Burleson 

Customizing a Calendar

The calendar from above does not contain much data on the page, and it does not appear to offer much.  However, if links are added to the page that will navigate to a report where all the RSVPs for that date can be seen, then it would be useful.  This example will modify the calendar attributes to add links.

1.       Edit the calendar.  If the page is still running, click on the Edit Page 1135 link in the developer toolbar.

2.       Click on the CAL link next to the Count of RSVPs by date region.

3.       In the Column Link region, select URL for the Target and enter the following into the URL Target and click Next.

f?p=102:11:&SESSION.:::11:P11_RSVP_DATE:#RSVP_DATE#

The Column Link and Day Link operate as a branch.  It is possible to either branch to pages in the current application or to a URL.  The URL Target is being used to branch to another application.

For this branch to work, the P11_RSVP_DATE will have to be added to page 11 in the Conference RSVP application.  Then, the query on the report would be changed to add the following at the end of the WHERE clause.

and ( rsvp_date = :P11_RSVP_DATE or :P11_RSVP_DATE is null )

Other Customizable Attributes of the Calendar

A few of the other attributes that can be set on the calendar are also located on the Calendar Attributes page.

§         Calendar Template:  There are three built in calendar templates from which to choose: Calendar; Calendar Alternative; and Small Calendar.

§         Display Type:  Setting this to Custom will allow the Column Format to be treated similarly to the HTML Expression attribute on reports.  Using the Custom display type, an image could be displayed in the calendar column like this:

<img src="#IMAGE_PREFIX#24find.gif" />


The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty

http://www.rampant-books.com/book_2005_2_html_db.htm

 

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster



Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks