Ihave tried to follow the directions from Doug Hamilton and Sami Aaron and Karen Tellef for this kind of report and after far too muchtime I have to turn to the list again to see what I?m doing wrong.
Hereare the key facts about the report, which is a membership directory for aMusicians? Union: 1.This is COLUMNAR report:File / Page Setup / Layout / Columns 4 2.Because of space issues, the font is small: Arial 8 forall fields 3.There could be as many as 8 lines of data for eachlisting: top line is far left, other 7 are slightly indented to the right.So an example of a successful entry with all8 lines not null would be: Brown,Roger 3 Main St. Apt. 3 Boston, MA02112 (617)333-4455 (781)999-8877 [email protected] WCWJ WK If say, Street2 was blank it wouldbe: Brown,Roger 3 Main St. Boston, MA02112 (617)333-4455 (781)999-8877 [email protected] WCWJ WK Specs: Field Font NULLs possible? Full Name (Last / First) Bold No Street Normal No Street 2 Normal Yes City, State Zip Normal No Home Phone Bold Yes Work Phone Bold Yes Email * Bold Yes Instruments Played** Normal Yes *Email is a very long field and so thedata should wrap onto a second line if necessary: it should NOT be truncated **Instruments are up to 10 possible 2letter codes representing instruments the musician plays Thereport is based on a view that does all the concatenating needed (for fullname, for City, state zip, and for instruments played list) Nevermind getting the groups to print together in a column without going to the nextcolumn:all I?ve tried to do so far is toget the spacing between the lines right.I?m having a lot of trouble right there. >From John?s email it wasn?t clear to me whetherthere should be ONE region / >rich text object per line desired, or if you could/ should put more than one >line in a rich text object.John, for example, your directions from Samiread: ?In the Edit Window, Choosethe Edit Menu and then Insert Fields - choose Person1. Press ENTER to go to the next line in thetext box and Edit / Insert Fields and choose Person2. Clickthe "x" to close the Rich Text window.? Thisimplied to me more than one row ofdata in each Rich Text object Butlater you said: ?I just created a member directory report.Each listing may have from one to five lines (lastname/firstname, children'snames, addr1, addr2 & CSZ).Itworks great! Each line is a rich textobject in its own region thatstretches and shifts relative to the preceding region? ? Thisimplied to me only one row of datain each Rich Text object Whatever? neither is giving me what I want.I?veonly tried so far to get the first 4 rows of the 8 rows to be what I want.Here?s what I?ve tried and what?s happened: Trial1: ONE line of data per Rich Text Object Region Settings Contains Rich T Obj Settings Contains Results Region1 Stretch Visible No line RTO 1 RTO 1 Mailmerge Stretch Visible Full Name Prints fine Region2 Stretch Visible Shift Relative to Region 1 No line RTO 2 RTO 2 Mailmerge Stretch Visible Street No matter how close to Region1 I place these two, I get the equivalent of a DOUBLE space between Fullname and street: in my latest version, Region2 OVERLAPS region1 and I still get the spacing error Region3 Stretch Visible Shift Relative to Region 2 No line RTO3 RTO3 Mailmerge Stretch Visible Street 2 If there is NO Value, the blank line is suppressed, but again too much spacing between Street and CSZ below If there IS Street 2, it is TOO close to CSZ, with CSZ slightly overlapping it, even if place region4 WAY below region 3 Region4 Stretch Visible Shift Relative to Region 3 No line RTO4 RTO4 Mailmerge Stretch Visible City, State Zip See above Resultsare like this if there?s no street2: Brown,Roger 3 Main St. Boston, MA02112 Likethis if there is a street2 Brown,Roger 3 Main St. Apt. 3 Boston, MA02112 (Bostonline slightly overlaps the Apt 3 line) I?vetried, making the region object larger than the Rich text object inside it,making the size of the Region and RTO?s the same ? it has no effect.I can even appear to drag the RTO outside theregion and it has no effect.My currentreport screen is jammed and wierd looking from trying to move objects to reducespacing between lines. IfI try putting Fullname and Street together in the first region, with Street aline below fullname, the spacing between Fullname and street is perfect, butthen I get a huge space between that the next line: Brown,Roger 3 Main St. Boston, MA02112 Helpwould be appreciated! DavidBlocker "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261"
