ISTech Support Forum - Address Labels

Welcome, Guest. Please Login.

	05/15/24 at 15:06:56 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › RTM Reports & Editing

‹ Previous topic | Next topic ›

Pages: 1

Address Labels (Read 1390 times)

carie Full Member Posts: 209 Gender:	Address Labels 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
Back to top	Evo-ERP Version 2015.2 with Build 7/02/2015 Pervasive 11.3 - 10 licenses / DBA since 2002 Carie Kirk McDantim Inc Helena, Montana IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: Address Labels Reply #1 - 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
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

carie Full Member Posts: 209 Gender:	Re: Address Labels Reply #2 - 11/17/11 at 09:45:51 I need the class codes that I Have set up in CM I might try access.
Back to top	Evo-ERP Version 2015.2 with Build 7/02/2015 Pervasive 11.3 - 10 licenses / DBA since 2002 Carie Kirk McDantim Inc Helena, Montana IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 785
Gender: male

Re: Address Labels
Reply #3 - 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)

Tongue

Kelloggs

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

carie Full Member Posts: 209 Gender:	Re: Address Labels Reply #4 - 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
Back to top	Evo-ERP Version 2015.2 with Build 7/02/2015 Pervasive 11.3 - 10 licenses / DBA since 2002 Carie Kirk McDantim Inc Helena, Montana IP Logged