| 
		
 | 
	
		
		
			| 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: 21826 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.
		
		
		
 |  
	| 
		
	 | 
 
 
 | 
	| 
		
 | 
	| 
		
 |