AppML HTML Reports

The <htmlreport> element describes the elements of an HTML report.

HTMLReport Sub Elements

The <htmlreport> element can have the following sub elements:

• title
• stylesheet
• sql
• header
• footer
• table
• break
• section

The Title Element

An AppML <title> element inside an <htmlreport> element has the same function as the title element inside the <appml> element.

If this element is omitted the application will use the default title from the <appml> element.

The Stylesheet Element

An AppML <stylesheet> element inside an <htmlreport> element has the same function as the stylesheet element inside the <appml> element.

If this element is omitted the application will use the default stylesheet from the <appml> element.

The SQL Element

The AppML <sql> element defines the SQL statement to be used to extract data from the database.

If this element is omitted, the report will use the default <sql> element from database description.

The Header Element

The AppML <header> element is used to define an additional output that will be displayed before the actual report on a page.

Any HTML code may be included inside the <header> element

Example:

<htmlreport name="SalesByProducts">

<sql>
select * from [Product Sales for 1997]
</sql>

<header>
<h1>Product Sales for 1997</h2>
<p>Compiled by John Johnson</p>
</header>

</htmlreport>

The Footer Element

The AppML <footer> element is used to define an additional output that will be displayed after the actual report on a page.

Any HTML code may be included inside the <footer> element

The Table Element

The AppML <table> element provides a way to define the style and layout of the report table. An AppML <thead> element can be used inside the table element to define a table header different from the default.

Example:

<htmlreport>

<sql>
select CustomerName, City from Customers
</sql>

<table border="0" class="app">
<thead>
<tr>
  <th class="app" align="center">Customer Name</th>
  <th class="app" align="left">Customer City</th>
</tr>
</thead>
/table>

</htmlreport>

The Break Element

The AppML <break> element is used to define breaks in the report. This element is used together with the <section> element.

The Section Element

The AppML <section> element can be used to divide the output into sections. Any legal HTML elements can be put inside this element.

The use of this element will be described in a later chapter.

HTMLReport Attributes

The <htmlreport> element can have the following attributes:

• name
• src

The Name attribute

The name attribute is used to name the <htmlreport> element. This enables an AppML Report Service to run a number of different reports from the same AppML description.

Example:

<htmlreport name="SalesByProducts">

The Src attribute

The src attribute provides a reference to an <htmlreport> element stored in an external AppML description file.

Example:

<htmlreport name="SalesByProducts src="sales_bp">

An XML Schema for AppML

If you have Internet Explorer, you can Click Here to view the full XML Schema for an AppML document.

Jump to: Top of Page or HOME or Printer friendly page

Search W3Schools:

What Others Say About Us

Does the world know about us? Check out these places:

Dogpile Alta Vista MSN Google Excite Lycos Yahoo Ask Jeeves

We Help You For Free. You Can Help Us!

• Tell your newsgroup or mailing list
• Link to us from your pages
• Help us correct errors and broken links
• Help us with spelling and grammar
• Validate the XHTML code of this page

W3Schools is for training only. We do not warrant its correctness or its fitness for use. The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2002 by Refsnes Data. All Rights Reserved

How we converted to XHTML