Crystal Reports - Sales Order

Yahoo Archive
1
David,

It is in Report - Crystal Reports and is called Sales Order Report.rpt. My
ID is aelinuxguy.

AE

-----Original Message-----
From: David M Gartner [mailto:dgartner@...]
Sent: Wednesday, May 22, 2002 11:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - Sales Order


Your Sales Order Acknowledgement report isn't listed any longer. Could you
please email it to me directly. Thanks! I work well from an example.

David
dgartner@...

-----Original Message-----
From: Adam Ellis [mailto:adame@...]
Sent: Wednesday, May 22, 2002 10:20 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports - Sales Order


Ahh...yes, you will need to have ODBC set up first and rewrite the report to
not use the local DBF tables. I put a Sales Order Acknowledgement report
out in the files section on the yahoo group a while back that should get you
started (once you've got ODBC set up on your server and client). You should
be able to drop the SalesRepList field onto the report and see the data
without any modifications. Let me know once you get that far and we'll walk
you through making it more presentable.

AE



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=226020.2067224.3532861.1971030/D=egroupweb/S=17050071
83:HM/A=1073422/R=0/*http://www.qksrv.net/click-1084497-610300?url=http://ww
w.tv/en/landing.shtml&HHcode=yhc3my2>

<http://us.adserver.yahoo.com/l?M=226020.2067224.3532861.1971030/D=egroupmai
l/S=1705007183:HM/A=1073422/rand=408007880>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Good Evening,

Management would like me to display all of the Sales Reps involved with a
sale on the Sales Order form. I found in the data dictionary the field I
think I need (Orderhed.SalesRepList) to get started. However, this doesn't
appear as an option when I try to insert it as a field object inside
Crystal. Please help.

David Gartner
EPG Companies Inc.
p:763-424-2613 f:763-493-4812



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

This field cannot be used in formulas in Crystal because it is too long (aka
a blob field). If you are using Crystal 8 or newer you can use the
substring function in a SQL Expression Field to chop it down to 255
characters. Otherwise you will need to go into the Progress data dictionary
and change the field size from 1000 to 255.

AE

-----Original Message-----
From: David M Gartner [mailto:dgartner@...]
Sent: Tuesday, May 21, 2002 6:46 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Crystal Reports - Sales Order


Good Evening,

Management would like me to display all of the Sales Reps involved with a
sale on the Sales Order form. I found in the data dictionary the field I
think I need (Orderhed.SalesRepList) to get started. However, this doesn't
appear as an option when I try to insert it as a field object inside
Crystal. Please help.

David Gartner
EPG Companies Inc.
p:763-424-2613 f:763-493-4812



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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=226020.2067224.3532861.1971030/D=egroupweb/S=17050071
83:HM/A=1073422/R=0/*http://www.qksrv.net/click-1084497-610300?url=http://ww
w.tv/en/landing.shtml&HHcode=yhc3my2>

<http://us.adserver.yahoo.com/l?M=226020.2067224.3532861.1971030/D=egroupmai
l/S=1705007183:HM/A=1073422/rand=652432337>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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

I am using Crystal 8 and Progress. How would you go about creating a SQL
Express field cutting down the field to 255 characters? I just got off the
phone with Epicor and they said I would need to set up the ODBC link
first...

David

-----Original Message-----
From: Adam Ellis [mailto:adame@...]
Sent: Wednesday, May 22, 2002 7:00 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports - Sales Order

David,

This field cannot be used in formulas in Crystal because it is too long (aka
a blob field). If you are using Crystal 8 or newer you can use the
substring function in a SQL Expression Field to chop it down to 255
characters. Otherwise you will need to go into the Progress data dictionary
and change the field size from 1000 to 255.

AE


-----Original Message-----
From: David M Gartner [mailto:dgartner@...]
Sent: Tuesday, May 21, 2002 6:46 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Crystal Reports - Sales Order

Good Evening,

Management would like me to display all of the Sales Reps involved with a
sale on the Sales Order form. I found in the data dictionary the field I
think I need (Orderhed.SalesRepList) to get started. However, this doesn't
appear as an option when I try to insert it as a field object inside
Crystal. Please help.

David Gartner
EPG Companies Inc.
p:763-424-2613 f:763-493-4812
5
Ahh...yes, you will need to have ODBC set up first and rewrite the report to
not use the local DBF tables. I put a Sales Order Acknowledgement report
out in the files section on the yahoo group a while back that should get you
started (once you've got ODBC set up on your server and client). You should
be able to drop the SalesRepList field onto the report and see the data
without any modifications. Let me know once you get that far and we'll walk
you through making it more presentable.

AE

-----Original Message-----
From: David M Gartner [mailto:dgartner@...]
Sent: Wednesday, May 22, 2002 10:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - Sales Order


Adam,

I am using Crystal 8 and Progress. How would you go about creating a SQL
Express field cutting down the field to 255 characters? I just got off the
phone with Epicor and they said I would need to set up the ODBC link
first...

David

-----Original Message-----
From: Adam Ellis [mailto:adame@...]
Sent: Wednesday, May 22, 2002 7:00 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports - Sales Order

David,

This field cannot be used in formulas in Crystal because it is too long (aka
a blob field). If you are using Crystal 8 or newer you can use the
substring function in a SQL Expression Field to chop it down to 255
characters. Otherwise you will need to go into the Progress data dictionary
and change the field size from 1000 to 255.

AE


-----Original Message-----
From: David M Gartner [mailto:dgartner@...]
Sent: Tuesday, May 21, 2002 6:46 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Crystal Reports - Sales Order

Good Evening,

Management would like me to display all of the Sales Reps involved with a
sale on the Sales Order form. I found in the data dictionary the field I
think I need (Orderhed.SalesRepList) to get started. However, this doesn't
appear as an option when I try to insert it as a field object inside
Crystal. Please help.

David Gartner
EPG Companies Inc.
p:763-424-2613 f:763-493-4812



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=226020.2067224.3532861.1971030/D=egroupweb/S=17050071
83:HM/A=1073422/R=0/*http://www.qksrv.net/click-1084497-610300?url=http://ww
w.tv/en/landing.shtml&HHcode=yhc3my2>

<http://us.adserver.yahoo.com/l?M=226020.2067224.3532861.1971030/D=egroupmai
l/S=1705007183:HM/A=1073422/rand=161891110>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
6
Your Sales Order Acknowledgement report isn't listed any longer. Could you
please email it to me directly. Thanks! I work well from an example.

David
dgartner@...

-----Original Message-----
From: Adam Ellis [mailto:adame@...]
Sent: Wednesday, May 22, 2002 10:20 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports - Sales Order


Ahh...yes, you will need to have ODBC set up first and rewrite the report to
not use the local DBF tables. I put a Sales Order Acknowledgement report
out in the files section on the yahoo group a while back that should get you
started (once you've got ODBC set up on your server and client). You should
be able to drop the SalesRepList field onto the report and see the data
without any modifications. Let me know once you get that far and we'll walk
you through making it more presentable.

AE