Chapter 1: Welcome to InfoMaker

What you make with InfoMaker

Forms

The sample shows an Employee Data form with text boxes for items such as Employee I D and Manager I D, radio buttons for items such as Status, whether Active, Terminated, or On Leave, and check boxes for items such as Health Insurance, Life Insurance, and Day Care.

Reports

The sample is titled Total Compensation Report Salary Plus Benefits. It has a column corresponding to each field in the sample form of the previous illustration, such as a text columns each for department and employee ID and check boxes for Health and Life Insurance. There is one row of data for each employee. The last column displays each employee’s Salary Plus Benefits.

Crosstabs

Shown is a sample cross tab report. It has rows for Salary ranges in increments of 10,000 and columns to show the number of employees for each department I D who are in each range. A final column shows the total number of employees within each salary range. A final row shows the total number of employees within each department.

Reports with nested reports

Shown is a report titled Customers and Orders. At left the data for an individual customer is displayed, including customer I D, first and last name, and so on. Nested in the right lower corner is an Order History report for that customer, including columns for Sales Order I D, Order Date, and so on.

Composite reports

Shown is a composite report titled Quick Reference Information. At top left is a report called Product and Current Inventory, at top right is a report titled Sales Representatives and Total Number of Orders for each. Across the bottom is a report titled Product Sales Summary, with a table of data at left showing product IDs, names, descriptions, quantity sold, and dollars, and a nested bar chart on the right titled Sales Summary, which shows number of dollars sold per product.

Forms with reports

Shown is a report titled Maintain Contact Information. At left is a form with text fields for displaying and editing or entering ID, Last and First Name, Job Role, and so forth. At top right are buttons labeled Add a contact, Delete a contact, and Save changes. Under them is a scrollable grid of entries with a row of data for each entry that maps to the fields in the form on the left.

Graphs

Shown is a pie chart labeled Contacts by Job Role. At right is the pie divided into segments and labeled with percentages. At left is a color key with a label such as Administration or Customer support that maps to each segment of the pie.

Reports with graphs

Shown is a report titled Breakdown of Salary Expenses. At left are two columns with Department Names and Total Salary for each department. At right is a bar chart called Salary Expense by Department that represents the same data by plotting Total Salary on the x axis against department names on the y axis.

Labels

Shown are rows and columns of mailing labels. Each has an icon at upper left, a name line, and two lines of address information.

Applications

The illustration represents an application called Contacts. At top is a Contacts button that connects to a window titled Contacts. The Contacts window has a menu bar with an Objects option that displays a drop down menu with options called Ad Hoc, By job, and Data. An icon on the menu bar is also labeled Ad Hoc, and it connects to a contact window. The contact window displays a report labeled contact grid _ with _ prompting. The grid has columns for ID, Last Name, First Name, and so on, and a row of data for each contact.

Copyright © 2007. Sybase Inc. All rights reserved.

Starting InfoMaker

View this book as PDF