|
Re: How Can I Restrict any user only single copy of any report [message #281825 is a reply to message #281822] |
Mon, 19 November 2007 07:48 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Create a report log table (report_name, user_name) and log every execution of a report in one of Report's triggers (for example, AFTER REPORT trigger). Before running a report, check whether this user has executed it before or not.
However, you will never know whether the very first execution was successful - this user might have started the report, but - what if there was no paper in a printer, he/she accidentally turned of Acrobat Reader (if it was a PDF), etc.
Therefore, perhaps you'd want to explain what is the business requirement and why shouldn't anyone run the same report more than once.
From my point of view, such a task is nonsense and practically impossible.
|
|
|
|
|