Classification: UNCLASSIFIED Caveats: NONE The technique I have described only works on the Thick Client.
The web is a little different animal. I have successfully integrated a plain Remedy Report on the web. This means you need to send it to the screen. I believe there is some doc on this in the Admin Tool Help or the supportweb. If you can get it to show up on the web screen you can print it wysiwyg or save it to excel (if it's a table and the export to excel is turned on). There are other techniques I know (others need to help) Crystal Web is another option, but I believe this costs something to implement. Sorry I couldn't be more helpful, but my experience has always been with the Thick client. Usually specific reports are genterated from a thick client by selected individuals. Gordon M. Frank DISA\Version FNS -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: Friday, November 23, 2007 5:22 AM To: [email protected] Subject: Re: Export Form Data to Excel on Button Action (UNCLASSIFIED) Hi Gordon, is there a way to do this on the web not having the User tool. I mean maybe there is a way using OLE and php or perl on a webpage? Is it? Serouche Bezhenar, Dmitry wrote: > Hello Frank, > > Thank you for your useful answer. > I have a question reg. item 7 in your list. > How is it possible to tie a report, which exports data to application, to an Open Window action? > There are only 3 options - screen, file and printer. > > Kind Regards / C ????????? > Dmitry Bezhenar > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of FRANK, GORDON CTR DISA JSSC > Sent: Monday, November 19, 2007 4:54 PM > To: [email protected] > Subject: Re: Export Form Data to Excel on Button Action (UNCLASSIFIED) > > Classification: UNCLASSIFIED > Caveats: NONE > > This can be done in the following way: > > 1. Create a DDE.ini file in your Home directory 2. Copy the following > into the DDE.ini text file > > [excelrecord] > Path=c:\excel\excel.exe > Application=excel > Topic=system > Format=TAB > XFRDATA=Clipboard > Command1=[NEW(1)][PASTE()][SAVE.AS(,0)] > > 3. Enable "Report to Application" option is selected in the Options > dialog box 4. Build and save a report in the Remedy User tool 5. > Choose Report > Export to > Application from the Report menu bar 6. > Your query and created report will be sent to Excel 7. Tie this report > to an Open Window action in an Active Link with a Button (Permissions: > Public) > > Below is a web link with explains this in more detail: > > http://service-it-remedy.web.cern.ch/service-it-remedy/clients/aruser/ > Re > ports15.html > > A description is also available in the Remedy User Tool help. > > You can also execute Visual Basic code. To do this you will need to > substitute VB for the "Command1=[NEW(1)][PASTE()][SAVE.AS(,0)]" see VB > Help for more detail. > You will have to work with relative addressing in Visual Basic (a > recorded macro in VB will give you static addressing). > > Gordon M. Frank > DISA\Version FNS > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Anesh A Kurian > Sent: Monday, November 19, 2007 7:30 AM > To: [email protected] > Subject: Export Form Data to Excel on Button Action > > ** > > Hi Listers, > > I require to perform a data export of a regular form to an excel sheet > on click of a button. And also that it shouldnt require the user to > interact other than clicking the button. > > I tried by using the Open window action to run a report but here again > it requires the user to select a format to which the data has to be > saved as. i require that the workflow automatically opens an excel > sheet and displays the exported data on to the excel sheet. > > i would appreciate if some one could shed some light on this or if > anyone has done the same to share the idea. > > thanks and regards > > Anesh > > __20060125_______________________This posting was submitted with HTML > in it___ > Classification: UNCLASSIFIED > Caveats: NONE > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" Classification: UNCLASSIFIED Caveats: NONE _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
