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: arslist@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 at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
