RE: [U2] [UV] Term settings for capture and no extra headings
There isn't a HDR-SUPP? If you use this with NOPAGE it should get you what you want. hth, aee Help Information For: UNIQUERY HDR.SUPP Page: 1/2 Syntax ...HDR.SUPP Synonyms ECLTYPE U HDR.SUP, HDR-SUP, HDR-SUPP ECLTYPE P HDR-SUPP, SUPP Description The UniQuery HDR.SUPP keyword suppresses the default heading in a UniQuery report. UniQuery continues to display the column headings. Page 'U'p, 'D'own, 'T'op, 'B'ottom or 'Q'uit? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill H. Sent: Thursday, October 28, 2004 19:59 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Term settings for capture and no extra headings Troy: I don't think this is possible. I spent a day trying to find it. There's a bevy of stuff Universe doesn't do that D3 does easily. This is one of them. :-( However, I think some mentioned the Report Viewer. I use this a lot and maybe it'll work for you. Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Term settings for capture and no extra headings
Thanks Bill and everyone for their ideas. Some more clarification and information... We have a generic wrapper around all reports, both basic and ad hoc universe query. One of the options (besides PRINTING the report) is that the user can choose to 'capture' the output and a wintegrate script is executed which turns on capture to a file (running in NO.PAGE mode). Once the report is captured, they might use the report for excel or word or notepad editing. I would like to retain at least the first page's heading because it contains the column names and other information that may be useful for the report such as date ranges, report title, as of date, etc. If I do not change the page depth from 60, I get an undesirable page header every 60 lines which means the user has to manually remove them. By changing the page depth to zero in D3, one was able to get the first page headings, but there was never a second page so the report 'data' continued all the way to the end (without page breaks). What I have done for Universe is to set the maximum of 32767 for a page depth, but for some reports there is a chance that the data may exceed this line count. In addition, we have a few basic programs that do a 'page' command that forces a new heading and we end up with almost 32,000 blank lines before the next page heading because universe is essentially filling out the prior page with CRLF for the remaining line count. The only work around that I've come up with (conceptually so far) is to create a hold file (via (P) printing the job), trim out the blank lines before form feeds, turn on capture, and then PRINT the HOLD file text to winteg, and then turn off capture. (I already do a similar process for normally printed laserjet reports to eliminate the leading form feed on all of our print jobs which saves a ton of blank page paper.) I was just hoping there was some undocumented ASSIGN 1 TO SYSTEM(magic number) thing that fixed this. Or any other ideas that would work?? Thanks! -Troy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Thursday, October 28, 2004 7:59 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Term settings for capture and no extra headings Troy: I don't think this is possible. I spent a day trying to find it. There's a bevy of stuff Universe doesn't do that D3 does easily. This is one of them. :-( However, I think some mentioned the Report Viewer. I use this a lot and maybe it'll work for you. Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Term settings for capture and no extra headings
if no setting maybe Create an i-desc calling a subroutine with unnamed common flag. if not (flag) then print heading set flag end should only print what you need once... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Buss, Troy (Logitek Systems) Sent: Thursday, October 28, 2004 1:28 PM To: [EMAIL PROTECTED] Subject: [U2] [UV] Term settings for capture and no extra headings On Universe 10.0.19: I want to capture a report sent to the emulator (wintegrate) and still retain the first page headings, but not get a repeating heading every 60 lines or so. On pick D3, it was possible to get this behavior by setting the page depth to 0. On universe, it wants an integer from 1 to 32767 so I end up with page breaks and a new heading every 32k lines (which is currently the lesser of the 2 evils). Is there a setting on universe that will accomplish what I need? Thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Term settings for capture and no extra headings
Troy, Are you building this report in a Basic program or is it a TCL report? If you are in Basic then you could reset the HEADING to null after the first line is printed. HTH, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Thursday, October 28, 2004 1:28 PM To: [EMAIL PROTECTED] Subject: [U2] [UV] Term settings for capture and no extra headings On Universe 10.0.19: I want to capture a report sent to the emulator (wintegrate) and still retain the first page headings, but not get a repeating heading every 60 lines or so. On pick D3, it was possible to get this behavior by setting the page depth to 0. On universe, it wants an integer from 1 to 32767 so I end up with page breaks and a new heading every 32k lines (which is currently the lesser of the 2 evils). Is there a setting on universe that will accomplish what I need? Thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Term settings for capture and no extra headings
Not sure about UV but in UD there is a NOPAGE option. Help Information For: UNIQUERY NO.PAGE Page: 2/3 terminal screen without pausing for page breaks. :LIST CLIENTS NAME NOPAGE LIST CLIENTS NAME 10:59:44 Apr 21 1997 1 CLIENTS... Name.. Paul Castiglione 10052 Paul O'Hare kkskskls 10053 Gino Lee 10054 Gregory Alps 10055 Cathy Gross 10056 Samuel Morrison 10057 Subrina Iguano 10058 Antonette Larnelle . . . 9993 Kathleen Donohue Page 'U'p, 'D'own, 'T'op, 'B'ottom or 'Q'uit? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Buss, Troy (Logitek Systems) Sent: Thursday, October 28, 2004 10:28 To: [EMAIL PROTECTED] Subject: [U2] [UV] Term settings for capture and no extra headings On Universe 10.0.19: I want to capture a report sent to the emulator (wintegrate) and still retain the first page headings, but not get a repeating heading every 60 lines or so. On pick D3, it was possible to get this behavior by setting the page depth to 0. On universe, it wants an integer from 1 to 32767 so I end up with page breaks and a new heading every 32k lines (which is currently the lesser of the 2 evils). Is there a setting on universe that will accomplish what I need? Thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Term settings for capture and no extra headings
You might want to try using wIntegrate's Report Wizard if your running a relatively new version of wIntegrate. Regards, Ian Renfrew - Original Message - From: Buss, Troy (Logitek Systems) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 28, 2004 1:28 PM Subject: [U2] [UV] Term settings for capture and no extra headings On Universe 10.0.19: I want to capture a report sent to the emulator (wintegrate) and still retain the first page headings, but not get a repeating heading every 60 lines or so. On pick D3, it was possible to get this behavior by setting the page depth to 0. On universe, it wants an integer from 1 to 32767 so I end up with page breaks and a new heading every 32k lines (which is currently the lesser of the 2 evils). Is there a setting on universe that will accomplish what I need? Thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Term settings for capture and no extra headings
Try: TERM 80, 32000 followed by your LIST statement. TERM without any options will display the current settings, the first two are page width page depth. So with the settings in my example you'll get a heading every 32,000 lines! There seems to be a limit of 32767 for page depth though. AdrianW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Friday, 29 October 2004 1:28 AM To: [EMAIL PROTECTED] Subject: [U2] [UV] Term settings for capture and no extra headings On Universe 10.0.19: I want to capture a report sent to the emulator (wintegrate) and still retain the first page headings, but not get a repeating heading every 60 lines or so. On pick D3, it was possible to get this behavior by setting the page depth to 0. On universe, it wants an integer from 1 to 32767 so I end up with page breaks and a new heading every 32k lines (which is currently the lesser of the 2 evils). Is there a setting on universe that will accomplish what I need? Thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Term settings for capture and no extra headings
Add a NO.PAGE to the end of the query. - Original Message - From: Womack, Adrian [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 28, 2004 8:47 PM Subject: RE: [U2] [UV] Term settings for capture and no extra headings Try: TERM 80, 32000 followed by your LIST statement. TERM without any options will display the current settings, the first two are page width page depth. So with the settings in my example you'll get a heading every 32,000 lines! There seems to be a limit of 32767 for page depth though. AdrianW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Friday, 29 October 2004 1:28 AM To: [EMAIL PROTECTED] Subject: [U2] [UV] Term settings for capture and no extra headings On Universe 10.0.19: I want to capture a report sent to the emulator (wintegrate) and still retain the first page headings, but not get a repeating heading every 60 lines or so. On pick D3, it was possible to get this behavior by setting the page depth to 0. On universe, it wants an integer from 1 to 32767 so I end up with page breaks and a new heading every 32k lines (which is currently the lesser of the 2 evils). Is there a setting on universe that will accomplish what I need? Thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Term settings for capture and no extra headings
All NO.PAGE does is prevent the Press any key to continue... message from appearing, it still prints headings every x lines (where x is the page depth set in TERM). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Richardson Sent: Friday, 29 October 2004 9:42 AM To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] Term settings for capture and no extra headings Add a NO.PAGE to the end of the query. - Original Message - From: Womack, Adrian [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 28, 2004 8:47 PM Subject: RE: [U2] [UV] Term settings for capture and no extra headings Try: TERM 80, 32000 followed by your LIST statement. TERM without any options will display the current settings, the first two are page width page depth. So with the settings in my example you'll get a heading every 32,000 lines! There seems to be a limit of 32767 for page depth though. AdrianW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Friday, 29 October 2004 1:28 AM To: [EMAIL PROTECTED] Subject: [U2] [UV] Term settings for capture and no extra headings On Universe 10.0.19: I want to capture a report sent to the emulator (wintegrate) and still retain the first page headings, but not get a repeating heading every 60 lines or so. On pick D3, it was possible to get this behavior by setting the page depth to 0. On universe, it wants an integer from 1 to 32767 so I end up with page breaks and a new heading every 32k lines (which is currently the lesser of the 2 evils). Is there a setting on universe that will accomplish what I need? Thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Term settings for capture and no extra headings
Troy: I don't think this is possible. I spent a day trying to find it. There's a bevy of stuff Universe doesn't do that D3 does easily. This is one of them. :-( However, I think some mentioned the Report Viewer. I use this a lot and maybe it'll work for you. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Friday, 29 October 2004 1:28 AM To: [EMAIL PROTECTED] Subject: [U2] [UV] Term settings for capture and no extra headings On Universe 10.0.19: I want to capture a report sent to the emulator (wintegrate) and still retain the first page headings, but not get a repeating heading every 60 lines or so. On pick D3, it was possible to get this behavior by setting the page depth to 0. On universe, it wants an integer from 1 to 32767 so I end up with page breaks and a new heading every 32k lines (which is currently the lesser of the 2 evils). Is there a setting on universe that will accomplish what I need? Thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Term settings for capture and no extra headings
I've read a few of these posts. Let me see if I understand the situation by sharing my solution. I roll my own printing routines for either paper or screen. Here's a skeleton of how I do it: execute 'SELECT FILE WITH PARAMS...' loop readnext KEY else DONE = 1 until DONE do execute 'LIST FILE ':KEY:' FIELDS TO CAPTURE' capturing REPORT.OUT if CNT = 0 or mod(CNT,27) = 0 then if CNT 0 then REC-1 = char(12) ; ! form feed for printing REC-1 = ' Report Header info' REC-1 = '' REC-1 = ' COLUMN HEADER INFO OF CAPTURED FIELDS' REC-1 = ' -- -- -- --' REC-1 = '' PGCNT += 1 ; ! for printed report end CNT += 1 REC-1 = REPORT.OUT6 REC-1 = REPORT.OUT7 ; ! blank line for double spacing repeat REPORT.OUT = REPORT.OUT3,99 ; ! I can't remember why I had to do this Anyway, you get a general idea of how to roll your own reporting mechanism. Now then, if you want something that's going to be the same for multiple reports printed to the screen, I'm not anywhere near the target... So, I offer this without any implied or express warranty or serviceability for any but my own project(s). I also use shell scripting extensively, even for 'peering' inside hashed files now and then... Rolling my own is more fun and I don't even smoke. Karl quote who=Bill H. Troy: I don't think this is possible. I spent a day trying to find it. There's a bevy of stuff Universe doesn't do that D3 does easily. This is one of them. :-( However, I think some mentioned the Report Viewer. I use this a lot and maybe it'll work for you. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Friday, 29 October 2004 1:28 AM To: [EMAIL PROTECTED] Subject: [U2] [UV] Term settings for capture and no extra headings On Universe 10.0.19: I want to capture a report sent to the emulator (wintegrate) and still retain the first page headings, but not get a repeating heading every 60 lines or so. On pick D3, it was possible to get this behavior by setting the page depth to 0. On universe, it wants an integer from 1 to 32767 so I end up with page breaks and a new heading every 32k lines (which is currently the lesser of the 2 evils). Is there a setting on universe that will accomplish what I need? Thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/