ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> RTM Reports & Editing >> Address Labels
http://www.istechforum.com/YaBB.pl?num=1321383313

Message started by carie on 11/15/11 at 11:55:12

Title: Address Labels
Post by carie on 11/15/11 at 11:55:12

I am printing Christmas card envelopes thru CM-B-B. I do not know how to make the addresses print "nicely". If I have Address Line 2 included it leaves a blank space there if it is blank and doesn't move it up. What is the trick?

~Carie

Title: Re: Address Labels
Post by Kelloggs on 11/16/11 at 12:04:33

Try AR-I

by the way you can not "trick" evo, if you want something nice use ms access or crystal reports

:D

Title: Re: Address Labels
Post by carie on 11/17/11 at 09:45:51

I need the class codes that I Have set up in CM

I might try access.

Title: Re: Address Labels
Post by Kelloggs on 11/17/11 at 14:00:07

ms access is the best!!!

SELECT
BKAR_CUSTCODE,
BKAR_CLASS,
BKAR_CUSTNAME,
BKAR_ADD1,
BKAR_ADD2_1,
ASCII(LTRIM(BKAR_ADD2_1)) AS AD21,
BKAR_ADD2_2,
ASCII(LTRIM(BKAR_ADD2_2)) AS AD22,
BKAR_CITY,
BKAR_STATE,
BKAR_ZIP,
BKAR_CONTACT_3,
BKAR_TELEPHONE_1,
BKAR_COUNTRY
FROM BKARCUST

AD21 AND AD22 if it shows 0 it is "Blank" (actually it isnt, it appears to be blank)

:P

Kelloggs

Title: Re: Address Labels
Post by carie on 11/17/11 at 16:29:39

I am not access literate. I made a query and then a form from that query - but I don't know were to put
this: :(

ASCII(LTRIM(BKAR_ADD2_1)) AS AD21

Thanks for your help

Title: Re: Address Labels
Post by Kelloggs on 11/18/11 at 08:16:47

The ASCII(LTRIM()) is to find out if a field is really empty or appears to be.

Evo fields are CHAR type. If you enter data or not they are fill with "something" that is the reason when
you concatenate two char fields, or print them you get a blank space.

have fun!!!

:-?

Kelloggs

PD: be careful about editing data. I thought you wanted to print a report. You shouldn't edit your tables use Evo
:-[