Reports

use the reports tab to create, run, download, and schedule your reports unaric reports supports your standard salesforce reports—including joined reports—as well as custom reports created in unaric reports, which allow you to bypass salesforce limitations key features external data sources you can report on data outside of salesforce, including google analytics, stripe, and servicenow bypassing row limits custom reports allow you to overcome the standard 2,000 row limit found in salesforce parent child relationships you can bring in data from both parent and child objects (e g , accounts and their associated contacts) into a single report view ai powered analysis you can use ai agents to analyse reports in real time to spot trends, summarize data, and provide recommendations advanced logic reports support custom formulas (using apache velocity syntax) and the ability to search deleted records ai insights you can use ai agents to analyze report data in real time to spot trends, summarize differences between reports, or provide recommendations visual styling reports can be toggled between lightning and classic styles you can customize colours, add company logos, and set page orientations for pdf outputs record handlers instead of standard table rows, you can use record handlers to display data as distinct pages, blocks, or cells how it works reports function through a combination of data extraction, customisation, and automated delivery data extraction you can extract data from salesforce or external sources like google analytics, stripe, and servicenow reports start by selecting a primary object (table), then adding specific fields you can also add child reports (e g , adding contacts to an account report) to create a unified view of related records customisation you can apply logic at runtime to return specific data (e g , only "active" accounts) and search deleted records moreover, apache velocity syntax allows you to perform complex operations, such as changing how a value is displayed based on specific criteria automated delivery reports are packaged into solutions to be delivered via email , saved to cloud storage , or sent for e signature you can set reports to run on specific weekdays, monthly, or at custom intervals (e g , every two weeks) besides, reports can be triggered instantly using salesforce buttons , which pass specific record ids to the report builder to generate a filtered document in real time formatting and output flexible layouts using record handlers , you can display each report record as a document page, block, or cell instead of a standard table row visualizations you can add various charts (such as horizontal bar or gauge charts) and customize colors, logos, and themes templates you can use excel templates (type 1 or type 2) to gain precise control over formatting, such as setting exact column widths and cell alignments distribution reports are typically packaged into solutions to be delivered on a schedule via email , saved to cloud storage (like dropbox or google cloud), or triggered instantly through salesforce buttons add report you have two options for adding reports docid\ dyz vseql0sn pdwobynj reports created with unaric reports that get around several of the salesforce report limitations, such as the 2,000 row limit docid\ zn5auojhv9we1weitgwdf salesforce reports, which are created in salesforce classic through unaric reports and can be used within unaric reports ai tool unaric reports offers an llm you can prompt to go over your reports and provide insights go to the reports tab and open a report click run click the open ai tool button if this button doesn't appear, check in the settings tab that disable ai is unmarked enter your desired prompt or use the default ( analyze this report to spot trends and provide recommendations ) optionally, you can adjust the response lenght by setting a maximum number of characters check use assistant to perform a more detailed analysis with more data the ai might take longer to respond with this option activated click analyze the analysis will appear below shortly the ai will only respond with the contextual data of the report and will not search the web for additional context use icu formats for custom reports in salesforce, icu formats refer to international components for unicode (icu) formatting patterns used for dates, times, numbers, and currencies salesforce adopted icu formats as part of its move away from the older java simpledateformat patterns, ensuring better localization and consistency across different languages and regions the icu formats are automatically applied when you run salesforce reports within unaric reports, but any custom report created in unaric reports doesn't use the icu formats by default you can use this setting to have the custom reports use the icu format as well navigate to configure > settings check use icu formats for custom reports click save to finish