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.