CellValue
Description | Returns the value of the current cell. |
---|---|
Remark | Used in Conditional Formatting. |
Example |
Suppose a cell of a report displays the price of products. Ex. |
FilterValue
Description | Returns the current value of a filter as a string for display purposes. |
---|---|
Remark | Takes three arguments:
|
Example | Suppose the filter summary is “Order Detail.UnitPrice > '3.6' and Products.ProductName is one of ('Boston Crab Meat', 'Tofu')”.
FitlerValue(1) returns 3.6 |
Hyperlink
Description |
Create 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. |
---|---|
Remark | Takes two arguments:
If the second argument is omitted, the URL will display. Note Note |
Example |
Hyperlink(‘www.fakeWebSite.com’, ‘click here’) returns a hyperlink that displays the text ‘click here’ . Clicking this text will open http://www.fakeWebSite.com. |
LoadImage
Description | Load a server side image based on the input path into the cell. |
---|---|
Remark | Can 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. 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 |
Example |
Ex. LoadImage("C:/StarryNight.jpg") Ex. LoadImage("https://mywebsite.com/logo.png") |
StripHTMLTags
Description |
Removes any HTML tags from the input string. |
---|---|
Remark | The input must be a string in between quotation marks. |
Example |
Ex. StripHtmlTags("<h1>This is heading 1</h1>") - returns This is heading 1. |
ExcelFormula
Description | Passes an Excel formula to an Excel report. |
---|---|
Remark | The input must be a string in between quotation marks. Must be the outermost function in a formula. |
Example | Ex. 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
Description | Returns the current page number for HTML, PDF, and RTF Advanced or Express Reports. |
---|---|
Remark | Equivalent to the @pageNumber@ parameter.
Support for use in Chained Reports added in v2017.3.8. |
Example | Ex. PageNumber() |
ExportType V2017.2
Description |
Returns the format the report is being exported as. |
---|---|
Remark |
This is useful for conditionally suppressing report sections depending on the export type. |
Example | ExportType() |