James, Are you exporting the report?
This is currently what I'm doing (many Thanks to Colleen Eilbert): 1) I have a folder on the application server containing the report file and a couple of batch files. One batch file I use to attach a date value to the file name in order to allow files to build up and maintain history. The second batch file I use to transfer the renamed original to another server for public viewing. 2) I have a Microsoft scheduler set to run the second batch every minute to ensure that when it is generated, the public will have access to it. 3) My escalation runs on the object form, using the same criteria I would use in the report, just to minimize time spent running the escalation. I have three if actions. Set fields to calculate and capture the report creation date. Run Process c:\\progra~1\\arsyst~1\\bruce\\report.bat $Date$ to create the exported report and run the first batch file which assigns the date. Lastly, I have a Set Fields action which sets the first request ID of the data pulled into the report, this allows me to have a filter on the affected form which sends a notification to the recipients that they have a report waiting for them on the target drive. Don't know if this will fit your situation exactly, but let me know if you have any questions. Thanks, Bruce Scott Application Developer - Remedy PetSmart, Inc. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of James Collins Sent: Monday, December 11, 2006 8:31 AM To: [email protected] Subject: Weekly remedy Reports I am trying to set up a weekly report that runs stats, I have a report built, is there a way that I can inbed it into an escalation to have it run say on every Friday? James Collins Supervisor Client Services,IT Service Desk Vnet 331-6070 DD 914-881-6070 Fax 914 331 7318 DD 914-881-7318 www.verizonbusiness.com Verizon Business - global capability.personal accountability This email is strictly confidential and intended only for use by the addressee unless otherwise indicated. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ##################################################################################### The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. ##################################################################################### _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
