COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sureshgv1234 on 22 Apr 2015 07:46:32 AM

Title: Report last excution date/time from cognos content store tables
Post by: sureshgv1234 on 22 Apr 2015 07:46:32 AM
Hi Gurus,

I have one requirement (i.e) I want to display report last execution date/time from Cognos content store tables.

I don't want from audit tables i need only from content store tables.

Moreover, i have one more In the case of a Report View - can we know the source Report that the View is linked to which report.

Thanks,
Suresh
Title: Re: Report last excution date/time from cognos content store tables
Post by: TheFrenchGuy on 22 Apr 2015 10:24:38 AM
Hello,

have you tried the formula :
ReportDate ()

To implement the function :
1)Create a text item
2)Change "Source type : Text" in "Properties"=>"Text Source" to "Report Expression"
3)Add the formula