Click here to Skip to main content
15,885,365 members
Articles / Programming Languages / Visual Basic

Open Door - Reporting, Charts, Enquiry Drill-Downs

Rate me:
Please Sign up or sign in to vote.
4.37/5 (11 votes)
2 Feb 2009CPOL6 min read 39.2K   2K   59  
A utility for generating user editable reports, charts, documents, enquiries
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>

<body>

<h3>Designing Open Door Documents</h3>
<p><b>Open Door</b> documents may be displayed in two different forms</p>
<ol>
  <li>Report format</li>
  <li>Browser format</li>
</ol>
<p>The report format is useful for management reporting and producing standard
documents such as invoices. The Browser format is useful for producing enquiry
screens.</p>
<p>You use the same menus, methods and techniques to create both formats. To
switch the format for the current document select Style from the View menu, then
either 'Report' for the report format or 'Browser' for the browser format.</p>
<p>When you use the report format the screen displays a millimetre scale around
the edges and a coloured border at an equivalent of 6mm to assist in placing
items within the printable borders of the page.</p>
<p>The following items may be placed on an <b>Open Door</b> document</p>
<table border="1" width="100%" height="252">
  <tr>
    <td width="18%" height="19">Single Field Values</td>
    <td width="82%" height="19">The value from a single column in a specified
      Data Source</td>
  </tr>
  <tr>
    <td width="18%" height="19">Lists</td>
    <td width="82%" height="19">A formatted list of rows returned from a
      specified data source. Lists may include column headers, breaks
      sub-totals, totals and grand totals and provide most of the functions
      needed for basic reporting needs.</td>
  </tr>
  <tr>
    <td width="18%" height="19">Reports / Sub-Reports</td>
    <td width="82%" height="19">A report enables you precise control over the
      items displayed. You may embed graphical items on individual rows and use
      an unlimited number of section breaks. You may embed sub-reports within
      reports to an unlimited number of levels Reports should be used for the
      most complicated documents where the list format is not suitable.&nbsp;</td>
  </tr>
  <tr>
    <td width="18%" height="19">Totals</td>
    <td width="82%" height="19">Displays the current total for a column in a
      data source. Useful for displaying a list total outside the boundary of
      the list item (as is often required on invoices an orders).</td>
  </tr>
  <tr>
    <td width="18%" height="19">Amalgamated Totals</td>
    <td width="82%" height="19">Displays the amalgamated total of a number of
      total items.</td>
  </tr>
  <tr>
    <td width="18%" height="19">Labels</td>
    <td width="82%" height="19">Displays text, but the value of data source
      fields and parameters may be embedded.</td>
  </tr>
  <tr>
    <td width="18%" height="19">Lines</td>
    <td width="82%" height="19">Vertical, horizontal and angled lines may be
      placed on documents or within reports and sub reports</td>
  </tr>
  <tr>
    <td width="18%" height="19">Boxes</td>
    <td width="82%" height="19">Boxes may be placed on documents or within
      reports and sub reports</td>
  </tr>
  <tr>
    <td width="18%" height="19">Pictures</td>
    <td width="82%" height="19">Pictures in bitmap or metafile format may be
      placed on documents and reports. The may be sized or stretched with the
      option to preserve the aspect ratio</td>
  </tr>
  <tr>
    <td width="18%" height="21">Drill Down Buttons</td>
    <td width="82%" height="21">Drill down buttons on browser forms may be used
      to call further forms showing detailed breakdowns.</td>
  </tr>
</table>
<p>Items are placed on Open Door documents graphically, using the mouse.</p>
<blockquote>
<p style="margin-top: 0; margin-bottom: 0"><a href="AddField.htm">Adding a Single Field Value</a></p>
<p style="margin-top: 0; margin-bottom: 0"><a href="AddList.htm">Adding a List</a></p>
<p style="margin-top: 0; margin-bottom: 0"><a href="AddReport.htm">Adding a Report</a></p>
<p style="margin-top: 0; margin-bottom: 0"><a href="AddTotal.htm">Adding a Total</a></p>
<p style="margin-top: 0; margin-bottom: 0"><a href="AddAmalgam.htm">Adding an Amalgamated Total</a></p>
<p style="margin-top: 0; margin-bottom: 0"><a href="AddLabel.htm">Adding a Label</a></p>
<p style="margin-top: 0; margin-bottom: 0"><a href="AddLine.htm">Adding a Line</a></p>
<p style="margin-top: 0; margin-bottom: 0"><a href="AddBox.htm">Adding a Box</a></p>
<p style="margin-top: 0; margin-bottom: 0"><a href="AddPicture.htm">Adding a Picture</a></p>
<p style="margin-top: 0; margin-bottom: 0"><a href="AddDrill.htm">Adding a Drill Down Button</a></p>
</blockquote>

</body>

</html>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
United Kingdom United Kingdom
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions