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
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]