Prl contents

Yahoo Archive
1
Lonnie,

Many thanks.

Brychan


--- In vantage@yahoogroups.com, "lonniedrew" <lonniedrew@c...> wrote:
> Yes, there are a couple of ways to change the output of a report
> called with the RB engine.
>
> One is to pass a parameter, another is to pass a filter.
>
> I'll put together some examples and send them to you.
>
> Lonnie
>
>
>
> --- In vantage@yahoogroups.com, "brychanwilliams" <brychanw@h...>
> wrote:
> > Lonnie,
> >
> > Sorry for butting in on this one. Wondering if you knew...
> >
> > is it possible to pass arguments to a report builder report via
> > progress. Such as customer name to be used in a filter?
> >
> > Thanks
> >
> > --- In vantage@yahoogroups.com, "lonniedrew" <lonniedrew@c...>
> wrote:
> > > I just uploaded source code that I wrote a few years ago for
such
> > a
> > > program.
> > >
> > > Run it from an icon with command line such as...
> > >
> > > X:\PROGRESS\bin\prowin32.exe -p X:\mfgsys61\ud\PRLView.w
> > >
> > > Enter a directory path and name. Press tab or return. PRLs
in
> > > directory will be listed. Select PRL, and reports will be
listed
> > to
> > > print or preview.
> > >
> > > Have fun,
> > > Lonnie
> > >
> > > --- In vantage@yahoogroups.com, "Keith Mailloux"
> > <keith.mailloux@f...>
> > > wrote:
> > > > Anyone have a way to list which reports reside in a Report
> > Builder prl
> > > > file?
> > > >
> > > >
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > > > Keith
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
2
Anyone have a way to list which reports reside in a Report Builder prl
file?



Thanks



Keith



[Non-text portions of this message have been removed]
3
I have this and sent it to you offline. If anyone else wants this please e-mail me directly and I will send it to you.

Thanks!

JM
jmartin@...

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Keith Mailloux
Sent: Wednesday, July 13, 2005 1:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] prl contents


Anyone have a way to list which reports reside in a Report Builder prl
file?



Thanks



Keith



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
4
What I have only displays reports in each PRL that are on the Vantage menu. Mike Podlin has one
that shows you what is in each PRL.

JM
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Juliet Martin
Sent: Wednesday, July 13, 2005 1:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] prl contents


I have this and sent it to you offline. If anyone else wants this please e-mail me directly and I will send it to you.

Thanks!

JM
jmartin@...

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Keith Mailloux
Sent: Wednesday, July 13, 2005 1:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] prl contents


Anyone have a way to list which reports reside in a Report Builder prl
file?



Thanks



Keith



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links








Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
5
I just uploaded source code that I wrote a few years ago for such a
program.

Run it from an icon with command line such as...

X:\PROGRESS\bin\prowin32.exe -p X:\mfgsys61\ud\PRLView.w

Enter a directory path and name. Press tab or return. PRLs in
directory will be listed. Select PRL, and reports will be listed to
print or preview.

Have fun,
Lonnie

--- In vantage@yahoogroups.com, "Keith Mailloux" <keith.mailloux@f...>
wrote:
> Anyone have a way to list which reports reside in a Report Builder prl
> file?
>
>
>
> Thanks
>
>
>
> Keith
>
>
>
> [Non-text portions of this message have been removed]
6
Lonnie,

Sorry for butting in on this one. Wondering if you knew...

is it possible to pass arguments to a report builder report via
progress. Such as customer name to be used in a filter?

Thanks

--- In vantage@yahoogroups.com, "lonniedrew" <lonniedrew@c...> wrote:
> I just uploaded source code that I wrote a few years ago for such
a
> program.
>
> Run it from an icon with command line such as...
>
> X:\PROGRESS\bin\prowin32.exe -p X:\mfgsys61\ud\PRLView.w
>
> Enter a directory path and name. Press tab or return. PRLs in
> directory will be listed. Select PRL, and reports will be listed
to
> print or preview.
>
> Have fun,
> Lonnie
>
> --- In vantage@yahoogroups.com, "Keith Mailloux"
<keith.mailloux@f...>
> wrote:
> > Anyone have a way to list which reports reside in a Report
Builder prl
> > file?
> >
> >
> >
> > Thanks
> >
> >
> >
> > Keith
> >
> >
> >
> > [Non-text portions of this message have been removed]
7
Yes, there are a couple of ways to change the output of a report
called with the RB engine.

One is to pass a parameter, another is to pass a filter.

I'll put together some examples and send them to you.

Lonnie



--- In vantage@yahoogroups.com, "brychanwilliams" <brychanw@h...>
wrote:
> Lonnie,
>
> Sorry for butting in on this one. Wondering if you knew...
>
> is it possible to pass arguments to a report builder report via
> progress. Such as customer name to be used in a filter?
>
> Thanks
>
> --- In vantage@yahoogroups.com, "lonniedrew" <lonniedrew@c...>
wrote:
> > I just uploaded source code that I wrote a few years ago for such
> a
> > program.
> >
> > Run it from an icon with command line such as...
> >
> > X:\PROGRESS\bin\prowin32.exe -p X:\mfgsys61\ud\PRLView.w
> >
> > Enter a directory path and name. Press tab or return. PRLs in
> > directory will be listed. Select PRL, and reports will be listed
> to
> > print or preview.
> >
> > Have fun,
> > Lonnie
> >
> > --- In vantage@yahoogroups.com, "Keith Mailloux"
> <keith.mailloux@f...>
> > wrote:
> > > Anyone have a way to list which reports reside in a Report
> Builder prl
> > > file?
> > >
> > >
> > >
> > > Thanks
> > >
> > >
> > >
> > > Keith
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
8
If not familiar with the RB engine, I would suggest downloading the
example I saved to the Files section.

To change a filter on the fly, change these two parameters to the RB
engine...

DEF VAR RB-INCLUDE-RECORDS AS CHARACTER INITIAL "O".
DEF VAR RB-FILTER AS CHARACTER INITIAL "".

Make sure RB-INCLUDE-RECORDS is set to letter "O".

RB-FILTER needs to contain the temporary filter for the report, such
as ....

rb-filter = "ActualSpec.CertDate = " + string(thecertdate) + " and
ActualSpec.printrec = yes".

It can be a little tricky getting the proper syntax in RB-FILTER.

****************************
To pass a parameter, you will need to use this parameter to the RB
engine...

DEF VAR RB-OTHER-PARAMETERS AS CHARACTER INITIAL "".

For example, to send a quantity to RB....

RB-Other-Parameters = "TheQty = " + STRING(NewQTy,"->>99999").

....will send the value as a text statement.

In the RB report itself, create a calculated field, named say
PassedQty, with value such as...

runtime-parameter("TheQty")

You can place the variable PassedQty anywhere in your report or in
another calculation.

Hope this helps,

Lonnie



--- In vantage@yahoogroups.com, "brychanwilliams" <brychanw@h...> wrote:
> Lonnie,
>
> Sorry for butting in on this one. Wondering if you knew...
>
> is it possible to pass arguments to a report builder report via
> progress. Such as customer name to be used in a filter?
>
> Thanks
>
> --- In vantage@yahoogroups.com, "lonniedrew" <lonniedrew@c...> wrote:
> > I just uploaded source code that I wrote a few years ago for such
> a
> > program.
> >
> > Run it from an icon with command line such as...
> >
> > X:\PROGRESS\bin\prowin32.exe -p X:\mfgsys61\ud\PRLView.w
> >
> > Enter a directory path and name. Press tab or return. PRLs in
> > directory will be listed. Select PRL, and reports will be listed
> to
> > print or preview.
> >
> > Have fun,
> > Lonnie
> >
> > --- In vantage@yahoogroups.com, "Keith Mailloux"
> <keith.mailloux@f...>
> > wrote:
> > > Anyone have a way to list which reports reside in a Report
> Builder prl
> > > file?
> > >
> > >
> > >
> > > Thanks
> > >
> > >
> > >
> > > Keith
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]