Run Time function

building reports desktopintelligence
1

Hi Listers,

I need to the charcater function from the function wizard that I could put as my header at the top of the report that will give me the last time the report ran and not printed.

Thanks
Elana

Listserv Archives (BOB member since 2002-06-25)

2

Elana,

Here’s a formula we use running BusObjs ver 4.1.4 with an Oracle 8.x database. We added a cell to the header of a report and put this formula in it.

=Concatenation("Run Date/Time: " ,FormatDate(LastExecutionDate(“Query 1 with SalesOrd”),“dd-Mmm-yy HH:mm:ss am/pm”))

“Query 1 with SalesOrd” is our data provider name. You would need to change this to your data provider name.

Paula Guillory

From: Elana Fogel [SMTP:efogel@ESSENTUS.COM]

I need to the charcater function from the function wizard that I could put as my header at the top of the report that will give me the last time the report ran and not printed.

Listserv Archives (BOB member since 2002-06-25)