Re: [U2] SORT reports line length, change right margin?
On 15/07/2013 15:32, randyleesmith wrote: It's been a while, nice to be back and working again. :) I'm on a Universe Database; I have a proc full of SORT reports. Bear in mind SORT and LIST are pretty much the same thing ... I needed to add new fields, but the size of the line is too small. I'm already using landscape mode and don't have enough space. I have been testing with PCL, but I was wondering if I could just make the line longer. Seems to be enough room if I could adjust the right margin. Could you shrink any field widths? Are there any text fields which often have wasted space? You can use the FORMAT or FMT (not sure which) modifier to adjust the field width just for that report rather than messing around cluttering up the dictionary. MARGIN /n/ only changes the left margin. What margins have been set in SETPTR? I can't remember whether the default is 0 or 3 (both left and right). I never had to deal much with SORT reports in the past, so I though you Guru's could help. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SORT reports line length, change right margin?
Randy, SETPTR can be used to set the line length/page width. SETPTR ,145,NODEFAULT,BRIEF Should set it to 145 characters. NODEFAULT says do not changes anything else and BRIEF suppresses the OK to set prompt. At the end you could/should reset it to 132. Of course, in a proc, put an H before SETPTR and a P on the next line. Good luck, Don Robinson From: Anthonys Lists antli...@youngman.org.uk To: u2-users@listserver.u2ug.org Sent: Monday, July 15, 2013 11:52 AM Subject: Re: [U2] SORT reports line length, change right margin? On 15/07/2013 15:32, randyleesmith wrote: It's been a while, nice to be back and working again. :) I'm on a Universe Database; I have a proc full of SORT reports. Bear in mind SORT and LIST are pretty much the same thing ... I needed to add new fields, but the size of the line is too small. I'm already using landscape mode and don't have enough space. I have been testing with PCL, but I was wondering if I could just make the line longer. Seems to be enough room if I could adjust the right margin. Could you shrink any field widths? Are there any text fields which often have wasted space? You can use the FORMAT or FMT (not sure which) modifier to adjust the field width just for that report rather than messing around cluttering up the dictionary. MARGIN /n/ only changes the left margin. What margins have been set in SETPTR? I can't remember whether the default is 0 or 3 (both left and right). I never had to deal much with SORT reports in the past, so I though you Guru's could help. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SORT reports line length, change right margin?
I've tried to get the ok for moving items over, but it effected the headers too. I guess the customer didn't go for it. (I have a Customer Rep I work with.) The SORT did not like making PCL changes. It just ignored them. I'm sure its because of the default settings on the system. You can set MARGIN in the SORT command itself, but only the left. I set it to 0 and it printed way over to the left, but did not add any line length. Since there is more spacing on the page I thought I might be able to take advantage of it. SETPTR might be worth looking into as long as I can set it back. In the mean time I've been able to make changes with PCL and get everything to fit nicely, but I had to code the output in order to do so. It's simple enough to code so I might go with this unless I can find an easy way to do a similar thing with the SORT statement. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SORT-reports-line-length-change-right-margin-tp41205p41209.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SORT reports line length, change right margin?
The simplest solution is to change the print width in UV then alter the CPI in PCL. You may not have to alter the print width in UV if the original developer was prescient enough to plan for expansion. e.g. ^027E^027l1e64F^027a0l85M^027(s0p16.67h0s3b##DEFFONTNO##T ...where ##DEFFONTNO### is just a tag that is substituted by the actual font ID# at runtime. HTH, Bill - Original Message - *From:* randyleesm...@roadrunner.com *To:* u2-users@listserver.u2ug.org *Date:* 7/15/2013 7:32 AM *Subject:* [U2] SORT reports line length, change right margin? It's been a while, nice to be back and working again. :) I'm on a Universe Database; I have a proc full of SORT reports. I needed to add new fields, but the size of the line is too small. I'm already using landscape mode and don't have enough space. I have been testing with PCL, but I was wondering if I could just make the line longer. Seems to be enough room if I could adjust the right margin. MARGIN /n/ only changes the left margin. I never had to deal much with SORT reports in the past, so I though you Guru's could help. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SORT-reports-line-length-change-right-margin-tp41205.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SORT reports line length, change right margin?
On 15/07/13 17:12, randyleesmith wrote: SETPTR might be worth looking into as long as I can set it back. Investigate using a different channel ... I mentioned it recently but try SETPTR 1,... followed by SORT ... LPTR 1 That way, you don't touch whatever's on the user's default channel 0, and can muck about as much as you like without (in all likelihood) trampling over the settings for something else. I use that as a matter of course when I don't want to accidentally mess up something I don't know about. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SORT reports line length, change right margin?
You all have given me a lot to work with. Thank you. I forgot to mentioned that the report I'm changing is part of a number of other similar reports. They all need to be together in the same printer spool. They are printed together as one big report. Since I don't know, or remember, much about SETPTR I'm not sure if there is a way to keep everything in the same spooler. It looks like I need to make CIP and LPI changes too. I'll need to look up all the parameters for SETPTR. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SORT-reports-line-length-change-right-margin-tp41205p41212.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SORT reports line length, change right margin?
On 15/07/13 18:15, randyleesmith wrote: You all have given me a lot to work with. Thank you. I forgot to mentioned that the report I'm changing is part of a number of other similar reports. They all need to be together in the same printer spool. They are printed together as one big report. Since I don't know, or remember, much about SETPTR I'm not sure if there is a way to keep everything in the same spooler. Ummm. If it's part of a bunch of reports, then changing the channel might well mess things up. I don't think it will if they're just run sequentially, though. It looks like I need to make CIP and LPI changes too. I'll need to look up all the parameters for SETPTR. I think there are options for holding a print channel open, so you can send several reports, then do a close and they all go to the OS spooler as a single job. I don't think that's what you want here. (off-topic - another useful trick for multiple channels is the summary report - okay you really need a BASIC program for this - but I've had a program print several independent reports, saving some data for each and dumping this to a separate channel, which finally gets closed and printed as a separate report. I've seen programmers print the individual reports, then go back and repeat the calculations to print the summary! That or store the data in some complex data structure ...) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SORT reports line length, change right margin?
There is a SP-ASSIGN OHS At the start of the Proc And a SP-ASSIGN At the end. All the report are meant to be held together. I really did miss this, even if you don't get the answer you wanted to your question, you sometimes get some great insight to the U2 environment. Knowledge that can be used somewhere else later. Or sometimes you get the How to do it a better,other way. Thanks Wols for the off topic info. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SORT-reports-line-length-change-right-margin-tp41205p41214.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SORT reports line length, change right margin?
On 15/07/13 18:50, randyleesmith wrote: There is a SP-ASSIGN OHS At the start of the Proc And a SP-ASSIGN At the end. All the report are meant to be held together. In which case (If I remember my SP-ASSIGN correctly) changing this one report to a different print channel most definitely will bugger it up... That code does hold the print channel open, so all the Pick reports get lumped into one single OS level job. Using different channels will give different jobs end of. I really did miss this, even if you don't get the answer you wanted to your question, you sometimes get some great insight to the U2 environment. Knowledge that can be used somewhere else later. Or sometimes you get the How to do it a better,other way. Thanks Wols for the off topic info. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
