Number of times a report has been run

[DaveyC]

Hi ,

Does anyone know if theres a way to find out the number of times a report has been run/accessed?

Does crystal store this information anywhere? Possibly in the database but where?

Thanks

[DaveyC]

I had a poke around the crystal database and created this query. I am using crystal 10 i think if i had crystal XI there would be alot more audit info availiable.

select DISTINCT
inf1.objName as [Report Name]
,inf2.objName as [Parent Folder]
,MAX(inf1.LastModifyTime) LastModifyTime
from CMS_InfoObjects3 inf1
inner join CMS_InfoObjects3 inf2 on inf1.ParentID = inf2.ObjectID
where inf1.TypeID = 2

GROUP BY inf1.objName ,inf2.objName

ORDER BY MAX(inf1.LastModifyTime) DESC, inf2.objName ASC

Only problem is this doesn't tell me the last time the reprot was previewed :(

cheers