Message-ID: <002001c1db26$4ff74590$14c22cc7@photon> From: "Josh Hillman" <admin-maillist@talstar.com> Subject: Re: [Emerald] Problem with e-mailed statements Date: Wed, 3 Apr 2002 10:43:33 -0500
There was a formula problem in the .rtp file that was causing the blank info
to appear. A while back, I took the formulas from the invoice and stuck it
into the statement and now it works fine. Here are the Crystal Reports
formulas:
@RetAddy:
{Groups.BillName} + Chr (13) + Chr (10) + if IsNull({Groups.BillAddress2})
then ({Groups.BillAddress1} + Chr (13) + Chr (10) + {@RetCSZ})
else ({Groups.BillAddress1} + Chr (13) + Chr (10) + {Groups.BillAddress2} +
Chr (13) + Chr (10) + {@RetCSZ})
@CustomerAddress:
if isnull({MasterAccounts.Company})
then {MasterAccounts.FirstName} + ' ' + {MasterAccounts.LastName}
else {MasterAccounts.Company} + Chr (13) + Chr (10) +
{MasterAccounts.FirstName} + ' ' + {MasterAccounts.LastName}
@addressblock:
IF IsNull({MasterAccounts.Address2}) OR Length ({MasterAccounts.Address2})<1
THEN ({MasterAccounts.Address1} + Chr (13) + Chr (10) + {@CSZ})
ELSE ({MasterAccounts.Address1} + Chr (13) + Chr (10) +
{MasterAccounts.Address2} + Chr (13) + Chr (10) + {@CSZ})
@CSZ:
{MasterAccounts.City} +", " + {MasterAccounts.State} + " "
+{MasterAccounts.Zip}
@RetCSZ:
{Groups.BillCity}+', '+{Groups.BillState}+' '+{Groups.BillZip}
Josh
----- Original Message -----
From: "Jason Newland" <newlandj@areatech.com>
To: <emerald@iea-software.com>
Sent: Tuesday, April 02, 2002 5:55 PM
Subject: RE: [Emerald] Problem with e-mailed statements
> We had the same problem. All we did to fix it was edit the report in
> crystal reports, and replace that field with a text field with the same
> data. It only works if you have one set of data to enter. (no pass thru
> billing)
>
>
>
> Jason
>
>
>
>
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com] On Behalf Of Paul R Bennett
> Sent: Tuesday, April 02, 2002 4:50 PM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] Problem with e-mailed statements
>
> i get the same thing
> ----- Original Message -----
> From: Kurt Schafer <mailto:kahuna@cyberbeach.net>
> To: emerald@iea-software.com
> Sent: Tuesday, April 02, 2002 2:26 PM
> Subject: [Emerald] Problem with e-mailed statements
>
> I've tried sending a couple of statements out via the included
> 'estatement' Crystal Report.
>
> Looking at the Crystal Report, it appears that the upper left region of
> the statement is supposed to contain our company information (mailing
> address, etc) but the statements themselves are blank in this regard.
>
> The Billing Group tables are populated appropriately with this info.
>
> Anybody have any ideas ?
>
> = K
>
.