Report Functions

Description

Functions for working with Reports in Alpha Anywhere

Name: Description
*collect Function: Collect strings for group (in cr-lf list).
*parent_report_pagecount Function: Return the first page count.
a5_composite_picture_and_ink Function: Creates a composite annotated image created from a picture field and an ink field.
a5_get_report_sections Function: The a5_get_report_sections Function
a5_quickreportcolumnsizetofit Function: Generate a report definition from quickreport definition
a5_quickreportcreatereportdefinition Function: Generate a report definition from quickreport definition
A5_REPORT_SAVED Function: The A5_REPORT_SAVED() function allows users of Runtime Plus to save named reports.
A5_ReportEdit_CloseDirty Function: Overrides the dialog displayed when a user closes a report.
A5_xb_runReport Function: Generates the HTML and Javascript to display a report.
a5w_report_saveas Function: The a5w_report_saveas() method generates a report as a PDF, HTML, RTF, or TXT document. The report can be downloaded, uploaded to Amazon S3, or emailed.
AVERAGE Function: Get the average of subexpression over group 'over' sampled each group 'each'
BLANK_DUPLICATE Function: Blank any duplicates of subexpression over group 'over' sampled each group 'each'
COUNT Function: COUNT() returns the number of records in a group of records.
CURRENT Function: CURRENT() returns the value of a field or an expression based on field contents for the current record.
CURRENT_FILTER_EXPN Function: Returns the filter for the primary table of the current session
CURRENT_ORDER_EXPN Function: Returns the order for the primary table of the current session
DUPLICATE Function: Get the duplicates count of subexpression over group 'over' sampled each group 'each'
FIRST Function: Get the first of subexpression over group 'over' sampled each group 'each'
LAST Function: Get the last of subexpression over group 'over' sampled each group 'each'
LAYOUT_DELETE Function: Deletes a Form, Browse, Label, Letter, or Report Layout
LAYOUT_RENAME Function: LAYOUT_RENAME() renames or copies a form, browse, label, letter, or report.
MAXIMUM Function: Get the maximum of subexpression over group 'over' sampled each group 'each'
MINIMUM Function: Get the minumum of subexpression over group 'over' sampled each group 'each'
PAGE_AVERAGE Function: PAGE_AVERAGE() calculates an average value of a field's entries on a report page. This function can only be used on a report page.
PAGE_COUNT Function: PAGE_COUNT() counts the number entries of a field on a report page. This function can only be used on a report page.
PAGE_MAXIMUM Function: PAGE_MAXIMUM() returns the maximum value of a field's entries on a report page. This function can only be used on a report page.
PAGE_MINIMUM Function: PAGE_MINIMUM() returns the minmum value of a field's entries on a report page. This function can only be used on a report page.
PAGE_TOTAL Function: PAGE_TOTAL() returns the total value of a field's entries on a report page. This function can only be used on a report page.
PAGECOUNT Function: PAGECOUNT() returns the number of pages in a report.
PAGENO Function: PAGENO() returns the current page number of a printed layout. If the optional Group Name is specified, the page count will be restarted each time the group repeats.
PREVIEW_REPORT Function: PREVIEW_REPORT() creates the selected report and then displays a preview of the report.
PRINT_REPORT Function: PRINT_REPORT() creates the selected report and then displays the Print dialog box.
print_report_open Function: Open a report for printing.
printQRCode Function: Generates a QR Code from a character value.
RUN_COUNT Function: Get the running count of subexpression over group 'over' sampled each group 'each'
RUN_TOTAL Function: Get the running total of subexpression over group 'over' sampled each group 'each'
TOTAL Function: Get the total of subexpression over group 'over' sampled each group 'each'