We use many reporting tools here : UNIQUERY SB+ Report Writer SB+ ARD MVQUERY DOWNLOAD (cedarville.edu)
[EMAIL PROTECTED] wrote: Bill; With all of the really cool stuff that UD can do with UniQuery (fmt, eval, calculate, etc) it is really frustrating that (sub)totaling is such a bear (and don't get me started on udt.option 43). Perhaps we just haven't found the correct combinations of options. We pretty much gave up and used the SB+ tools for (most complex) reporting. You can try break.sup and the \ in the heading of the dicts also seems to work. I think you still have to allocate the space in the line. It may only work in det-supp reports. Hth Colin Alfke Calgary, Canada >-----Original Message----- >From: Bill Haskett > >Brian: > >A) Yes >B) No > >So I created the associations and improvement has been >noticed. Now I get: > >:SORT BANKBOOK WITH CLIENTNO = "9800""9900" AND WITH YRMO = "200411" >BY-EXP CLIENTNO ID-SUPP CLIENTNO BREAK-ON CNAME0 "Totals: >'UV'" BNAMES ATYPE_DESCS TOTAL CURRBAL CLNT# >NAME.......................... TYPEDESC....... CURR BAL..... > > 9800 KEY BANK OF CALIFORNIA Checking 57,482.04 > ------------- > PAYROLL TRUST ACCOUNT 57,482.04 > > 9900 KEY BANK OF CALIFORNIA Checking -64,729.34 > 9900 KEY BANK OF CALIFORNIA Checking -925.00 > ------------- > PROPERTY MANAGEMENT CORP. -65,654.34 > > ============= >TOTAL -8,172.30 >3 records listed > >The "CNAME0" dictionary looks like: > >AE DICT BANKBOOK CNAME0 >Top of "CNAME0" in "DICT BANKBOOK", 7 lines, 113 characters. >*--: P >001: I The client name in a zero width field >002: TRANS( "MASTER", CLIENTNO, 1, "X" ) ; SUBR( "D.NAMELFM", @1 ) >003: >004: >005: 0L >006: M >007: AS_2 >Bottom. > >If I resize this dictionary item to 30 and do the same query >as above I get: > >CLNT# CNAME0........................ NAME.......................... >TYPEDESC....... CURR BAL..... > > 9800 PAYROLL TRUST ACCOUNT KEY BANK OF CALIFORNIA > Checking >57,482.04 > Totals: PAYROLL TRUST ACCOUNT >------------- > PAYROLL TRUST ACCOUNT >57,482.04 > > 9900 PROPERTY MANAGEMENT CORP. KEY BANK OF CALIFORNIA > Checking >-64,729.34 > 9900 PROPERTY MANAGEMENT CORP. KEY BANK OF CALIFORNIA > Checking >-925.00 > Totals: PROPERTY MANAGEMENT CORP. >------------- > PROPERTY MANAGEMENT CORP. >-65,654.34 > > >============= >TOTAL >-8,172.30 >3 records listed > >Now this is close, but there are a few obvious problems: > >1) The break-on value is displayed, and >2) When I set the width to zero it still displays and the >"Totals: 'UV'" >label is suppressed/overwritten. > >I've fiddled with UDT.OPTIONS 25, 28, 43, and 98 with no >solution. I turn on UDT.OPTIONS 3, 7, 15, 23, 48, 54, 56, >66, 75, 78, 83, 89, 92, 104, and >114 (per Pick compatibility documentation) and ECLTYPE P and >BASICTYPE "P" >in the "LOGIN" (VOC) item. > >In Pick, one suppresses the column output of value "CNAME0" by >setting the column heading to "\" and a width of 0. e.g. > >DICT BANKBOOK 'CNAME0' size = 115 >01 S >02 1 >03 \ >04 >05 >06 >07 >08 F1;(TMASTER;X;;1);(CALL DTABP D.NAMELFM) >09 L >10 0 > >but it still can display in a break "Totals: 'UV'" label. Do >you know the "trick" I need to follow to SUPPRESS this break >value and print the break-on label? As always, thanks. > >Bill ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --------------------------------- Yahoo! Mail - Helps protect you from nasty viruses. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
