Mark ... There is a form called: "Report"
I use this form to store all reports on the server (both ARR reports and Crystal Reports). I then use the Open window command to call the report. Now that you have a way of selecting the table field records - this could be the finishing touch. Let me know. On Jul 15, 12:50 pm, "Brittain, Mark" <mbritt...@navisite.com> wrote: > Hi Ely, > > Thanks for your suggestion. I can > Select all the records using PERFORM-ACTION-TABLE-SELECTALL 600100105 > Got to the Report Styles using PERFORM-ACTION-TABLE-REPORT 600100105 > > There it stops. My guess it is expecting the report to be selected however > the parameter is not in the book. Also the report would have to be on the > server so all could use it. > > Thanks > Mark > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Elry > Sent: Thursday, July 15, 2010 11:31 AM > To: arsl...@arslist.org > Subject: Re: Automate Report from Table > > Scratch that... > > I think you are trying to right click on a table field to create a > report and record it in a macro. > > I don't think that think this is supported. > > On Jul 15, 11:21 am, Elry <elryal...@gmail.com> wrote: > > Hey Mark... > > > I am assuming that you are doing the following with the macro: > > > 1) Turn on macro recording. > > 2) Open the form in search mode. > > 3) Define a Query. > > 4) Select Menu:Tools/ Reporting > > 5) Select New Style > > 6) Select Fields and set parameters. > > 7) Preview the report. > > 8) Stop Recording and Name Macro. > > 9) Close all windows. > > 10) Test Macro > > > This should work - just tried it... > > > Now you can use the Active link attached to a button to a run macro > > action. > > > The better alternative to a run macro action - would be the Open > > Window command (for running a report). > > > Hope this helps. > > > On Jul 15, 11:06 am, "Brittain, Mark" <mbritt...@navisite.com> wrote: > > > > Hi All, > > > > I have a form called Incident Management. On the form contains a table > > > called Notes. In the Notes form is the Request ID for the parent Incident > > > Management form. I would like to run a report directly from the table > > > using a button/active link but cannot seem to get it to work with a macro. > > > > The manual steps are: > > > Right click over the table, and select all > > > Right click over the table and select report > > > Select the report > > > Select Print Preview > > > Close the Report Styles window. > > > > Any suggestions greatly appreciated. > > > > Mark > > > > ____________________________________________ > > > Mark Brittain > > > Remedy Developer > > > NaviSite > > > mbritt...@navisite.com<mailto:mbritt...@navisite.com> > > > (315) 453-2912 x5335 (Phone) > > > (315) 317.2897 (Cell) > > > > ________________________________ > > > This e-mail is the property of NaviSite, Inc. It is intended only for the > > > person or entity to which it is addressed and may contain information > > > that is privileged, confidential, or otherwise protected from disclosure. > > > Distribution or copying of this e-mail, or the information contained > > > herein, to anyone other than the intended recipient is prohibited. > > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are" > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"- Hide quoted > > text - > > > - Show quoted text - > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"- Hide quoted text > - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"