Alastair, Thanks, I'll save your reply for my 7.0 This customer only has dos 6.5++ and R:Merge works fine on this database. If I can't solve this problem, my work around would be to give him a label program in his dos app (but then he would have to pay me and would not be a happy camper after paying for R:Merge, and he wouldn't be able to easily change the layout and the where clause as he can in R:Merge). Bernie Lis ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Sunday, September 07, 2003 3:28 AM Subject: [RBASE-L] - Re: R:Merge 1.4 Label print problem
> Bernie, > > If you are printing to a file and using a Report Definition rather than a > Label one then I would suggest that you copy your R:Base report to a new one > and amend it thus: > > Layout| Report Settings| Lines per page: 100 - why 100? I don't know but it > works & higher doesn't! > Layout| Report Settings| Print Orientation: None > > Try not to use the AutoExpand option but do have your fields large enough > across the page to hold all the data you expect. You can get some very > strange positioning in a file with AutoExpand set on. > > Ensure that the left margin is at the left of the page - ie: no margin. > Ensure that the right margin is well past the right-hand edge of any/every > field. > > Try to have the fields _just_ touching vertically with no white space > between them but ensure that the green section dividers are not touched by > anything. > > I have never used the Label Designer so I have no idea how that might be > different but, hopefully, somebody else will be able to help you. If not, > try applying what you can of the above. It took me a long time to get > reports printed to a file successfully but those rules seem to make it work. > > One other thing, check for any form of corruption in your data - I've had > problems with "unusual" characters that have appeared to thrown R:Base - > accented letters, that sort of thing, and the usual "unprintables" - CR/LF > etc. > > Good luck, > Regards, > Alastair. > > > ----- Original Message ----- > From: "Bernard Lis" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Sunday, September 07, 2003 4:49 AM > Subject: [RBASE-L] - R:Merge 1.4 Label print problem > > > > I need to print labels to disk to send to a printer who will print them on > > circulars. 29,971 labels were printed. The printing company reads only > > about 3,000 records (I haven't yet contacted them to know how they are > > reading the file) > > > > I printed to .txt file > > Then to prove there are 29,971 labels, I loaded them into a separate > > database, one table, text 80 (the labels shouldn't be more than 40 > > characters wide) but during the load,I get truncation errors. > > There will be blank lines between labels, some will have 3 lines some 4. > > After the load I deleted all null records. What is left, If I divide by > 3, > > I would get about 3,000 labels. Same as what the printer got. > > > > However, if at a dos prompt, I type the .txt file, the last record that > > displays is the correct expected last label. > > I believe they are all there, but I don't know how to read them back. > > > > Then I printed them as a pdf file (I don't know if the printing co. can > > handle a pdf file some addresses are split between pages (is there a way > to > > prevent any widows & orphans in a pdf file?). But they are all there. > > 2,457 pages at approx 12 per page gives me the approx total of 29,971 > > > > Then I printed them as RTF. after the preview is generated, I get the > error > > "bitmap image is not valid" > > The size of the resultant file is 565 bytes. > > > > The pdf file is 6,768,547 bytes. > > the txt file is 1,807,435 bytes. > > > > What should I do? > > > > Bernie Lis > > > > --- RBASE-L > > ================================================ > > TO POST A MESSAGE TO ALL MEMBERS: > > Send a plain text email to [EMAIL PROTECTED] > > > > (Don't use any of these words as your Subject: > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message SUBJECT, put just one word: INTRO > > ================================================ > > TO UNSUBSCRIBE: > > Send a plain text email to [EMAIL PROTECTED] > > In the message SUBJECT, put just one word: UNSUBSCRIBE > > ================================================ > > TO SEARCH ARCHIVES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message SUBJECT, put just one word: SEARCH-n > > (where n is the number of days). In the message body, > > place any > > text to search for. > > ================================================ > > >
