Please visit our sponsors !

Case Study Corporate HTML Reports

After some prototyping your HTML reports can go into corporate production.

The AppML Service " Corporate HTML Report" is tailored for production.

Corporate HTML Report

The AppML Service called app_corporate_htmlreport.asp is the perfect tool for producing HTML reports with a corporate layout. 

The only difference between this service, and the prototyping service described in the previous chapter, is that it contains an HTML template which  you can customize for your own projects. To run a report just link to the AppML Service like this:

app_corporate_htmlreport.asp?appname=appml_description.

Note that the input described below is the same as on the previous page, but the output is wrapped inside a corporate HTML page:

Example 1 - A Simple Default Report

This example uses a very simple AppML file to describe a database element. Only the database connection and a database table is defined. Using this description, the Corporate HTML Report Service has to use its default values for data selection and presentation: 

<?xml version="1.0" ?>
<database>

<connection>northwind</connection> 
<table>Customers</table> 

</database>

Click here to see the output produced by the Corporate HTML Report Service.

Example 2 - A Report with SQL

In this example we have substituted the <maintable> element from the previous example with an <sql> element to control the selection of data:

<?xml version="1.0" ?>
<database>

<connection>northwind</connection> 
<sql>
SELECT CompanyName,ContactName,City FROM Customers
</sql>

</database>

Click here to see the output produced by the Corporate HTML Report Service.

Example 3 - A Report with a Query Filter

This third example uses an AppML description with added information about how the user can query and filter the report at runtime:

<?xml version="1.0" ?>

<database>
<connection>northwind</connection> 
<sql>
SELECT CompanyName,ContactName,City FROM Customers
</sql> 

<filters>
<query>
  <field>CompanyName</field>
  <value>a</value>
</query>
<query>
  <field>City</field>
  <value></value>
  <sql>select distinct city from customers order by city</sql>
</query>
</filters>

</database>

Click here to see the output produced by the Corporate HTML Report Service.

!!! Use the FILTER link at the top of the report to filter the report.

Example 4 - A Report with Query and Order-By Filters

This example is the same as the previous, with an added information about how the user can change the sorting of the report at runtime:

<?xml version="1.0" ?>

<database>
<connection>northwind</connection>
<sql>
SELECT CompanyName,ContactName,City FROM Customers
</sql> 

<filters>
<query>
  <field>CompanyName</field>
  <value>a</value>
</query>
<query>
  <field>City</field>
  <value></value>
  <sql>select distinct city from customers order by city</sql>
</query>

<orderby>CompanyName</orderby>
<orderselect>
  <field>CompanyName</field>
  <field>ContactName</field>
  <field>City</field>
</orderselect>
</filters>

</database>

Click here to see the output produced by the Corporate HTML Report Service.

!!! Use the FILTER link at the top of the report to filter the report.

Save A Lot Of Development Time

Note that all the examples above use exactly the same AppML Service to produce the HTML report. Using an AppML Service like this can save you a lot of development time.

Development Partners Wanted

Refsnes Data has just completed a large development project based on AppML. It has been estimated by our developers that development time has been reduced by 75% compared to ordinary web development.

For new projects and for development of next generation AppML web services, Refsnes Data is seeking new development partners. Read more.

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