- 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.
- Getting Started with Reports
Learn about the Report Editor and how to work with reports with different types of data sources.
- 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.
- Printing Reports
/pages/Guides/Report/Generating Reports/Printing Reports.xml
The Printing Reports topic describes a technique available to Alpha Anywhere database users.
- Reports - HTML Calculated Fields
/pages/Guides/Report/Adding System and Calculated Fields/Reports HTML Calculated Fields.xml
You can now define calculated fields in a report that render as HTML. Your calculated field expression returns an HTML string which Alpha Anywhere renders. This is a very powerful new feature. It will allow users to exercise an enormous amount of creativity in formatting a report.
To use this feature, define a calculated field using the new printHTML() function.
- Desktop Layout
An Alpha Anywhere User Guide to the Desktop.
- Form Layout
/pages/Guides/Mobile and Web Components/UX/Controls/Other Controls/FormView/Form View Builder/Form Layout/index.xml
The Form View Builder Form Layout tab is where the layout for the FormView - controls, HTML, etc - is defined.
- Layout Options
/pages/Guides/Mobile and Web Components/Grid/Grid Properties/Layout Options/index.xml
The Grid layouts presented in the Component Type page include Tabular, Form(Columnar), and Stacked Columnar) grids. As each of these types creates different grids, selecting one or another will ultimately alter what you see in your Layout Options when you come to the properties page.
- List Layout
/pages/Guides/Mobile and Web Components/UX/Controls/Props/Data/List Properties/listprops/List Layout/index.xml
The fields to be displayed in a list are selected in the List Layout Pane of the List Builder; after being defined on the
Data Source pane. There are a number of property settings that are available on this pane as well.
- Reports - Free-form Reports - Text Dictionary Tags
/pages/Guides/Report/Design Techniques/Free-form Reports - Text Dictionary Tags.xml
You can now use text dictionary tags (...) to internationalize the labels in a report.