Report Designer: System variables

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

The Report Designer System variables display information on reports about user preference options and computer system information. The following tables list all of the currently available variables, what they output, and where the information is retrieved from within the application.

See also: Variables overview

System

Variable name Data content/source Format Variable syntax
System Date The computer date Date [System.Date]
Staff ID The staff ID of the user logged into the application Text [System.StaffID]
System Time The computer time Number [System.Time]

Financial Statement

Variable name Data content/source Format Variable syntax
Financial Statement Basis The basis selection of a given cell in a financial statement Text [System.FinancialStatement.Basis]
Financial Statement Name The name of the financial statement Text [System.FinancialStatement.Name]
Financial Statement Page Number The current page number of the financial statement Text [System.FinancialStatement.PageNumber]
Financial Statement Period End Date The ending date of the period selected for the financial statement Date [System.FinancialStatement.PeriodEndDate]
Financial Statement Segment Code The code of the segment selected in the financial statement Text [System.FinancialStatement.SegmentCode]
Financial Statement Segment Code Description The name of the segment selected in the financial statement Text [System.FinancialStatement.SegmentCodeDescription]
Financial Statement Total Number of Pages The total number of pages in the financial statement being previewed or printed Number [System.FinancialStatement.TotalNumberofPages]

Layout

Variable name Data content/source Format Variable syntax
Layout Name The name of the layout Text [System.Layout.Name]
Layout Page Number The current page number of the layout Number [System.Layout.PageNumber]
Layout Total Number of Pages The total number of pages in the layout being previewed or printed Number [System.Layout.TotalNumberofPages]

Report

Variable name Data content/source Format Variable syntax
AP Accounting Method The AP accounting method selected from the report options before previewing Text [System.Report.APAccountingMethodSelection]
AR Accounting Method The AR accounting method selected from the report options before previewing Text [System.Report.ARAccountingMethodSelection]
Bank Account Selected The selected bank account from the report options before previewing Text [System.Report.BankAccountSelection]
Report Basis The basis selection of a given cell in a report Text [System.Report.Basis]
Date Selected The date selected from the report options before previewing Date [System.Report.DateSelection]
As of Date Selected The as of date selected from the report options before previewing Date [System.Report.DateSelectionAsofDate]
Begin Date Selected The beginning date of the selected date from the report options before previewing Date [System.Report.DateSelectionBeginDate]
End Date Selected The ending date of the selected date from the report options before previewing Date [System.Report.DateSelectionEndDate]
Report Options List Outputs a list of the selected report options at the time of previewing Text [System.Report.DetailedOptionsList]
Report Filtering Selections The selected filters from the report options before previewing Text [System.Report.FilteringSelections]
Report Name The name of the report Text [System.Report.Name]
Report Page Number The current page number of the report Text [System.Report.PageNumber]
Period End Date The period ending date of the selected date from the report options before previewing Date [System.Report.PeriodEndDate]
Regions Selected The selected regions to include from the report options before previewing Text [System.Report.RegionSelections]
Report Sections Selected The selected sections to include from the report options before previewing Text [System.Report.SectionSelections]
Segment Code Selected The selected segment code from the report options before previewing Text [System.Report.SegmentCode]
Segment Code Description Selected The selected segment description from the report options before previewing Text [System.Report.SegmentCodeDescription]
Report Sorting Selections The sort by selection from the report options before previewing Text [System.Report.SortingSelections]
Total Number of Pages The total number of pages in the report when previewing Number [System.Report.TotalNumberofPages]
Units in Period The period definition field in the report options before previewing Number [System.Report.UnitsinPeriod]
User Preferences Client ID The client ID as selected from Setup > User Preferences Text [System.Report.UserPreferences.ClientID]
User Preferences Options The print detailed options as selected from Setup > User Preferences Text [System.Report.UserPreferences.DetailedOptions]
User Preferences Page Number The page number as selected from Setup > User Preferences Number [System.Report.UserPreferences.PageNumber]
User Preferences Centered Page Number The page number centered as selected from Setup > User Preferences Number [System.Report.UserPreferences.PageNumberCentered]
User Preferences Staff ID The staff ID as selected from Setup > User Preferences Text [System.Report.UserPreferences.StaffID]
User Preferences System Date and Time The system date and time as selected from Setup > User Preferences Date [System.Report.UserPreferences.SystemDateandTime]

See also: Report Designer: Procedures

Was this article helpful?

Thank you for the feedback!