I remember speaking to epicor on that subject a year ago and I was promised
it would happen with version 4 but nothing happened...

Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565

> -----Original Message-----
> From: rgors [SMTP:rgors@...]
> Sent: Wednesday, July 12, 2000 10:56 AM
> To: vantage@egroups.com
> Subject: Re: [Vantage] Issue with Crystal Reports
>
> By the way:
>
> The rumor I heard was that Epicor will release ALL of their reports in
> Crystal with a future (next?) release so that all users may modify to
> their heart's content. I hope this is a true statement. I heard it
> from an Epicor Support person of some stature...
>
> Rick
> MIS
> Osco
>
> sarah.vareschi@... wrote:
>

Crystal DOES work so that if you add a table through ODBC, than all fields
are available to you.

HOWEVER, since the report you are looking at was written by Epicor, and is
therefore not using ODBC, the only fields supplied with the report are the
fields that Epicor used in the report. I don't know the mechanics of it,
but they export the tables with the fields they need for the report to some
sort of temporary file so that the fields can be grabbed by crystal without
using ODBC. Therefore, you are correct in that you can not simply add any
field to the report that is in one of the tables that is used in the report.

There are ways to add the table and field through ODBC, but this gets messy
because the report now will require ODBC to run it.

Sarah

By the way:

The rumor I heard was that Epicor will release ALL of their reports in
Crystal with a future (next?) release so that all users may modify to
their heart's content. I hope this is a true statement. I heard it
from an Epicor Support person of some stature...

Rick
MIS
Osco

sarah.vareschi@... wrote:

>
> Crystal DOES work so that if you add a table through ODBC, than all
> fields
> are available to you.
>
> HOWEVER, since the report you are looking at was written by Epicor,
> and is
> therefore not using ODBC, the only fields supplied with the report are
> the
> fields that Epicor used in the report. I don't know the mechanics of
> it,
> but they export the tables with the fields they need for the report to
> some
> sort of temporary file so that the fields can be grabbed by crystal
> without
> using ODBC. Therefore, you are correct in that you can not simply add
> any
> field to the report that is in one of the tables that is used in the
> report.
>
> There are ways to add the table and field through ODBC, but this gets
> messy
> because the report now will require ODBC to run it.
>
> Sarah
> ----------------------------------------------------------------------
>
> ----------------------------------------------------------------------
> 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.)