Memo Report

_
I called Vantage techsupport on this once before. You need to go into the data dictionary and make a change to the design of the ODBC property for the field in question (field length to 254 chars). I don't remember the exact procedure but it requires a restart of the database. You must be extremely careful as you can really screw up your database in here. I woldn't procede without some better instruction. But know that it can be done. __________________________________________________________________
Message: 5
Date: Wed, 21 Jul 2004 12:56:55 -0400
From: "Jim Horton" <jim.horton@...>
Subject: Memo Report

Does anyone know how to print a memo to a job number? An example in Crystal or Report Builder would be great.

Jim Horton
Mol-Son, Inc.
jim.horton@...








[Non-text portions of this message have been removed]
Does anyone know how to print a memo to a job number? An example in Crystal or Report Builder would be great.

Jim Horton
Mol-Son, Inc.
jim.horton@...
As far as I know you can not get a memo field from Vantage via ODBC. There is a 3000 character limit on the Merant ODBC driver. Please correct me if I am wrong (PLEASE PLEASE PLEASE) This makes it a total pain to get a memo field. The only solution I have come up with is to use provision and do a data export of the field to a text file. I take it one step further and (useing SQL SERVER DTS) import it to MS SQL Server so that its easy to work with via ODBC.

Hope that helps
Jeremy


-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Wednesday, July 21, 2004 11:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Memo Report


Does anyone know how to print a memo to a job number? An example in Crystal or Report Builder would be great.

Jim Horton
Mol-Son, Inc.
jim.horton@...



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/.
(2) To search through old msg's goto: 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
Yahoo! Groups Links
another solution providing you do not plan to go over 3000 characters would
be to actually change the db field size.



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Jeremy Leonard [mailto:jeremy.leonard@...]
Sent: Wednesday, July 21, 2004 1:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Memo Report


As far as I know you can not get a memo field from Vantage via ODBC. There
is a 3000 character limit on the Merant ODBC driver. Please correct me if I
am wrong (PLEASE PLEASE PLEASE) This makes it a total pain to get a memo
field. The only solution I have come up with is to use provision and do a
data export of the field to a text file. I take it one step further and
(useing SQL SERVER DTS) import it to MS SQL Server so that its easy to work
with via ODBC.

Hope that helps
Jeremy


-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Wednesday, July 21, 2004 11:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Memo Report


Does anyone know how to print a memo to a job number? An example in Crystal
or Report Builder would be great.

Jim Horton
Mol-Son, Inc.
jim.horton@...



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/.
(2) To search through old msg's goto:
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
Yahoo! Groups Links







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/.
(2) To search through old msg's goto:
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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129tgnvl8/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1090518198/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=678792890>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


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



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



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