Home : Products : Hach WIMS : Hach WIMS Client : Documentation : Function Reference : Spread Functions : Special Functions : RINFO
Q14796 - INFO: RINFO

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.

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 6/20/2024 3:25 PM.
Last Modified on 6/24/2024 10:10 AM.
Last Modified by Scott Dorner.
Article has been viewed 352 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article