Hi Todd
ODBC works fine for us. I run at least 12 ODBC reports - no problem.
Regards Chris Reed
PWSL
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday 08 December, 2000 18:38
To: 'vantage@egroups.com'
Subject: [Vantage] Before I call Custom Programming...
I can't make myself call Custom Programming without checking here first. I
am really frustrated by the lack of useful fields available in the standard
Crystal Reports. I have been told by tech support that trying to ODBC link
to other tables is iffy and that I am stuck with what is provided.
I have two big needs at the moment for additional information on
reports/forms:
1. Must have PO number for subcontract operations print on the Job Traveler.
It would be so easy to get from the PORel table. I actually had it working
once before we went live and then a required version update did something to
it. Our shipping people need the correct PO# for a job when we have many
jobs going to the same vendor.
2.We must have customer comments available for order acknowledgements and
Travelers. I need to add some keyword based phrases to parse for and print
- such as "Ack:Do not mail" or "ShipQty:Exact". and then extract the part
after the colon and print it on the form.
Is it possible to link to other tables? Are there instructions anywhere to
do this? Does every user have to have Merrant ODBC installed? Will Custom
Programming even add info to the .dbf files if I have to go that route?
Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.
Woodbury, MN
651-739-7373
ODBC works fine for us. I run at least 12 ODBC reports - no problem.
Regards Chris Reed
PWSL
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday 08 December, 2000 18:38
To: 'vantage@egroups.com'
Subject: [Vantage] Before I call Custom Programming...
I can't make myself call Custom Programming without checking here first. I
am really frustrated by the lack of useful fields available in the standard
Crystal Reports. I have been told by tech support that trying to ODBC link
to other tables is iffy and that I am stuck with what is provided.
I have two big needs at the moment for additional information on
reports/forms:
1. Must have PO number for subcontract operations print on the Job Traveler.
It would be so easy to get from the PORel table. I actually had it working
once before we went live and then a required version update did something to
it. Our shipping people need the correct PO# for a job when we have many
jobs going to the same vendor.
2.We must have customer comments available for order acknowledgements and
Travelers. I need to add some keyword based phrases to parse for and print
- such as "Ack:Do not mail" or "ShipQty:Exact". and then extract the part
after the colon and print it on the form.
Is it possible to link to other tables? Are there instructions anywhere to
do this? Does every user have to have Merrant ODBC installed? Will Custom
Programming even add info to the .dbf files if I have to go that route?
Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.
Woodbury, MN
651-739-7373