Thanks a lot Jasper! Some reading to do now.
Stuart Noble
Thompson Meat Machinery
stuart@...
Ph: + 61 7 3803 6643
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Tuesday, 15 May 2007 9:48 PM
To: Vantage Groups (E-mail)
Subject: FW: [Vantage] 6.1 Button to run Report Builder report
Stuart,
The run aderb command is a command that invokes the print command in
progress.
The RB-DB-Connection is a parameter of that command.
I will send you the Progress document that I found on the progress
website that help me create this. Check out section 5.
Hope this helps!
Jasper
-----Original Message-----
From: Stuart Noble [mailto:stuart@...
<mailto:stuart%40tmach.com.au> ]
Sent: Monday, May 14, 2007 6:14 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 6.1 Button to run Report Builder report
Thanks Jasper, that all looks pretty complex.
Couple of questions if you don't mind.
1. What does this line stand for? run aderb\_printrb(
2. All the blanks and question marks starting at the line
RB-DB-CONNECTION, are they supposed to contain things, or are you merely
giving blank settings so the report previews to the users screen?
Thanks, I think with those two questions answered, I may have a vague
inkling how it works, and will be able to give one a go!
Stuart Noble
Thompson Meat Machinery
stuart@tmach. <mailto:stuart%40tmach.com.au> com.au
Ph: + 61 7 3803 6643
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Jasper Recto
Sent: Monday, 14 May 2007 9:59 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] 6.1 Button to run Report Builder report
Stuart,
In the VB Forms, you need to add the statement "RUNPROG VBP\xxx.p" to
your print button.
Then you must create a .p program that will run report builder and save
it in the MFGSYS... /VBP folder.
Here is my code for one that I did in the quote module. Copy and paste
in procedure editor and try to change the settings to your needs.
Hope that helps!
Jasper
PS. Search for .p files and you'll find some examples.
*****************************************************
/* include vbp/vb.i so VantageBasic functions are accessible. */
{v:/mfgsys61/vbp/vb.i}
/* Here define your own variables */
DEF VAR rb-filter-value as CHARACTER initial "".
FIND QuoteDtl WHERE ROWID(QuoteDtl) = GetCurrentRowID() NO-LOCK.
rb-filter-value = "QuoteDtl.QuoteNum = " + string(QuoteDtl.QuoteNum) +
" AND QuoteDtl.QuoteLine = " + string(QuoteDtl.QuoteLine).
"V:\MfgSys61\Ud\Jasper.prl", /* RB-REPORT-LIBRARY */
"Feasibility Report", /* RB-REPORT-NAME */
"", /* RB-DB-CONNECTION */
"O", /* RB-INCLUDE-RECORDS */
rb-filter-value, /* RB-FILTER */
"", /* RB-MEMO-FILE */
"?", /* RB-PRINT-DESTINATION */
"?", /* RB-PRINTER-NAME */
"", /* RB-PRINTER-PORT */
"", /* RB-OUTPUT-FILE */
0, /* RB-NUMBER-COPIES - zero */
0, /* RB-BEGIN-PAGE - zero */
0, /* RB-END-PAGE - zero */
no, /* RB-TEST-PATTERN */
"", /* RB-WINDOW-TITLE */
yes, /* RB-DISPLAY-ERRORS */
yes, /* RB-DISPLAY-STATUS */
no, /* RB-NO-WAIT */
""). /* RB-OTHER-PARAMETERS */
**************************************************
-----Original Message-----
From: Stuart Noble [mailto: stuart@tmach. <mailto:stuart%40tmach.com.au>
com.au
<mailto:stuart%40tmach.com.au> ]
Sent: Sunday, May 13, 2007 7:08 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 6.1 Button to run Report Builder report
Hi there,
I have a report builder report which basically prints out the Bill of
materials for a job relating to a specific serial number. What I need to
do is have the user able to print the report directly from the serial
number tracker screen.
I amgine I can do this via the use of a VB form pushbutton, however, I
have no idea of how to do so. Can anyone give me any pointers on how to
do this? I imagine I need a program to activate when the button is
pressed, which tells report builder to run the correct report for the
current serial number, but its beyond my Progress skills!
Thanks in advance.
Stuart Noble
Thompson Meat Machinery
stuart@tmach. <mailto:stuart%40tmach.com.au> com.au
Ph: + 61 7 3803 6643
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Todd Hofert
Sent: Saturday, 12 May 2007 9:20 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] V8.03 Dashboard and Memos
I am trying to create a job status dashboard that includes a grid view
of job head memos. I want the selected job memos to display in a grid.
The problem is the Memo table doesn't store the Job Number as the Job
Number. It stores a value in the Memo Text as "Job Number(xxxxx). Can
anyone assit me in figuring out a way to select the job appropriate
memos to list in the view?
Thanks
Todd
This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Stuart Noble
Thompson Meat Machinery
stuart@...
Ph: + 61 7 3803 6643
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Tuesday, 15 May 2007 9:48 PM
To: Vantage Groups (E-mail)
Subject: FW: [Vantage] 6.1 Button to run Report Builder report
Stuart,
The run aderb command is a command that invokes the print command in
progress.
The RB-DB-Connection is a parameter of that command.
I will send you the Progress document that I found on the progress
website that help me create this. Check out section 5.
Hope this helps!
Jasper
-----Original Message-----
From: Stuart Noble [mailto:stuart@...
<mailto:stuart%40tmach.com.au> ]
Sent: Monday, May 14, 2007 6:14 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 6.1 Button to run Report Builder report
Thanks Jasper, that all looks pretty complex.
Couple of questions if you don't mind.
1. What does this line stand for? run aderb\_printrb(
2. All the blanks and question marks starting at the line
RB-DB-CONNECTION, are they supposed to contain things, or are you merely
giving blank settings so the report previews to the users screen?
Thanks, I think with those two questions answered, I may have a vague
inkling how it works, and will be able to give one a go!
Stuart Noble
Thompson Meat Machinery
stuart@tmach. <mailto:stuart%40tmach.com.au> com.au
Ph: + 61 7 3803 6643
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Jasper Recto
Sent: Monday, 14 May 2007 9:59 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] 6.1 Button to run Report Builder report
Stuart,
In the VB Forms, you need to add the statement "RUNPROG VBP\xxx.p" to
your print button.
Then you must create a .p program that will run report builder and save
it in the MFGSYS... /VBP folder.
Here is my code for one that I did in the quote module. Copy and paste
in procedure editor and try to change the settings to your needs.
Hope that helps!
Jasper
PS. Search for .p files and you'll find some examples.
*****************************************************
/* include vbp/vb.i so VantageBasic functions are accessible. */
{v:/mfgsys61/vbp/vb.i}
/* Here define your own variables */
DEF VAR rb-filter-value as CHARACTER initial "".
FIND QuoteDtl WHERE ROWID(QuoteDtl) = GetCurrentRowID() NO-LOCK.
rb-filter-value = "QuoteDtl.QuoteNum = " + string(QuoteDtl.QuoteNum) +
" AND QuoteDtl.QuoteLine = " + string(QuoteDtl.QuoteLine).
"V:\MfgSys61\Ud\Jasper.prl", /* RB-REPORT-LIBRARY */
"Feasibility Report", /* RB-REPORT-NAME */
"", /* RB-DB-CONNECTION */
"O", /* RB-INCLUDE-RECORDS */
rb-filter-value, /* RB-FILTER */
"", /* RB-MEMO-FILE */
"?", /* RB-PRINT-DESTINATION */
"?", /* RB-PRINTER-NAME */
"", /* RB-PRINTER-PORT */
"", /* RB-OUTPUT-FILE */
0, /* RB-NUMBER-COPIES - zero */
0, /* RB-BEGIN-PAGE - zero */
0, /* RB-END-PAGE - zero */
no, /* RB-TEST-PATTERN */
"", /* RB-WINDOW-TITLE */
yes, /* RB-DISPLAY-ERRORS */
yes, /* RB-DISPLAY-STATUS */
no, /* RB-NO-WAIT */
""). /* RB-OTHER-PARAMETERS */
**************************************************
-----Original Message-----
From: Stuart Noble [mailto: stuart@tmach. <mailto:stuart%40tmach.com.au>
com.au
<mailto:stuart%40tmach.com.au> ]
Sent: Sunday, May 13, 2007 7:08 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 6.1 Button to run Report Builder report
Hi there,
I have a report builder report which basically prints out the Bill of
materials for a job relating to a specific serial number. What I need to
do is have the user able to print the report directly from the serial
number tracker screen.
I amgine I can do this via the use of a VB form pushbutton, however, I
have no idea of how to do so. Can anyone give me any pointers on how to
do this? I imagine I need a program to activate when the button is
pressed, which tells report builder to run the correct report for the
current serial number, but its beyond my Progress skills!
Thanks in advance.
Stuart Noble
Thompson Meat Machinery
stuart@tmach. <mailto:stuart%40tmach.com.au> com.au
Ph: + 61 7 3803 6643
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Todd Hofert
Sent: Saturday, 12 May 2007 9:20 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] V8.03 Dashboard and Memos
I am trying to create a job status dashboard that includes a grid view
of job head memos. I want the selected job memos to display in a grid.
The problem is the Memo table doesn't store the Job Number as the Job
Number. It stores a value in the Memo Text as "Job Number(xxxxx). Can
anyone assit me in figuring out a way to select the job appropriate
memos to list in the view?
Thanks
Todd
This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]