Print a listing of all report builder reports

Yahoo Archive
1
I think I am missing a lot of group posts...including seeing my own much of the time. So I am not sure about the details the one below is refering to but.....

Here is a .p routine I found somewhere (perhaps in a group post probably) that will list the reports in a PRL. It is not real super useful but in a pinch can help locate a report and perhaps with some trickier programming (beyond my skills) could loop through library names.

Note: Change the hv-AR.prl to some library name of yours (as well as folder path as needed). The results are dpsilayed in a small window 10 at a time. I think I increased the lines to 20 or so but for a large PRL this still means several pages of screen prints. The _getgame.p routine is in the prgs91d\gui\aderb folder.
Anyway, a starting point of sorts.

-Todd C.



------------------------------------------------------------------------------
DEFINE VARIABLE rl AS CHARACTER.
DEFINE VARIABLE rc AS INTEGER.
DEFINE VARIABLE rp AS CHARACTER VIEW-AS SELECTION-LIST INNER-LINES 10
INNER-CHARS 32.

FORM "Number of Reports" rc SKIP rp WITH FRAME x NO-LABELS.
RUN aderb/_getname.p ("V:\vantage\reports\hv-AR.prl", OUTPUT rl, OUTPUT rc).
rp = ?.
rp:LIST-ITEMS = rl.
DISPLAY rc WITH FRAME x.
UPDATE rp WITH FRAME x.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Judy Havlik
Sent: Wednesday, December 17, 2008 3:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Print a listing of all report builder reports


Were you ever able to print all of the reports in your prl's. We have
the same issue.

Sincerely,
Judy Havlik
Plitek, L.L.C.





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

Does anybody know how to print a listing of all report builder
reports. We have several libraries under the \UD folder. I don't want
to have to open each .prl file and do a screen print. I want to be
able to print a listing.

Any help would be appreciated. We are trying to get ready to convert
from 6.1 to 8.03. That way we can get a head start on converting
report builder reports to Crystal.

Thanks,

Randy Duly
3
Here is a .p routine I got from the Report Builder User Guide (page A-4).
It is pretty bare bones....just a list of the reprot names. You would have to type in the .prl name for each library though. Soemone more skilled with .p routines than I could perhaps have it find, and use, all the .prl files in a folder and maybe even print instead of display.
--------------------------------------
DEFINE VARIABLE rl AS CHARACTER.
DEFINE VARIABLE rc AS INTEGER.
DEFINE VARIABLE rp AS CHARACTER VIEW-AS SELECTION-LIST INNER-LINES 10
INNER-CHARS 32.

FORM "Number of Reports" rc SKIP rp WITH FRAME x NO-LABELS.

RUN aderb/_getname.p ("V:\vantage\reports\REPORT.prl", OUTPUT rl, OUTPUT rc).

rp = ?.
rp:LIST-ITEMS = rl.
DISPLAY rc WITH FRAME x.
UPDATE rp WITH FRAME x.
--------------------------------------

-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of randyduly
Sent: Wednesday, July 25, 2007 8:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Print a listing of all report builder reports


Hi Everyone-

Does anybody know how to print a listing of all report builder
reports. We have several libraries under the \UD folder. I don't want
to have to open each .prl file and do a screen print. I want to be
able to print a listing.

Any help would be appreciated. We are trying to get ready to convert
from 6.1 to 8.03. That way we can get a head start on converting
report builder reports to Crystal.

Thanks,

Randy Duly



________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.

Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.

For more information please visit www.harveyvogel.com


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

This just display all of the report in a little box on the screen. I
was looking for something that I could print out. Thanks.

--- In vantage@yahoogroups.com, Todd Caughey <caugheyt@...> wrote:
>
> Here is a .p routine I got from the Report Builder User Guide
(page A-4).
> It is pretty bare bones....just a list of the reprot names. You
would have to type in the .prl name for each library though.
Soemone more skilled with .p routines than I could perhaps have it
find, and use, all the .prl files in a folder and maybe even print
instead of display.
> --------------------------------------
> DEFINE VARIABLE rl AS CHARACTER.
> DEFINE VARIABLE rc AS INTEGER.
> DEFINE VARIABLE rp AS CHARACTER VIEW-AS SELECTION-LIST INNER-LINES
10
> INNER-CHARS 32.
>
> FORM "Number of Reports" rc SKIP rp WITH FRAME x NO-LABELS.
>
> RUN aderb/_getname.p ("V:\vantage\reports\REPORT.prl", OUTPUT rl,
OUTPUT rc).
>
> rp = ?.
> rp:LIST-ITEMS = rl.
> DISPLAY rc WITH FRAME x.
> UPDATE rp WITH FRAME x.
> --------------------------------------
>
> -Todd C.
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of randyduly
> Sent: Wednesday, July 25, 2007 8:26 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Print a listing of all report builder reports
>
>
> Hi Everyone-
>
> Does anybody know how to print a listing of all report builder
> reports. We have several libraries under the \UD folder. I don't
want
> to have to open each .prl file and do a screen print. I want to be
> able to print a listing.
>
> Any help would be appreciated. We are trying to get ready to
convert
> from 6.1 to 8.03. That way we can get a head start on converting
> report builder reports to Crystal.
>
> Thanks,
>
> Randy Duly
>
>
>
> ________________________________
> The information contained in this E-mail message and any documents
which may be attached are privileged and confidential, and may be
protected from disclosure.
>
> Please be aware that any use, printing, copying, disclosure or
dissemination of this communication may be subject to legal
restriction or sanction. If you think you have received this message
in error, please reply to the sender.
>
> For more information please visit www.harveyvogel.com
>
>
> [Non-text portions of this message have been removed]
>
5
That's where a little more Progress skiils than I have might help too....if there is a way to export to a file instead of display to screen. You can make the "box" longer by changing the lines 10 to 30 if lthe ibraries are small.. (a good ideas since if libraries are too large they can crash and be destroyed). Then a screen print might show all the reports in the library.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of randyduly
Sent: Thursday, July 26, 2007 9:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Print a listing of all report builder reports


Hi Todd-

This just display all of the report in a little box on the screen. I
was looking for something that I could print out. Thanks.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Todd Caughey <caugheyt@...> wrote:
>
> Here is a .p routine I got from the Report Builder User Guide
(page A-4).
> It is pretty bare bones....just a list of the reprot names. You
would have to type in the .prl name for each library though.
Soemone more skilled with .p routines than I could perhaps have it
find, and use, all the .prl files in a folder and maybe even print
instead of display.
> --------------------------------------
> DEFINE VARIABLE rl AS CHARACTER.
> DEFINE VARIABLE rc AS INTEGER.
> DEFINE VARIABLE rp AS CHARACTER VIEW-AS SELECTION-LIST INNER-LINES
10
> INNER-CHARS 32.
>
> FORM "Number of Reports" rc SKIP rp WITH FRAME x NO-LABELS.
>
> RUN aderb/_getname.p ("V:\vantage\reports\REPORT.prl", OUTPUT rl,
OUTPUT rc).
>
> rp = ?.
> rp:LIST-ITEMS = rl.
> DISPLAY rc WITH FRAME x.
> UPDATE rp WITH FRAME x.
> --------------------------------------
>
> -Todd C.
>
> ________________________________
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
Behalf Of randyduly
> Sent: Wednesday, July 25, 2007 8:26 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Print a listing of all report builder reports
>
>
> Hi Everyone-
>
> Does anybody know how to print a listing of all report builder
> reports. We have several libraries under the \UD folder. I don't
want
> to have to open each .prl file and do a screen print. I want to be
> able to print a listing.
>
> Any help would be appreciated. We are trying to get ready to
convert
> from 6.1 to 8.03. That way we can get a head start on converting
> report builder reports to Crystal.
>
> Thanks,
>
> Randy Duly
>
>
>
> ________________________________
> The information contained in this E-mail message and any documents
which may be attached are privileged and confidential, and may be
protected from disclosure.
>
> Please be aware that any use, printing, copying, disclosure or
dissemination of this communication may be subject to legal
restriction or sanction. If you think you have received this message
in error, please reply to the sender.
>
> For more information please visit www.harveyvogel.com
>
>
> [Non-text portions of this message have been removed]
>



________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.

Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.

For more information please visit www.harveyvogel.com


[Non-text portions of this message have been removed]
6
Were you ever able to print all of the reports in your prl's. We have
the same issue.

Sincerely,
Judy Havlik
Plitek, L.L.C.