Skip to main content
All CollectionsHelp Articles
Apricot Results Reporting (ARR)
Apricot Results Reporting (ARR)

How to report on data with Apricot Results

51 articles
Apricot Results | Scheduling Reports
FAQs | Automated Export from Results Reporting (Apricot to SFTP)An article intended to help customers who have enlisted, or are considering enlisting, Professional Services for help exporting through SFTP
Apricot Results Reporting Error Message FAQs
Building and Formatting ARR Reports

Release Notes | Inventory Reporting in Results Reporting
Apricot Results: Building Reports with an Excel Document
Apricot Results: Using a Custom Report as a Data SourceHow to use another Results Report as a data source
Apricot Results: Adding a New Query
Apricot Results | How to Edit Query Properties
Apricot Results | Pre- and Re-queriesHow to filter a data set with another query
Apricot Results: How to set Input Controls
Apricot Results: Drill FiltersFilters
Filtering for Active Participants in a Date Range
Apricot Results | Resetting Default Style
Apricot Results | Adding a Background Image
Apricot Results: Adding TablesThis article will go over the different types of tables that can be added to a report.
Apricot Results | Adding Reports (Tabs)In Apricot Results, each tab of a document is called a "report." This article will go over how to add new reports to your document.
Apricot Results: Sorting in Apricot Results
Apricot Results: Conditional Formatting
Apricot Results | Editing Tables/Legends
Results Reporting | Understanding Blank Date Fields
Apricot Results | Free Standing Cells/Pre-Defined Cells
Apricot Results | Hyperlinks to Participant Folders and Forms#results
Apricot Results | Creating Geographic ChartsUsing the Address Lookup form field to create Geographic Charts in Results
Apricot Results | Relative PositioningYou can use relative position to format the position of tables to prevent an overlapping of data
Apricot Results | Formatting Numbers and Dates in ReportsAll numbers and dates can be formatted to override the default formatting that is returned by Apricot Results
Apricot Results | Formatting Reports for Printing in Apricot ResultsFormatting reports to avoid page breaks, run off columns, and layout issues
ARR Functions and Formulas

Apricot Results | How to Find More Information on Functions and Operators
Apricot Results | Creating VariablesThis article will go over adding a new variable to an Apricot Results Report using the Variable Editor.
Apricot Results | Creating a Variable From a FormulaThis article will go over how to turn a formula into a variable in Apricot Results.
Apricot Results | Popular FormulasThis article reviews commonly used formulas in Apricot Results Reporting
Apricot Results | How to Flatten DataThis article pertains to the Apricot feature called Apricot Results Reporting
Apricot Results: Min, Max, First, LastThe difference between Min(), Max(), First(), Last() in reports
Apricot Results | Merge DimensionsMerged dimensions create a "merged" object from the shared objects within the multiple queries.
Finding the Most Recent Answer for a Tier 2 Field
Apricot Results | Counting The Number of Tier 2 Records Associated to a Tier 1
Apricot Results | Concatenating Data
Apricot Results | Changing Capitalization using the Upper, Lower, Initcap and WordCap functions
Apricot Results | Using the "Left" and "Right" functions to trim text strings
Apricot Results | Rounding Down or Up using the Floor and Ceil functions
Apricot Results | How to Get the Month, Day, or Year from a Date Object
Apricot Results | Converting a Date or Number to a String of Text
Apricot Results | Converting 24 hour time to 12 hour timeHow to convert military/24 hour time formats to a 12 hour format
Apricot Results | Finding the Time Between Two Dates with Times using the Timebetween Function