Hi Lisa, My settings are all the same except I have the report format set to Column. I need this setting in order to open the export in Excel. This should not matter. I tested it with the user tool and it works OK. Brian
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, April 18, 2008 4:53 PM To: [email protected] Subject: Re: Can you export to a csv file from Mid Tier? ** What kind of report is it? Is it just a really simple report (with x number of fields) or does it to a count or sum anywhere? On one of my reports (on the ReportCreator page) here is what I have: Report Name: (any name you want) Server Name: (my server name) Form Name: Contract (for example) Report Format: Record Locale: (I have this blank) Report Set: this is a required field, you can put anything you want in here. Field Tab - all the fields that I want to show on the report Sorting Tab - I did not choose anything on this tab, everything is blank Statistics - I did not choose anything on this tab, everything is blank Page Setup - I did not make any changes to this tab, I just took the default settings Qualification - did not add anything to this Description - I have a description Permissions - Public Administration - whatever the defaults are (make sure it is set to Active) Close the ReportCreator form, hightlight the report you want to run and make sure these settings are set: Destination: file Override Query in Report? (depends on what you want, but I set my to No) Report Format: CSV Character Encoding: useserver. Is anything different? Are you able to run it from the user tool? Just go to the ReportSelection form and try to run it from there and see what happens. Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 12:36 PM To: [email protected] Subject: Re: Can you export to a csv file from Mid Tier? ** Hi Lisa, I tried that same result. Perhaps I am doing something wrong. I have an AR System type report. I clicked on the Report button in my browser query window, selected the report and chose destination file, format CSV. The report will preview on screen OK if I select screen as the destination. It will not let me save it to a file. Brian ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, April 18, 2008 11:55 AM To: [email protected] Subject: Re: Can you export to a csv file from Mid Tier? ** Make sure your report has"Public" permissions and Character Encoding is "useserver" Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 11:34 AM To: [email protected] Subject: Can you export to a csv file from Mid Tier? ** I thought this was now possible? I am on ver 7.1. I have a report for the form I am using. In the Report window I selected Destination File and Report Format CSV. When I click Run a get a window to name the file. That all works up to that point. When I click Ok after naming the file I get an error: Report Error Failed To Perform Action Am I doing something wrong here? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com <http://www.Scholastic.com> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __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"
