Iam creating a report for a client who wants to print a membership list for amusician’s union.The criteria are:
1.4 column report 2.Page headers and footers (conditional values forodd/even) 3.Alphabetical listing of members including up to 8fields of data, 1 per line: Lastname, First Street Street2 City,State,Zip HomePhone WorkPhone Email (IF a field permitting publishing of email = Y) A string of up to 10 instrument codesindicating what the member plays 4.Street2, either phone field and email could all be NULL 5.Suppress blank lines if a field is NULL 6.Name always exists and should be bold 7.Phone numbers and email should be in bold type if they exist Iknow a label would suppress the blank lines and create columns, but it wouldnot permit the page headers and footers desired, so a report is necessary InDOS versions, you could get the lines suppressed with a set of variables likethis: 1: TEXT: D : rName = (LName+","&FN) 2:TEXT: D : rCSC =(City+","&State&Zp) 3:TEXT: D : rEmail =(IFEQ(EmailPub,"Y",Email,NULL)) 4:TEXT: D : rInstList =(INSTR1&INSTR2&INSTR3&INSTR4&INSTR5&INSTR6&INSTR7&INSTR8&INSTR9&INSTR10) 5:TEXT: D : rLine1 =(LJS(.rName,50)+Street) 6 :TEXT: D : rLine2 =(LJS(.rLine1,100)+Inco) 7:TEXT: D : rLine3 =(LJS(.rLine2,150)+rCSC) 8:TEXT: D : rLine4 =(LJS(.rLine4,200)+HomePh) 9:TEXT: D : rLine5 =(LJS(.rline4,250)+Workph) 10:TEXT: D : rLine6 = (LJS(.rLine5,300)+rEmail) 11:TEXT: D : rLine7 =(LJS(.rline6,350)+.rInstList) Iremember seeing a way to do the same in Windows, but cannot locate it in Razzak’ssample applications on line, in From the Edge articles or in the sampledatabase.And then, we’ve got thosebold fields in the middle of the pile….. Any ideas? DavidBlocker "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261"
