Layout Table Reports
/pages/Guides/Report/Layout Table Reports/Layout Table Reports.xml
Alpha Anywhere now has two styles of reports, the traditional free form banded report, and a new layout table banded report. For web use, most people will want to use the new layout table report with HTML output. To create a Layout Table Report, first create a report with the Quick Report Genie, then convert the Quick Report to a Layout Table Report.
Embedding Charts in Reports
/pages/Guides/Report/Charts/Embedding Charts in Reports.xml
To embed a chart in a report, first create a new Quick Report, then save it as a Layout Table Report, using the Open in Report Editor button. In the Layout Table Report Designer, add a row to hold the chart, enlarge the row and merge enough cells to make room for the desired chart size, and add the chart to the layout by double-clicking in the large cell to bring up the Cell contents dialog.
Charting in Reports
/pages/Guides/Report/Charts/index.xml
Embedding charts in reports.
Working with SQL Reports
/pages/Guides/Report/Getting Started/Working with SQL Reports.xml
There are 2 different approaches to building a SQL Report.
Reports - Layout Table Reports - Absolute Layout
/pages/Guides/Report/Layout Table Reports/Layout Table Reports - Absolute Layout.xml
Layout Table Reports now support absolute positioning of fields. This feature is similar to the absolute positioning of controls in a UX component using an AbsoluteLayout container.
Getting Started with Reports
/pages/Guides/Report/Getting Started/index.xml
Learn about the Report Editor and how to work with reports with different types of data sources.
Designing Reports for Sets with One-to-Many Links
/pages/Guides/Report/Design Techniques/Designing Reportsfor Sets with One-to-Many Links.xml
When you run a report, Alpha Anywhere treats a set as a single, composite table. For example, you have a set that links accounts to their respective debits and credits. For each record in the Account table, the Debits table can have multiple charges, and the Credits table multiple payments, Set Diagram:
Inserting Calculations in Reports
/pages/Guides/Report/Adding System and Calculated Fields/Inserting Calculations in Reports.xml
You can create calculated fields for individual report layouts to display calculations. Unlike calculated fields created for a table or set, a report's calculated fields are only available to that report, and not to other layouts. Calculated fields can perform calculation using data from a single record. You can also perform summary calculations, such as totals and averages, using data from multiple records. Calculated fields can also display simple calculations, such calculating today's date or the current page number. The diagram below shows examples of each of these uses.
Vertical Lines on Reports
/pages/Guides/Report/Printing Techniques/Vertical Lines on Reports.xml
Have you ever wanted to create an invoice or purchase order that has vertical lines separating the columns? This might sound easy at first, but how do you get every invoice to appear the same when the number of records varies from one to another? Using the old adage, "Necessity is the Mother of Invention," I was forced to come up with something for a customer. Since I would never know how many records might be in the child table (1), I couldn't just put a border on each field (limiting the border to right and left only). This would give me inconsistent results.
Working with Reports
/pages/Guides/Report/Getting Started/Working with Reports.xml
Reports, Letters, and Labels are Alpha Anywhere layouts for data output. Learn how to create reports in this guide.