This documentation describes how to use WebFOCUS to create and style tabular reports, generate a wide variety of graphs, prepare data for those reports and graphs, and enable links to provide additional information. It is intended for application developers and other information technology professionals who use WebFOCUS to create and deploy reporting applications on the Internet or corporate intranets.
This manual includes the following chapters:
Describes the tools available for creating and formatting reports.
Describes ways to retrieve field values from a data source and display them.
Describes how to display report information grouped in a particular order by sorting.
Describes how to use and specify selection criteria to display only the field values that meet your needs.
Describes how to use the DEFINE and COMPUTE commands to create temporary fields.
Describes how to use subtotals and grand totals to summarize numeric information and aid in interpreting detailed information in a report.
Describes how to combine operators, field names, and constants in an expression to derive new values.
Describes how to save report data to files for reuse in different respects.
Describes the display formats available for viewing reports on the screen, including PDF, EXL2K, and XLSX.
Describes navigation in an HTML report including dynamic table of contents (TOC), the WebFOCUS Viewer, and linking report pages.
Describes how to provide more efficient retrieval of reports by bursting, or separating, a single report into multiple HTML files.
Describes how missing data affects report results and how to treat and represent it.
Describes how to join two or more related data sources to create a larger integrated data structure from which you can report.
Describes how to merge and concatenate two or more data sources into a new permanent data source.
Provides a brief overview of the formatting options available in WebFOCUS.
Describes how to create a StyleSheet and reviews general StyleSheet syntax.
Describes how you can control how reports are formatted including generating internal cascading style sheets, conditional formatting, setting measurement units, and controlling the display of empty reports.
Describes how to identify a report component using StyleSheet declarations.
Describes how you can increase your formatting options by using external cascading style sheets.
Describes basic report page layout including page size, orientation, page numbers, margins, images, grids, borders, page-breaks, and mailing labels.
Describes how to add and format headings, footings, titles, and labels to add context to your report.
Describes formatting and positioning text in a report including font style, size, and color.
Describes the GRAPH facility, which you can use to display data in graph format instead of tabular format.
Describes the Financial Modeling Language (FML) used to create and present financially oriented data, using inter-row calculations.
Describes how to present data in an unrestricted (non-tabular) format.
Describes how to use SQL to retrieve and analyze FOCUS and DBMS data.
Describes methods of increasing data retrieval and reporting efficiency.
Contains Master Files and diagrams of sample data sources used in the documentation examples.
Describes how to obtain information about error messages.
Summarizes TABLE commands and options.
Describes methods for referring to fields in a request including by alias, using long and qualified field names, and referring to all fields in a segment.
The following table describes the documentation conventions that are used in this manual.
Denotes syntax that you must enter exactly as shown.
Represents a placeholder (or variable), a cross-reference, or an important term.
Indicates a default setting.
Key + Key
Indicates keys that you must press simultaneously.
Indicates two or three choices. Type one of them, not the braces.
Indicates a group of optional parameters. None is required, but you may select one of them. Type only the parameter in the brackets, not the brackets.
Separates mutually exclusive choices in syntax. Type one of them, not the symbol.
Indicates that you can enter a parameter multiple times. Type only the parameter, not the ellipsis (...).
Indicates that there are (or could be) intervening or additional commands.
Visit our Technical Content Library at http://documentation.informationbuilders.com. You can also contact the Publications Order Department at (800) 969-4636.
Do you have any questions about this product?
Join the Focal Point community. Focal Point is our online developer center and more than a message board. It is an interactive network of more than 3,000 developers from almost every profession and industry, collaborating on solutions and sharing tips and techniques. Access Focal Point at http://forums.informationbuilders.com/eve/forums.
You can also access support services electronically, 24 hours a day, with InfoResponse Online. InfoResponse Online is accessible through our website, http://www.informationbuilders.com. It connects you to the tracking system and known-problem database at the Information Builders support center. Registered users can open, update, and view the status of cases in the tracking system and read descriptions of reported software issues. New users can register immediately for this service. The technical support section of www.informationbuilders.com also provides usage techniques, diagnostic tips, and answers to frequently asked questions.
Call Information Builders Customer Support Services (CSS) at (800) 736-6130 or (212) 736-6130. Customer Support Consultants are available Monday through Friday between 8:00 a.m. and 8:00 p.m. EST to address all your questions. Information Builders consultants can also give you general guidance regarding product capabilities. Please be ready to provide your six-digit site code number (xxxx.xx) when you call.
To learn about the full range of available support services, ask your Information Builders representative about InfoResponse Online, or call (800) 969-INFO.
To help our consultants answer your questions effectively, be prepared to provide the following information when you call:
In an effort to produce effective documentation, the Technical Content Management staff welcomes your opinions regarding this document. You can contact us through our website, http://documentation.informationbuilders.com/connections.asp.
Thank you, in advance, for your comments.
Interested in training? Information Builders Education Department offers a wide variety of training courses for this and other Information Builders products.
For information on course descriptions, locations, and dates, or to register for classes, visit our website (http://education.informationbuilders.com) or call (800) 969-INFO to speak to an Education Representative.