Printing RB form from VB Form

Yahoo Archive
1
Michael,

I know it is simple but it is not working. Tried it just as you said and
still the same error that it can not find the compiled program. Could it be
a bug on the Progress patch I have?

Thanks

Darren

> -----Original Message-----
> From: Podlin, Michael [mailto:michael.podlin@...]
> Sent: Wednesday, November 08, 2000 3:06 PM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Printing RB form from VB Form
>
>
> This is really quit simple.
> 1) take the procedure you wrote and compile it. (this makes
> the .r file)
> 2) in the vb form create a button and assign it to RUNPROG
> yourprogram.r
> (don't forget to include the full path and no quote marks).
>
> If you are looking for something more complex, example:
> reading variables
> off the current Vantage window/database table and passing
> them to the Report
> Builder report as filter settings, I have a program available
> on my web site
> to do this. Its tricky to setup but once its set it works flawlessly.
>
> Michael Podlin
>
> ----- Original Message -----
> From: Darren Mann <dmann@...>
> To: Vantage User Group (E-mail) <vantage@egroups.com>
> Sent: Wednesday, November 08, 2000 12:00 PM
> Subject: [Vantage] Printing RB form from VB Form
>
>
> > I know we have talked about this before but I could not
> find any remnants
> in
> > the archives.
> >
> > Progress Version: 9.0B 40?
> > Vantage Version: 4.00.901
> >
> > I am trying to print from a Vb form using a Progress
> program to make the
> > call but it comes up that it can not find my Progress
> program. I have
> > verified the path and everything appears fine.
> >
> > Here is my Progress Program:
> >
> >
> /*------------------------------------------------------------
> --------------
> > ----
> > Purpose:
> > Parameters: <none>
> > Notes:
> >

>
2
I know we have talked about this before but I could not find any remnants in
the archives.

Progress Version: 9.0B 40?
Vantage Version: 4.00.901

I am trying to print from a Vb form using a Progress program to make the
call but it comes up that it can not find my Progress program. I have
verified the path and everything appears fine.

Here is my Progress Program:

/*--------------------------------------------------------------------------
----
Purpose:
Parameters: <none>
Notes:
----------------------------------------------------------------------------
--*/
/*f var FilterString as character initial ''.
FilterString = "JobHead.JobClosed = no and JobHead.ShippedQty <
JobHead.ProdQty and
OrderRel.Reqdate < " + string(StartD) + " and
OrderRel.OpenRelease = Yes".
*/

RUN aderb\_printrb
"h:\vantage\ud\quotes.prl", /* RB-REPORT-LIBRARY */
"NoQuote Letter", /* RB-REPORT-NAME */
"", /* RB-DB-CONNECTION */
"O", /* RB-INCLUDE-RECORDS */
"" , /* 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 */

-------------
Here is the line I make the Call with when the VB Form button to print is
selected:

RUNPROG "h:\vantage\vb\printnq.r"
-------------
When selected the following error occurs:

File "h:\vantage\vb\printnq.r" not found
-------------
It's there!!!

HELP, PLEASE.

Darren Mann
Miller Products Co.
3
This may sound stupid, but rename the program and do not begin it with a
"p". We have hade the same problem, as long as the program doesn't begin
with "p" (Progress reserved letter!?!?!?) everything works fine.

Maybe this will work for you.

Rick Lane
Intelligent Systems Integration, Inc.
661 B Weber Drive
Wadsworth, OH 44281
Phone: 330-335-5291

"Helping Business Make Intelligent Use of Technology"
4
Darren -

Try changing the file name from:
h:\vantage\vb\printnq.r
to:
h:\vantage\vb\noquote.p

The file suffix should be .p for this type of 'procedure'.
While I haven't experienced the problems with the beginning
of the name being a 'p' as Rick mentioned, to be safe attempt
a combination of both suggestions.

Calvin

ps - Heads up - I also noticed you're not changing the filter
when the report is executed or passing a new filter parameter.


----- Original Message -----
From: Darren Mann <dmann@...>
To: Vantage User Group (E-mail) <vantage@egroups.com>
Sent: Wednesday, November 08, 2000 12:00 PM
Subject: [Vantage] Printing RB form from VB Form


> I know we have talked about this before but I could not find any remnants
in
> the archives.
>
> Progress Version: 9.0B 40?
> Vantage Version: 4.00.901
>
> I am trying to print from a Vb form using a Progress program to make the
> call but it comes up that it can not find my Progress program. I have
> verified the path and everything appears fine.
>
> Here is my Progress Program:
>
>
/*--------------------------------------------------------------------------
> ----
> Purpose:
> Parameters: <none>
> Notes:
> --------------------------------------------------------------------------
--
> --*/
> /*f var FilterString as character initial ''.
> FilterString = "JobHead.JobClosed = no and JobHead.ShippedQty <
> JobHead.ProdQty and
> OrderRel.Reqdate < " + string(StartD) + " and
> OrderRel.OpenRelease = Yes".
> */
>
> RUN aderb\_printrb
> "h:\vantage\ud\quotes.prl", /* RB-REPORT-LIBRARY */
> "NoQuote Letter", /* RB-REPORT-NAME */
> "", /* RB-DB-CONNECTION */
> "O", /* RB-INCLUDE-RECORDS */
> "" , /* 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 */
>
> -------------
> Here is the line I make the Call with when the VB Form button to print is
> selected:
>
> RUNPROG "h:\vantage\vb\printnq.r"
> -------------
> When selected the following error occurs:
>
> File "h:\vantage\vb\printnq.r" not found
> -------------
> It's there!!!
>
> HELP, PLEASE.
>
> Darren Mann
> Miller Products Co.
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
5
Calvin & Rick:

Thanks very much guys, but neither of those ideas worked. I tryed all
combos as you guys advised and same result. I'm sure this has to be one of
those "groaners" when I find it. Has anyone done this successfully? It is
possible correct???

Darren

> -----Original Message-----
> From: calvin [mailto:calvin@...]
> Sent: Wednesday, November 08, 2000 1:09 PM
> To: vantage@egroups.com
> Subject: Re: [Vantage] Printing RB form from VB Form
>
>
> Darren -
>
> Try changing the file name from:
> h:\vantage\vb\printnq.r
> to:
> h:\vantage\vb\noquote.p
>
> The file suffix should be .p for this type of 'procedure'.
> While I haven't experienced the problems with the beginning
> of the name being a 'p' as Rick mentioned, to be safe attempt
> a combination of both suggestions.
>
> Calvin
>
> ps - Heads up - I also noticed you're not changing the filter
> when the report is executed or passing a new filter parameter.
6
This is really quit simple.
1) take the procedure you wrote and compile it. (this makes the .r file)
2) in the vb form create a button and assign it to RUNPROG yourprogram.r
(don't forget to include the full path and no quote marks).

If you are looking for something more complex, example: reading variables
off the current Vantage window/database table and passing them to the Report
Builder report as filter settings, I have a program available on my web site
to do this. Its tricky to setup but once its set it works flawlessly.

Michael Podlin

----- Original Message -----
From: Darren Mann <dmann@...>
To: Vantage User Group (E-mail) <vantage@egroups.com>
Sent: Wednesday, November 08, 2000 12:00 PM
Subject: [Vantage] Printing RB form from VB Form


> I know we have talked about this before but I could not find any remnants
in
> the archives.
>
> Progress Version: 9.0B 40?
> Vantage Version: 4.00.901
>
> I am trying to print from a Vb form using a Progress program to make the
> call but it comes up that it can not find my Progress program. I have
> verified the path and everything appears fine.
>
> Here is my Progress Program:
>
>
/*--------------------------------------------------------------------------
> ----
> Purpose:
> Parameters: <none>
> Notes:
> --------------------------------------------------------------------------
--
> --*/
> /*f var FilterString as character initial ''.
> FilterString = "JobHead.JobClosed = no and JobHead.ShippedQty <
> JobHead.ProdQty and
> OrderRel.Reqdate < " + string(StartD) + " and
> OrderRel.OpenRelease = Yes".
> */
>
> RUN aderb\_printrb
> "h:\vantage\ud\quotes.prl", /* RB-REPORT-LIBRARY */
> "NoQuote Letter", /* RB-REPORT-NAME */
> "", /* RB-DB-CONNECTION */
> "O", /* RB-INCLUDE-RECORDS */
> "" , /* 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 */
>
> -------------
> Here is the line I make the Call with when the VB Form button to print is
> selected:
>
> RUNPROG "h:\vantage\vb\printnq.r"
> -------------
> When selected the following error occurs:
>
> File "h:\vantage\vb\printnq.r" not found
> -------------
> It's there!!!
>
> HELP, PLEASE.
>
> Darren Mann
> Miller Products Co.
>
>