Is there any way to determine the last time a report has been modified? This came up from a SOX review.
David are you talking about the Report Option or the specific Report Layout - Report Writer modifications?
Just want to know what direction to take this conversation.
** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **
Bill CampbellDirector, OperationsM.I.S. Management Information Solutions Ltd.Skype: billc.edmontonCell: +1 780 994 2455Off : +1 780 481 5564
If it's a Report Writer report, the answer is No. There is no way to determine the last time a report has been modified. The answer is the same for report options. If one of your report options table has a time and/or date stamp, then yes. The 70000 tables hold the report options. I checked a few and did not see any date stamps in that table.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * email@example.com
They want to know either one. Thanks.