Customer Ship To address

Yahoo Archive
1
Thanks Michael I'll try that!





Michelle Von Bokern

Office Manager

Advance Engineering Co.

PH: 630-628-3445

FAX: 630-628-3449

mvonbokern@... <mailto:mvonbokern@...>

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: Friday, November 03, 2006 10:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customer Ship To address



Use the Customer and ShipTo Tables in Crystal. Delete the Link
between ShipToNum on both tables. Add Fields Customer.CustomerName
ShipTo.ShipToNum .Name .Address .City .State .Zip.
Group By Customer.Customer Name
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Michelle VonBokern" <mvonbokern@...>
wrote:
>
> I need some help from you guys, please!
>
> I need to print a report that shows all customers (that part is easy
> enough), however I need it to also show all the ship to addresses
for
> each customer. That is where I am stuck.....
>
>
>
> Any help would be GREATLY appreciated.
>
> Thanks in advance
>
>
>
> Michelle Von Bokern
>
> Office Manager
>
> Advance Engineering Co.
>
> PH: 630-628-3445
>
> FAX: 630-628-3449
>
> mvonbokern@... <mailto:mvonbokern@...>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
I need some help from you guys, please!

I need to print a report that shows all customers (that part is easy
enough), however I need it to also show all the ship to addresses for
each customer. That is where I am stuck.....



Any help would be GREATLY appreciated.

Thanks in advance



Michelle Von Bokern

Office Manager

Advance Engineering Co.

PH: 630-628-3445

FAX: 630-628-3449

mvonbokern@... <mailto:mvonbokern@...>





[Non-text portions of this message have been removed]
3
Use the Customer and ShipTo Tables in Crystal. Delete the Link
between ShipToNum on both tables. Add Fields Customer.CustomerName
ShipTo.ShipToNum .Name .Address .City .State .Zip.
Group By Customer.Customer Name
--- In vantage@yahoogroups.com, "Michelle VonBokern" <mvonbokern@...>
wrote:
>
> I need some help from you guys, please!
>
> I need to print a report that shows all customers (that part is easy
> enough), however I need it to also show all the ship to addresses
for
> each customer. That is where I am stuck.....
>
>
>
> Any help would be GREATLY appreciated.
>
> Thanks in advance
>
>
>
> Michelle Von Bokern
>
> Office Manager
>
> Advance Engineering Co.
>
> PH: 630-628-3445
>
> FAX: 630-628-3449
>
> mvonbokern@... <mailto:mvonbokern@...>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Link Customer table to ShipTo table by CustNum and Company fields.
That sould be it. Hope this helps.

--- In vantage@yahoogroups.com, "Michelle VonBokern" <mvonbokern@...>
wrote:
>
> I need some help from you guys, please!
>
> I need to print a report that shows all customers (that part is easy
> enough), however I need it to also show all the ship to addresses
for
> each customer. That is where I am stuck.....
>
>
>
> Any help would be GREATLY appreciated.
>
> Thanks in advance
>
>
>
> Michelle Von Bokern
>
> Office Manager
>
> Advance Engineering Co.
>
> PH: 630-628-3445
>
> FAX: 630-628-3449
>
> mvonbokern@... <mailto:mvonbokern@...>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>