Re: Print reports > 132 chr

Hi 
in Version 6.04 and later the override is done on a higher level and the 
cl doesn't work what you should do 

is use sys opt 28 (sys625) and add the new pg to the BPCS data base 









then override  thru sys170d1 - add ovrprtf that will be executed upon call 
from menu

 
 override the program that you call  (clp)
good luck
Danny




Alister Wm Macintyre <macwheel99@xxxxxxxxxxx>
Sent by: bpcs-l-bounces@xxxxxxxxxxxx
04/28/2004 02:27 AM
Please respond to "SSA's BPCS ERP System"
 
        To:     "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Re: Print reports > 132 chr


There has been some previous discussion of relevance in BPCS_L

Search for "Truncated Report" such as
http://archive.midrange.com/bpcs-l/200011/msg00053.html
http://archive.midrange.com/bpcs-l/200011/msg00031.html
http://archive.midrange.com/bpcs-l/200011/msg00032.html
If you get to one post, follow the threads on bottom to rest of 
discussion.

You might also find something of relevance in the archives of MIDRANGE_L
http://archive.midrange.com/midrange-l/200008/msg00322.html
http://archive.midrange.com/midrange-l/200106/msg01410.html

We are on 405CD and do not have this max report width constraint.
We print many reports with widths of
198 (15 to inch on 132 paper)
132 (standard green bar)
80 (standard 8 1/2 x 11 PC paper)

Can't you change SYS041D?
Where is SYS041D referenced?
If you can figure out where it is referenced, it may be practical to do a
selective modification of that access.

In BPCS405CD the BPCSMENU is what launches when people signed onto BPCS 
and
we modified that (be VERY careful when doing this ... mess up that CL and
now no one can get onto BPCS)

The 400 software (query definition, PRTF file, RPG, CL etc). specify width
... users not have to go to command line to run the stuff ... we have a
menu option that gets them to RUNQRY of the query of their choice, and one
of our queries accesses an *OUTFILE directory of our queries.

, you wrote:

>Hi,
>
>We are running  BPCS ver 6.02 on 820 machine, The max report width setup 
in
>'system control data area'  (SYS041D) is 132 chrs
>
>We have developed many in-house queries where the report width exceeds 
132
>columns. All queries are run from CL programs.
>
>When these queries are run from the menu, the report width setup in 
SYS041D
>overrides the report width of these queries and the output gets truncated
>to 132 character.
>
>When the CL(query) program is executed from command line the report width
>in SYS041D  is ignored and we are able to produce reports greater than 
132
>columns.
>
>By giving the user access to command line we give rise to an security
>breach, by granting the user rights to run any program from command line
>like (ACR100D1,INV100 et etc).
>
>How can we print reports > 132 chrs from the menu without having to
>compromise on the width of these reports and access to command line.
>
>Does anyone have a solution to this problem ?.
>
>Rgds
>
>Vincent D'souza
>Jotun UAE LTD LLC
>P.O. Box 3671
>Dubai, UAE
>Tel : Office   +97143395000 Ext 271
>          Mobile +971504509435


_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.