Yes Kathy - you can create and export ARSystem reports to csv from the mid-tier. Go into Reports and set up a standard AR system report. Save it, then Run it, but when you run select Run to Destination - File and in Format select csv. This should automatically set the Character Encoding field to windows-1252. Click on Run - then when prompted for the Report File name give it a name and save it where you want. That's about it. The only problem I sometimes encounter with this is that I am prompted to Save the Report twice before it works.
Now there is also a way to 'export' the Crystal reports. Open up a Crystal Report and once you are in the view of it, select Export Report (this is a little icon under the File menu item). You can select the format, including Excel, to export to. As for the errors you got when you tried this, not sure - it could be an environment variable - a bad path statement - who knows, so without more information I probably can't help with that one. Let me know if you need any other help with setting them up. :-) Candace DeCou DOI Remedy Systems Analyst Verizon Business Office: (408) 371-1112 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Verizon Business - global capability, personal accountability. This e-mail is strictly confidential and intended only for use by the addressee unless otherwise indicated ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Friday, June 13, 2008 9:30 AM To: arslist@ARSLIST.ORG Subject: Reporting from Mid Tier ** Hi, Is it possible to run Adhoc reports and export the results to an excel spreadsheet from the Mid Tier? We are on 7.x ITSM and AR System. I see the canned reports that seem to be an option to export - which did not work - we received an error. I was looking for a technical guide to show us how this is done. I have never used the mid tier to export "ad hoc" reports - I've always used the client. Is this functionality to export adhoc and canned reports to excel available on the web? ________________________________ Get the Moviefone Toolbar <http://toolbar.aol.com/moviefone/download.html?ncid=aolcmp0005000000001 1> . Showtimes, theaters, movie news, & more! __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
