RINFO returns information on a report.

SYNTAX:

RINFO(ReportID or Name, Field)

ReportID or Name: The Report Id (if field is numeric) or Report Name in quotes.  If set to "" it is assumed to be the current report.  Can be a string (i.e. "My report"),a cell reference (i.e. C2) that contains a string, a numeric id (1), or a cell reference that contains a number. 

Field: Which field to retrieve from the SPRPTS table.  Valid settings include:

AUDITUSER
AUDITTIMESTAMP
REPORTID
NAME
STARTDATE
ENDDATE
GROUPID
DATAAPPMIN
DATAAPPACTION
REPORTDESC
REPORTTYPE
REPORTDATETYPE
DEFAULTDATES
SPECIALREPORTTYPE
ISTRIGGER
TRIGGER_COL
TRIGGER_ROW
TRIGGER_VALID
TRIGGER_LENGTH_MINS
EDMR_EXCEL_SHEET
LASTRUN
LASTRUNBY

EXAMPLES:

=RINFO(17,"LASTRUN") - returns 6/20/2024 3:21 PM, the date/time of the last time the report was outputted.

=RINFO("","NAME") - returns "My Report", the name of the current report.

=RINFO("My Report", "ISTRIGGER") - returns -1 meaning this report is a trigger report (Zero (0) means it is not a trigger.

=RINFO("My deleted report","REPORTID") returns "" as My deleted report was not found in SPRPTS table.