CINFO

The CINFO formula is used to retrieve one of the following data items from the report currently running:

  • AppUrl
  • CalumoURL
  • ClientTimezoneOffset
  • HostName
  • ReportName
  • ReportURL
  • ReportURLWithQueryString
  • UserFileUrl
  • UserInGroup
  • UserName
  • ViewUrl

Syntax

CINFO (Arg1, Arg2…Arg20)

Arguments

Arg1

(Required)

Specify the value of the first argument.

AppUrl

The full Url to a CALUMO App - the name is specified in Arg2

CALUMOURL

The full URL of the CALUMO host server

ClientTimezoneOffset

The timezone offset integer for the client, e.g. If you are running in Australian Eastern Daylight Time, this will be 10

HostName

Name of the CALUMO host server

ReportName

Name of the current report

ReportUrl

URL of the current report, or another report if Arg2 set (to another report name)

ReportUrlWithQueryString

The full URL used by the current report including the querystring parameters (Only works for a Published Report)

UserFileUrl

The full Url to download a CALUMO User File of the given name.

The 2nd argument for this function will be the name of the user file that was uploaded without the extension.

UserInGroup

“True” or “False”, depending on whether the current user is in ALL or ANY of the Groups listed in the remaining arguments (Arg2+). The very last Arg can be “ANY” or “ALL” (the default is ANY) to specify whether the current user must be in ALL groups listed or ANY.

UserName

The current user in the format: DOMAIN\username.

ViewUrl

The full Url to a CALUMO View of the given id.

Arg2

This arg is for the case where Arg1 requires it - such as in the case of Arg1 being “AppUrl” or “UserInGroup”. For “AppUrl”, the name is specified here, for “UserGroup” all Args starting from Arg2 are groups. It can also be ANY/ALL, which is last if specified (default is ANY)

ArgN

Any further arguments that may be required or optional (currently only UserInGroup has optional multiple arguments)

Examples

  • CINFO(“ReportName”) – Returns the name of the current report
  • CINFO(“ReportUrl”) – Returns the URL of the current report
  • CINFO(“ReportUrl”, ““) – Returns the url of the report named in the 2nd argument
  • CINFO(“ReportUrlWithQueryString”) – Only works for a Published Report, and will return the full URL used by the current report including the querystring parameters
  • CINFO(“Username”) – Returns the username of the current user in the format, DOMAIN[username]
  • CINFO(“UserInGroup”, “Administrators”) - returns “True” if current user is in group “Administrators”
  • CINFO(“UserInGroup”, “Administrators”, “Finance”) - returns “True” if current user in is in either Administrators or Finance groups (ie default for last Arg is ANY)
  • CINFO(“UserInGroup”, “Group1”, “Group2”, ALL) - returns “True” if current user is in both Group1 and Group2 (ie all groups listed must be matched)
  • CINFO(“AppUrl”, “All Reports”) - returns the URL of the App named “All Reports”, if it doesn’t exist, it will still create the URL, but it won’t be valid
  • CINFO(“UserFileUrl”, “MyPdfFile”) - returns the URL of the User File named “MyPdfFile”, if it doesn’t exist, it will still create the URL, but it won’t be valid