Re: Automate Report from Table

[Elry]

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"  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  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"  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"

Re: Automate Report from Table

[Brittain, Mark]

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  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"  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"

Re: Automate Report from Table

[Elry]

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  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"  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
> > (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"

Re: Automate Report from Table

[Elry]

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"  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
> (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 at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Automate Report from Table

[Brittain, Mark]

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
(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 at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"