Creating Reports
/pages/Guides/Report/Creating Reports/index.xml
Creating reports
Creating Reports
/pages/Guides/Report/Creating Reports/Creating Reports.xml
There are two approaches to creating reports.
Reports - Layout Table Reports - Creating Custom Style Sheets
/pages/Guides/Report/Layout Table Reports/Layout Table Reports - Creating Custom Style Sheets.xml
It is easy to create custom style sheets for Layout Table Reports.
Creating Custom Stylesheets in Layout Table Reports
/pages/Guides/Report/Layout Table Reports/Create Custom Style Sheets in Layout Table Reports.xml
Custom stylesheets can be created for Layout Table Reports.
Linked and Sub Reports
/pages/Guides/Report/Linked and Sub Reports/index.xml
Methods for creating sub-reports or linking other reports into a report.
Linked Reports
/pages/Guides/Report/Linked and Sub Reports/Linked Reports.xml
Linked Reports are Layout Table reports embedded into other reports, and linked with the host report on some field. Linked Reports are similar to Subreports, but more flexible — and, in fact, similar in functionality to Subreports in some other products. Using linked reports allows you to create ledger reports, among other useful report patterns that were not previously possible. In a ledger report, the Debit and Credit tables are both linked to the account table on the Account ID field, and it is possible to compute a balance on the account. Structurally, this pattern is the same as for a customer statement report that displays orders and payments.
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.
Sub-Reports
/pages/Guides/Report/Linked and Sub Reports/Sub-Reports.xml
Creating sub-reports, filtering sub-report records, sub-report filter expressions, and setting the subgroup parameter for a sub-report.
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.
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.