Exago Logo
Search
Generic filters
Exact matches only

Other Functions

CellValue

DescriptionReturns the value of the current cell.
RemarkUsed in Conditional Formatting.
ExampleSuppose a cell of a report displays the price of products.

Ex. CellValue()> 150 returns True if the price of the product is greater than 150.

FilterValue

DescriptionReturns the current value of a filter as a string for display purposes.
RemarkTakes three arguments:

  1. The index, starting with 1 of the filter.
  2. Optional: The sub-index, starting with 1 for filters that contain multiple values (e.g. filters with an Is Between, Is Not Between, Is One Of or Is Not One Of operator). If omitted, filters with multiple values will return a comma-separated list of values.
  3. Optional: a boolean to determine if the value should be formatted following the user’s culture settings. This is used for numbers and dates.

    Note

    The optional third argument is not recommended for use in computational formulas. For more information about best practices, review the Filter Value and General Format Best Practices article.

ExampleSuppose the filter summary is “Order Detail.UnitPrice > ‘3.6’ and Products.ProductName is one of (‘Boston Crab Meat’, ‘Tofu’)”.

FitlerValue(1) returns 3.6
FilterValue(2) returns Boston Crab Meat, Tofu
FilterValue(2,2) returns Tofu

DescriptionCreate a hyperlink to an external website. Available for all report types except for CrossTab Reports. The link will open in a new window/browser tab.
RemarkTakes two arguments:

    1. The URL of the website.
    2. (Optional) the text to display in the cell.

If the second argument is omitted, the URL will display.

Note

If PDF exports open in a tab within this application, then clicking the hyperlink may direct a user to leave the application.

Note

Hyperlink() must be the outermost function in a cell. It may not be used inside conditional functions (i.e. If or Switch) or nested in other functions.

ExampleHyperlink(‘www.fakeWebSite.com’, ‘click here’) returns a hyperlink that displays the text ‘click here’ . Clicking this text will open http://www.fakeWebSite.com.

LoadImage

DescriptionLoad a server side image based on the input path into the cell.
RemarkCan be used to load an image dynamically in place of Report Designer’s Insert menu. The path to the image must be in quotation marks, or may be a data object field. The entire path of the image is not required if the administrator has set a value for Admin Console > General > Other Settings > ‘LoadImage’ Cell Function Parameter Prefix.

Note

LoadImage() must be the outermost function in a cell. It may not be used inside conditional functions (i.e. If or Switch) or nested in other functions.

ExampleEx. LoadImage(“C:/StarryNight.jpg”)

Ex. LoadImage(“https://mywebsite.com/logo.png”)

Ex. LoadImage({Employees.Photo})

StripHTMLTags

DescriptionRemoves any HTML tags from the input string.
RemarkThe input must be a string in between quotation marks.
ExampleEx. StripHtmlTags(“<h1>This is heading 1</h1>”) – returns This is heading 1.

ExcelFormula

DescriptionPasses an Excel formula to an Excel report.
RemarkThe input must be a string in between quotation marks. Must be the outermost function in a formula.
ExampleEx. ExcelFormula(“SUM(A1:A100)”) will pass the formula SUM(A1:A100) to Excel, which will evaluate the formula when the spreadsheet is opened.

PageNumber V2017.2

DescriptionReturns the current page number for HTML, PDF, and RTF Advanced or Express Reports.
RemarkEquivalent to the @[email protected] parameter.

Support for use in Chained Reports added in v2017.3.8.

ExampleEx. PageNumber()

ExportType V2017.2

DescriptionReturns the format the report is being exported as.
RemarkThis is useful for conditionally suppressing report sections depending on the export type.
ExampleExportType()
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents