Thanks for your reply, I was really checking to see if anyone has
been doing the same thing that I've been doing, and it sounds
similar. I have successfully added data to several of the pre-made
forms in Vantage using ODBC, both with the Progress tables and some
Access tables. When I was at the Perspectives conference I asked a
Vantage representative about doing this and they did not know it was
possible. I also talked to many Vantage users and they were very
interested in being able to do the same thing.

The way I've been dealing with the change in data type from # to
string is I've been converting the necessary fields in Access using a
make table query and append table query which takes the info I want
out of the Progress table and puts it in an Access table which is
what I link to the dbf's in the Crystal Form. It works quite well
although it does take the extra step of running the query (the push
of a button in Access) prior to printing the form in Vantage.

Brian Stenglein
Clow Stamping Company

--- In vantage@egroups.com, "Troy Funte" <tfunte@e...> wrote:
> Brian,
>
>
> The answer is: YES. You CAN add a field to a canned Crystal report
(that uses the .dbf tables). But to do so means linking via ODBC to
your database just to get the field. We are doing it on the POfrm
report provided with Vantage 3. The trick is that the PONum in
the .dbf has been converted to text, so in order to link another
table by PONum you have to do it through a subreport in crystal so
that the PONum can be converted back to a number.
>
> So, if you don't mind doing some programming (it's not terribly
difficult, but better than $700custom programming from Vantage for
3.0 and another $150 if we make the move to 4.0), and don't mind
having to use ODBC to run the report, and you don't mind the report
running slightly slower (but not unbearable), YOU CAN DO IT.
>
> If you need more details, let me know.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Brian Stenglein
> To: vantage@egroups.com
> Sent: Monday, October 23, 2000 9:39 AM
> Subject: [Vantage] Re: Crystal Report Question: Adding Field from
different table to Vantage Form
>
>
> Does anyone know how to add a field from a table other than
> the .dbf's that are created when you print one of Vantage's pre-
made
> forms? I know I've been told it is not possible by Vantage
support,
> and I've heard the same thing here on the message board a time or
> two.
>
> Thanks,
>
> Brian Stenglein
>
>
>
>
> [Non-text portions of this message have been removed]

It's there... can't tell you the name right now as I'm home
but keep looking and you'll find it. We did this same thing.
You don't need to (and can't) add any tables to the form.

kathy@... wrote:

>
> Is possible to add the invoice date field to the accounts payable
> check stub (Check Print form in Crystal report)? I can't find a table
> that will allow me to link to this form. Has anyone been successful
> in adding tables to this form?
>
> Thanks for your help.
> Kathy Tyson
> Expansion Joint Systems, Inc.

Does anyone know how to add a field from a table other than
the .dbf's that are created when you print one of Vantage's pre-made
forms? I know I've been told it is not possible by Vantage support,
and I've heard the same thing here on the message board a time or
two.

Thanks,

Brian Stenglein

--- In vantage@egroups.com, Joe Konecny <jkonecn@g...> wrote:
> It's there... can't tell you the name right now as I'm home
> but keep looking and you'll find it. We did this same thing.
> You don't need to (and can't) add any tables to the form.
>
> kathy@e... wrote:
> >
> > Is possible to add the invoice date field to the accounts payable
> > check stub (Check Print form in Crystal report)? I can't find a
table
> > that will allow me to link to this form. Has anyone been
successful
> > in adding tables to this form?
> >
> > Thanks for your help.
> > Kathy Tyson
> > Expansion Joint Systems, Inc.

The answer is: YES. You CAN add a field to a canned Crystal report (that uses the .dbf tables). But to do so means linking via ODBC to your database just to get the field. We are doing it on the POfrm report provided with Vantage 3. The trick is that the PONum in the .dbf has been converted to text, so in order to link another table by PONum you have to do it through a subreport in crystal so that the PONum can be converted back to a number.

So, if you don't mind doing some programming (it's not terribly difficult, but better than $150 custom programming from Vantage), and don't mind having to use ODBC to run the report, and you don't mind the report running slightly slower (but not unbearable), YOU CAN DO IT.

If you need more details, let me know.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Brian Stenglein
To: vantage@egroups.com
Sent: Monday, October 23, 2000 9:39 AM
Subject: [Vantage] Re: Crystal Report Question: Adding Field from different table to Vantage Form

Does anyone know how to add a field from a table other than
the .dbf's that are created when you print one of Vantage's pre-made
forms? I know I've been told it is not possible by Vantage support,
and I've heard the same thing here on the message board a time or
two.

Thanks,

Brian Stenglein

--- In vantage@egroups.com, Joe Konecny <jkonecn@g...> wrote:
> It's there... can't tell you the name right now as I'm home
> but keep looking and you'll find it. We did this same thing.
> You don't need to (and can't) add any tables to the form.
>
> kathy@e... wrote:
> >
> > Is possible to add the invoice date field to the accounts payable
> > check stub (Check Print form in Crystal report)? I can't find a
table
> > that will allow me to link to this form. Has anyone been
successful
> > in adding tables to this form?
> >
> > Thanks for your help.
> > Kathy Tyson
> > Expansion Joint Systems, Inc.

eGroups Sponsor

We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)

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

Brian,

The answer is: YES. You CAN add a field to a canned Crystal report (that uses the .dbf tables). But to do so means linking via ODBC to your database just to get the field. We are doing it on the POfrm report provided with Vantage 3. The trick is that the PONum in the .dbf has been converted to text, so in order to link another table by PONum you have to do it through a subreport in crystal so that the PONum can be converted back to a number.

So, if you don't mind doing some programming (it's not terribly difficult, but better than $700custom programming from Vantage for 3.0 and another $150 if we make the move to 4.0), and don't mind having to use ODBC to run the report, and you don't mind the report running slightly slower (but not unbearable), YOU CAN DO IT.

If you need more details, let me know.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Brian Stenglein
To: vantage@egroups.com
Sent: Monday, October 23, 2000 9:39 AM
Subject: [Vantage] Re: Crystal Report Question: Adding Field from different table to Vantage Form

Does anyone know how to add a field from a table other than
the .dbf's that are created when you print one of Vantage's pre-made
forms? I know I've been told it is not possible by Vantage support,
and I've heard the same thing here on the message board a time or
two.

Thanks,

Brian Stenglein

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