One note...the instructions below are good for adding the entire field to the report/form but will not allow using in a formula if the field type is Memo..that is those fields that are 1000 characters long and exceed the CR 8.5 limit (now thinking it is 255 characters). The field has to be truncated in the data dictionary view to allow CR to deal with it as a String type field and be in any type of formula. A limitation in CR 8.5.
-Todd C.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of warren klug
Sent: Monday, June 04, 2007 8:14 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage[6.1] memo fields in Crystal 8.5
try this:
SUMMARY: How to add VB fields to a Crystal Form
1. Create VB Form with fields. (i.e. JobHead, JobOper, InvcHead, etc. ).
2. Give each field a unique "External" name by double clicking on the field and filling in the "External Name" field. Make a note of the two letter prefix preceding each field.
3. Go to where ever it is you added the VB Form (i.e. JobHead, JobOper, InvcHead, etc. ) and fill the VB Form field with information.
4. Print or Print Preview the Crystal Form once.
5. Open Crystal form in Crystal Pro and select Database --> Verify Database.
6. Next, select Insert --> Database field, and find VB form Fields with their external names.
7. Insert the DB fields into form.
Todd Caughey <caugheyt@...<mailto:caugheyt%40harveyvogel.com>> wrote:
There is a workaround...I don't have the details but I believe they are in the Epicor/Vantage knowledgebase. Gist of the solution is to truncate the field's view in the data dictionary to a size allowable by Crystal (250?) for use in a formula. Downside is the data past the point of truncating is not available.
-Todd C.
________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Dennis Houghton
Sent: Friday, June 01, 2007 11:47 AM
To: vantage
Subject: [Vantage] Vantage[6.1] memo fields in Crystal 8.5
I am trying to select vbform character fields in Crystal reports and
create a formula to suppress on condition but the fields are not
available to select for formulas. Does anyone know how I can fix or
workaround this?
Thanks
Dennis
________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.
Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.
For more information please visit www.harveyvogel.com
[Non-text portions of this message have been removed]
---------------------------------
Get the Yahoo! toolbar and be alerted to new email wherever you're surfing.
[Non-text portions of this message have been removed]
________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.
Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.
For more information please visit www.harveyvogel.com
[Non-text portions of this message have been removed]
-Todd C.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of warren klug
Sent: Monday, June 04, 2007 8:14 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage[6.1] memo fields in Crystal 8.5
try this:
SUMMARY: How to add VB fields to a Crystal Form
1. Create VB Form with fields. (i.e. JobHead, JobOper, InvcHead, etc. ).
2. Give each field a unique "External" name by double clicking on the field and filling in the "External Name" field. Make a note of the two letter prefix preceding each field.
3. Go to where ever it is you added the VB Form (i.e. JobHead, JobOper, InvcHead, etc. ) and fill the VB Form field with information.
4. Print or Print Preview the Crystal Form once.
5. Open Crystal form in Crystal Pro and select Database --> Verify Database.
6. Next, select Insert --> Database field, and find VB form Fields with their external names.
7. Insert the DB fields into form.
Todd Caughey <caugheyt@...<mailto:caugheyt%40harveyvogel.com>> wrote:
There is a workaround...I don't have the details but I believe they are in the Epicor/Vantage knowledgebase. Gist of the solution is to truncate the field's view in the data dictionary to a size allowable by Crystal (250?) for use in a formula. Downside is the data past the point of truncating is not available.
-Todd C.
________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Dennis Houghton
Sent: Friday, June 01, 2007 11:47 AM
To: vantage
Subject: [Vantage] Vantage[6.1] memo fields in Crystal 8.5
I am trying to select vbform character fields in Crystal reports and
create a formula to suppress on condition but the fields are not
available to select for formulas. Does anyone know how I can fix or
workaround this?
Thanks
Dennis
________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.
Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.
For more information please visit www.harveyvogel.com
[Non-text portions of this message have been removed]
---------------------------------
Get the Yahoo! toolbar and be alerted to new email wherever you're surfing.
[Non-text portions of this message have been removed]
________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.
Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.
For more information please visit www.harveyvogel.com
[Non-text portions of this message have been removed]