Embedding Charts in Reports
/documentation/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
/documentation/pages/Guides/Report/Charts/index.xml
Embedding charts in reports.
Working with SQL Reports
/documentation/pages/Guides/Report/Getting Started/Working with SQL Reports.xml
There are 2 different approaches to building a SQL Report.
Getting Started with Reports
/documentation/pages/Guides/Report/Getting Started/index.xml
Learn about the Report Editor and how to work with reports with different types of data sources.
Reports - Layout Table Reports - Absolute Layout
/documentation/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.
Designing Reports for Sets with One-to-Many Links
/documentation/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:
Sub-Form Properties
/documentation/pages/Desktop/Reference/Design/View/Form/Sub-Form Properties.xml
A list sub-form properties with examples included.
Working with Reports
/documentation/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.
Reports - Custom Data Sources
/documentation/pages/Guides/Report/Creating Reports/Custom Data Sources.xml
When you create Report in Alpha Anywhere you could choose to base the report on a SQL data source, a native .dbf table, or a Custom data source. .
Inserting Calculations in Reports
/documentation/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.