Using Memo fields in Crystal Reports 8.5/Vantage 6.1

You are correct Todd. A verify will do the trick.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@...> wrote:
>
> Are you sure about #5? I thought doing a "verify database" would
refresh the fields info in the tables. I have not tried a truncate
but for most of what I would want to access a memo field for re-
writing is not an option. If verify does not work I may never try a
truncate.
> Thanks,
> -Todd C.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of Phyllis The
> Sent: Monday, March 19, 2007 4:25 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Using Memo fields in Crystal Reports 8.5/Vantage
6.1
>
>
>
> We have truncated dozens of character fields used on VB forms for
use in CR.
> Look at Answer Book#3604MPS for how to truncate Memo fields so they
can be used in Crystal Reports 8.5
>
> A few caveats about this:
>
> 1. No one can be logged into Vantage when you perform this
procedure.
> 2. Do NOT take the database down.
> 3. Use the Sysprogress login and password.
> 4. Training database must be done separately from your live
database.
> 5. None of the truncated fields will be available for use in ANY
existing CR report.
> You will have to create new reports to use the truncated fields.
>
> Good luck!
>
> Phyllis Thé
> Accounting Manager
> ATP Applied Thin-Film Products
> 3439 Edison Way Fremont, CA 94538
> Telephone: 510-661-4287 ext. 43
> Fax: 510-661-4257
> Web: www.thinfilm.com
>
> 2b.
> Re: ODBC Error- Exceeding its max length -Vantage 6.1 Merant Driv <
http://groups.
<http://groups.yahoo.com/group/vantage/message/55498;_ylc=X3oDMTJwMnFz
ZW5zBF9TAzk3MzU5NzE1BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRtc2dJZA
M1NTQ5OARzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMTc0MzM2MzYz>
yahoo.com/group/vantage/message/55498;_ylc=X3oDMTJwMnFzZW5zBF9TAzk3MzU
5NzE1BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRtc2dJZAM1NTQ5OARzZWMDZ
G1zZwRzbGsDdm1zZwRzdGltZQMxMTc0MzM2MzYz>
> Posted by: "Rob Fiddelke" rob@rapidts. <mailto:rob%40rapidts.com>
com <mailto: rob@rapidts. <mailto:rob%40rapidts.com> com?Subject=%
20Re%3A%20ODBC%20Error-%20Exceeding%20its%20max%20length%20%20%20-
Vantage%206%2E1%20Merant%20%20Driv> rfiddelke1 < http://profiles.
<http://profiles.yahoo.com/rfiddelke1> yahoo.com/rfiddelke1>
> Mon Mar 19, 2007 7:52 am (PST)
> I'm having the problem within Crystal and have not been able to
resolve
> it using the method below.
>
> For some reason fields with a type of Memo are not available for
Crystal
> formulas or Sql expressions.
>
> Rob
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups
<mailto:vantage%40yahoogroups.com> .com <mailto:vantage%
40yahoogroups.com> ] On Behalf
> Of Olson, Brian
> Sent: Monday, March 19, 2007 10:37 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] ODBC Error- Exceeding its max length -
Vantage 6.1
> Merant Driver
>
> Thanks.......Any ideas about crystal reports?
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
We have truncated dozens of character fields used on VB forms for use in CR.
Look at Answer Book#3604MPS for how to truncate Memo fields so they can be used in Crystal Reports 8.5

A few caveats about this:

1. No one can be logged into Vantage when you perform this procedure.
2. Do NOT take the database down.
3. Use the Sysprogress login and password.
4. Training database must be done separately from your live database.
5. None of the truncated fields will be available for use in ANY existing CR report.
You will have to create new reports to use the truncated fields.


Good luck!

Phyllis Thé
Accounting Manager
ATP Applied Thin-Film Products
3439 Edison Way Fremont, CA 94538
Telephone: 510-661-4287 ext. 43
Fax: 510-661-4257
Web: www.thinfilm.com

2b.
Re: ODBC Error- Exceeding its max length -Vantage 6.1 Merant Driv <http://groups.yahoo.com/group/vantage/message/55498;_ylc=X3oDMTJwMnFzZW5zBF9TAzk3MzU5NzE1BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRtc2dJZAM1NTQ5OARzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMTc0MzM2MzYz>
Posted by: "Rob Fiddelke" rob@... <mailto:rob@...?Subject=%20Re%3A%20ODBC%20Error-%20Exceeding%20its%20max%20length%20%20%20-Vantage%206%2E1%20Merant%20%20Driv> rfiddelke1 <http://profiles.yahoo.com/rfiddelke1>
Mon Mar 19, 2007 7:52 am (PST)
I'm having the problem within Crystal and have not been able to resolve
it using the method below.

For some reason fields with a type of Memo are not available for Crystal
formulas or Sql expressions.

Rob

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
Of Olson, Brian
Sent: Monday, March 19, 2007 10:37 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC Error- Exceeding its max length -Vantage 6.1
Merant Driver

Thanks.......Any ideas about crystal reports?






[Non-text portions of this message have been removed]
Are you sure about #5? I thought doing a "verify database" would refresh the fields info in the tables. I have not tried a truncate but for most of what I would want to access a memo field for re-writing is not an option. If verify does not work I may never try a truncate.
Thanks,
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Phyllis The
Sent: Monday, March 19, 2007 4:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Using Memo fields in Crystal Reports 8.5/Vantage 6.1



We have truncated dozens of character fields used on VB forms for use in CR.
Look at Answer Book#3604MPS for how to truncate Memo fields so they can be used in Crystal Reports 8.5

A few caveats about this:

1. No one can be logged into Vantage when you perform this procedure.
2. Do NOT take the database down.
3. Use the Sysprogress login and password.
4. Training database must be done separately from your live database.
5. None of the truncated fields will be available for use in ANY existing CR report.
You will have to create new reports to use the truncated fields.

Good luck!

Phyllis Thé
Accounting Manager
ATP Applied Thin-Film Products
3439 Edison Way Fremont, CA 94538
Telephone: 510-661-4287 ext. 43
Fax: 510-661-4257
Web: www.thinfilm.com

2b.
Re: ODBC Error- Exceeding its max length -Vantage 6.1 Merant Driv < http://groups. <http://groups.yahoo.com/group/vantage/message/55498;_ylc=X3oDMTJwMnFzZW5zBF9TAzk3MzU5NzE1BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRtc2dJZAM1NTQ5OARzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMTc0MzM2MzYz> yahoo.com/group/vantage/message/55498;_ylc=X3oDMTJwMnFzZW5zBF9TAzk3MzU5NzE1BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRtc2dJZAM1NTQ5OARzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMTc0MzM2MzYz>
Posted by: "Rob Fiddelke" rob@rapidts. <mailto:rob%40rapidts.com> com <mailto: rob@rapidts. <mailto:rob%40rapidts.com> com?Subject=%20Re%3A%20ODBC%20Error-%20Exceeding%20its%20max%20length%20%20%20-Vantage%206%2E1%20Merant%20%20Driv> rfiddelke1 < http://profiles. <http://profiles.yahoo.com/rfiddelke1> yahoo.com/rfiddelke1>
Mon Mar 19, 2007 7:52 am (PST)
I'm having the problem within Crystal and have not been able to resolve
it using the method below.

For some reason fields with a type of Memo are not available for Crystal
formulas or Sql expressions.

Rob

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com <mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com <mailto:vantage%40yahoogroups.com> ] On Behalf
Of Olson, Brian
Sent: Monday, March 19, 2007 10:37 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC Error- Exceeding its max length -Vantage 6.1
Merant Driver

Thanks.......Any ideas about crystal reports?

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







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