Adding VB checkbox - ODBC?

Yahoo Archive
1
Got everything figured out in case anyone was wondering. It appears that
the last person to use Crystal Reports had everything setup for a much
older configuration. As opposed to having the work folder on a local
drive, we now have it out on a server as we use terminal services now. I
reset the default drive paths to the mapped network drive for Crystal
and then .dbf's started working smoothly.



I made a new Formula Field for my field and used this (crystal syntax)
formula:



if {podetail.PDROHS1} = false

then "RoHS WOOT WOOT"

else ""



Of course the "RoHS WOOT WOOT" will be replaced by some professional
sounding text once we decide on the statement that works for us. Also,
the false/true of the statement is undecided, as we will find if we want
the statement default on or off. Works great, using it per line item per
PO.



Thanks for the help everyone.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Monday, July 10, 2006 5:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding VB checkbox - ODBC?



After making the VB Form change and identifying the external name have
you done a print preview of a PO (to load the .dbf) and then in Crystal
done a Verify Database? This last part adds the new field when Crystal
goes out to the DBF file and sees the field names. You can also verify
if the new field is there by opening the .dbf file with a spreadsheet
program like Excel incase the verify database is not seeing it.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of Brian Bricker
Sent: Monday, July 10, 2006 3:24 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Adding VB checkbox - ODBC?

I have tried this, but I receive an error for all fields within the form
- Cannot find xxxxx in c:\vntgwork\xxxx.dbf.

I assumed this was some sort of database connection issue. I am logged
into vantage locally, but my vntgwork file does not reside in that
location.

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of sarah.vareschi@ <mailto:sarah.vareschi%40nypromold.com> nypromold.com
Sent: Monday, July 10, 2006 4:16 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Adding VB checkbox - ODBC?

Hi Brian,

When adding VBForm fields you do not need ODBC to add it to your form -
these fields are already sent. When you add the field to your VBFom,
make sure you enter a field name in the 'external name' box - maybe
"RoHS".

Then print preview any po.

Then, open your poform in crystal to modify it. Go to database ->
'verify database'.

Then, you will see your new field available in your list of database
fields under 'podetail' -> "PDRoHS".

You can then add this to your form or make a new formula field using
this field to get a statement added.

HTH,
Sarah

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

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





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



In order to deal with PO's needing RoHS compliance, I have decided to
use a VB checkbox to PO line items. This will give agents the ability to
request statements of compliance on a per-line basis.



In order for this to have output, I will need to edit our "POFORM"
report. It is in Crystal, but we do not have ODBC setup as of yet. I
have the servergroup setup, but the directions from Epicor are somewhat
vague. We are on 5.0.320.



The goal would be to translate the Y/N of the checkbox into a statement
on the individual line item. I assume this is possible with Crystal, as
I haven't seen anything to the contrary. If anyone has experience with
this or similar things, please give me some feedback.



It is possible I am trying to do this the hard way, but it seems to me
if I can just add the line to our PO's dependant on the status of the
checkbox it will be easy enough.



Thanks,



Brian



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

When adding VBForm fields you do not need ODBC to add it to your form -
these fields are already sent. When you add the field to your VBFom,
make sure you enter a field name in the 'external name' box - maybe
"RoHS".

Then print preview any po.

Then, open your poform in crystal to modify it. Go to database ->
'verify database'.

Then, you will see your new field available in your list of database
fields under 'podetail' -> "PDRoHS".

You can then add this to your form or make a new formula field using
this field to get a statement added.

HTH,
Sarah
4
Brian,

I use a VB checkbox for ESD sensitive materials and print verbage on
the PO based on whether the box is checked or not. I suppress the
section if:

{poheader.USERCHAR1} = " "

Sandy Morse

--- In vantage@yahoogroups.com, "Brian Bricker" <brianb@...> wrote:
>
> Hello,
>
>
>
> In order to deal with PO's needing RoHS compliance, I have decided
to
> use a VB checkbox to PO line items. This will give agents the
ability to
> request statements of compliance on a per-line basis.
>
>
>
> In order for this to have output, I will need to edit our "POFORM"
> report. It is in Crystal, but we do not have ODBC setup as of yet. I
> have the servergroup setup, but the directions from Epicor are
somewhat
> vague. We are on 5.0.320.
>
>
>
> The goal would be to translate the Y/N of the checkbox into a
statement
> on the individual line item. I assume this is possible with
Crystal, as
> I haven't seen anything to the contrary. If anyone has experience
with
> this or similar things, please give me some feedback.
>
>
>
> It is possible I am trying to do this the hard way, but it seems to
me
> if I can just add the line to our PO's dependant on the status of
the
> checkbox it will be easy enough.
>
>
>
> Thanks,
>
>
>
> Brian
>
>
>
> [Non-text portions of this message have been removed]
>
5
I have tried this, but I receive an error for all fields within the form
- Cannot find xxxxx in c:\vntgwork\xxxx.dbf.



I assumed this was some sort of database connection issue. I am logged
into vantage locally, but my vntgwork file does not reside in that
location.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sarah.vareschi@...
Sent: Monday, July 10, 2006 4:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding VB checkbox - ODBC?



Hi Brian,

When adding VBForm fields you do not need ODBC to add it to your form -
these fields are already sent. When you add the field to your VBFom,
make sure you enter a field name in the 'external name' box - maybe
"RoHS".

Then print preview any po.

Then, open your poform in crystal to modify it. Go to database ->
'verify database'.

Then, you will see your new field available in your list of database
fields under 'podetail' -> "PDRoHS".

You can then add this to your form or make a new formula field using
this field to get a statement added.

HTH,
Sarah





[Non-text portions of this message have been removed]
6
After making the VB Form change and identifying the external name have you done a print preview of a PO (to load the .dbf) and then in Crystal done a Verify Database? This last part adds the new field when Crystal goes out to the DBF file and sees the field names. You can also verify if the new field is there by opening the .dbf file with a spreadsheet program like Excel incase the verify database is not seeing it.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Brian Bricker
Sent: Monday, July 10, 2006 3:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding VB checkbox - ODBC?





I have tried this, but I receive an error for all fields within the form
- Cannot find xxxxx in c:\vntgwork\xxxx.dbf.

I assumed this was some sort of database connection issue. I am logged
into vantage locally, but my vntgwork file does not reside in that
location.

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf
Of sarah.vareschi@ <mailto:sarah.vareschi%40nypromold.com> nypromold.com
Sent: Monday, July 10, 2006 4:16 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Adding VB checkbox - ODBC?

Hi Brian,

When adding VBForm fields you do not need ODBC to add it to your form -
these fields are already sent. When you add the field to your VBFom,
make sure you enter a field name in the 'external name' box - maybe
"RoHS".

Then print preview any po.

Then, open your poform in crystal to modify it. Go to database ->
'verify database'.

Then, you will see your new field available in your list of database
fields under 'podetail' -> "PDRoHS".

You can then add this to your form or make a new formula field using
this field to get a statement added.

HTH,
Sarah

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







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