Programming in Crystal Reports - Calculated field needed

Yahoo Archive
1
Thanks for the info, Karen!

M


M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Karen Schoenung
Sent: Tuesday, February 10, 2009 2:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Crystal Reports - Calculated field
needed



TIA,

I am not sure I understand, but I think this is what you are looking
for...I did not check for formatting formula in Crystal, just giving the
"idea" of what you need here...

Well, in Crystal, you can have a formula in your NAME_ADDR_TEXT fields
similar to:

If Cust = XXX then Name = ShipToName

Addr = BillToAddr

Else if Cust <>XXX then Name = ShipToName

Addr= ShipToAddr

Karen S

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Tuesday, February 10, 2009 2:39 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Programming in Crystal Reports - Calculated field
needed

Ok, I am not a programmer...

Wondering if the Crystal reports gurus out there can do this or not.

First we are on version 8.00.812

I have a customer who has many branches. Any of these branches can buy
for any other branch. But for MOST of the branches there is one bill
to. Some may pay it themselves, but the one branch pays for the rest.

I know 8.03 has multiple bill tos, not there yet, so here is my
question:

For AR invoices I need the customer ship to name to print, but the
address of the bill to to print. I only need it for this one customer's
branches. All of my other 1000 customers do not need this. So it is
not as easy as just putting the customer name in the bill to box on the
form.

Any ideas on how to modify my AR Invoice form?

TIA

M. Manasa Reddy
Information Technology Manager
Welding Company of America
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
2
Ok, I am not a programmer...

Wondering if the Crystal reports gurus out there can do this or not.

First we are on version 8.00.812

I have a customer who has many branches. Any of these branches can buy
for any other branch. But for MOST of the branches there is one bill
to. Some may pay it themselves, but the one branch pays for the rest.

I know 8.03 has multiple bill tos, not there yet, so here is my
question:

For AR invoices I need the customer ship to name to print, but the
address of the bill to to print. I only need it for this one customer's
branches. All of my other 1000 customers do not need this. So it is
not as easy as just putting the customer name in the bill to box on the
form.

Any ideas on how to modify my AR Invoice form?

TIA



M. Manasa Reddy
Information Technology Manager
Welding Company of America
manasa@...
P: 630-806-2000
F: 630-806-2001



[Non-text portions of this message have been removed]
3
TIA,

I am not sure I understand, but I think this is what you are looking
for...I did not check for formatting formula in Crystal, just giving the
"idea" of what you need here...







Well, in Crystal, you can have a formula in your NAME_ADDR_TEXT fields
similar to:



If Cust = XXX then Name = ShipToName

Addr = BillToAddr

Else if Cust <>XXX then Name = ShipToName

Addr= ShipToAddr





Karen S



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Tuesday, February 10, 2009 2:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Programming in Crystal Reports - Calculated field
needed



Ok, I am not a programmer...

Wondering if the Crystal reports gurus out there can do this or not.

First we are on version 8.00.812

I have a customer who has many branches. Any of these branches can buy
for any other branch. But for MOST of the branches there is one bill
to. Some may pay it themselves, but the one branch pays for the rest.

I know 8.03 has multiple bill tos, not there yet, so here is my
question:

For AR invoices I need the customer ship to name to print, but the
address of the bill to to print. I only need it for this one customer's
branches. All of my other 1000 customers do not need this. So it is
not as easy as just putting the customer name in the bill to box on the
form.

Any ideas on how to modify my AR Invoice form?

TIA



M. Manasa Reddy
Information Technology Manager
Welding Company of America
manasa@... <mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001


[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]