Progress 91D & MS Access

Sorry for the delay in my reply but it sounds like you are pretty
much at where I want to be.

Thanks,
Tony
--- In vantage@yahoogroups.com, <lonwiksell@...> wrote:
>
> Currently we have a network drive where each user has a folder. I
move
> the production copy of the app to each users folder. So they all
run
> their own application - no sharing. That applies to most of our
reports
> such as order and invoices. In these cases the Access application
and
> data tables are all in one MDB. We do have several applications
where
> the users need to share data. In those cases we split the app and
data.
> Each user will have there own app but the data is shared.
>
> At some point we may modify our app rollout procedure but we have
enough
> to do right now so it is a low priority. When we change it we
would
> have an automatic way to distribute the app from the server to
everyones
> C drive. It will run faster from the C drive than from the network
> drive but it is not a big issue right now.
>
> Greg Stewart, our IT manager, has done a tremendous job over the
last
> two years in improving network performance. We run a 1 gig
network and
> have new servers, switches, etc.
>
> I have a generic order report Access application that I took all
of our
> configuration stuff out and simplified some things. I need to do
a bit
> more with it and then I could send that out to anyone who would
like to
> take a look at it.
>
> I'm not an R.O.M employee but an independent software developer.
R.O.M
> contracted with me several years ago for 1,000 hours a year. I
have
> been working with them since 1997 so I know their business
processes.
> It was three years ago in February that I began to convert their
> reporting from their old system to Vantage. So I have put in
almost
> 3,000 hrs with Vantage and Access. We now have over 50 Access
databases
> running. I tell you this to let you know that I've gotten very
familiar
> with the Vantage tables, indexes and processes. If what we have
done
> here can help anyone else let us know.
>
> Lon A. Wiksell
> R.O.M Corp.
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of sheehanam21
> Sent: Thursday, March 08, 2007 12:22 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Progress 91D & MS Access
>
>
>
> Lon,
>
> How do you go about distributing your Access database for the
users
> to use? Do you give each user ther own copy or does everyone share
> one copy from the server.
>
> I only say this because I have experienced issues in the past with
> sharing. I believe it was mainly due to the need to write data to
> the database but I could be wrong.
>
> Thanks,
> Tony
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> <lonwiksell@> wrote:
> >
> > I can think of a 1000 reason to use Access instead of Crystal. I
> spent
> > over 400 hours modifying our Crystal Reports. After they were all
> > working we decided to do the same thing in Access which is much
> easier
> > to work with. Believe me, I'm a software developer and the
> difference
> > between the two is tremendous. I can do many things with Access
> that
> > are not available in Crystal or difficult or just slow. We print
> our
> > quote acknowledgements, orders, invoices, production schedule,
> packing
> > slips, shipping labels and many more with Access. Once you learn
> Access
> > you'll never go back.
> >
> > Lon A. Wiksell
> > R.O.M Corp
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of sheehanam21
> > Sent: Thursday, March 08, 2007 10:31 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Progress 91D & MS Access
> >
> >
> >
> > Does anyone know of any reason why I should not use MS Access as
> my
> > reporting tool for Progress 91D instead of Crystal XI?
> >
> > Thank you in advance,
> > Tony
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Does anyone know of any reason why I should not use MS Access as my
reporting tool for Progress 91D instead of Crystal XI?

Thank you in advance,
Tony
I don't believe Crystal XI is compatible with 91D. We had to purchase a
downgrade from 10 to 8.5.



From my experience, the Crystal hassle is very well worth it. Access
reporting is a very limited tool compared to the power of Crystal. Not
to mention that Crystal is fully integrated into 8.0 & 8.03.





Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 11:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress 91D & MS Access



Does anyone know of any reason why I should not use MS Access as my
reporting tool for Progress 91D instead of Crystal XI?

Thank you in advance,
Tony





[Non-text portions of this message have been removed]
Hi Folks,
I'm tinkering with an old version 4 test install. I have a couple of
questions regarding the .904 patch for Vantage.
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msgId=5
5177/stime=1173372256/nc1=4438988/nc2=3848547/nc3=3848644> I would
appreciate an off list reply.

Shirley Graver
Sys Admin
Rubber Associates.



[Non-text portions of this message have been removed]
I have a NIB version 8.5 if anyone is interested.


Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-1062 a Fax 401-596-1050

www.maxsonautomatic.com <http://www.maxsonautomatic.com/>



_____

From: Bruce Butler [mailto:bbutler@...]
Sent: Thursday, March 08, 2007 11:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress 91D & MS Access



I don't believe Crystal XI is compatible with 91D. We had to purchase a
downgrade from 10 to 8.5.

From my experience, the Crystal hassle is very well worth it. Access
reporting is a very limited tool compared to the power of Crystal. Not
to mention that Crystal is fully integrated into 8.0 & 8.03.

Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 11:31 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Progress 91D & MS Access

Does anyone know of any reason why I should not use MS Access as my
reporting tool for Progress 91D instead of Crystal XI?

Thank you in advance,
Tony

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






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

I'm not sure I understand how it would not be compatible since it is
only a reporting tool that pulls data from the database. Is this
more of an ODBC issue?

I disagree about Access being very limited as I've been using it for
some time and have been able to produce any report I've ever
wanted. What type of limitations have you experience with Access?

Also, can you tell me the type of problems you experienced with
Crystal 10 that caused you to downgrade?

Thanks,
Tony

--- In vantage@yahoogroups.com, "Bruce Butler" <bbutler@...> wrote:
>
> I don't believe Crystal XI is compatible with 91D. We had to
purchase a
> downgrade from 10 to 8.5.
>
>
>
> From my experience, the Crystal hassle is very well worth it.
Access
> reporting is a very limited tool compared to the power of
Crystal. Not
> to mention that Crystal is fully integrated into 8.0 & 8.03.
>
>
>
>
>
> Bruce Butler
>
> IT Manager
>
> Knappe & Koester, Inc.
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of sheehanam21
> Sent: Thursday, March 08, 2007 11:31 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Progress 91D & MS Access
>
>
>
> Does anyone know of any reason why I should not use MS Access as
my
> reporting tool for Progress 91D instead of Crystal XI?
>
> Thank you in advance,
> Tony
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
If the question is about Progress 9.1D, Tony is probably on Vantage 6.0
or 6.1.

I think Crystal is definitely more limited than Access. With Crystal,
you are stuck with the query Vantage gives you - there isn't any way to
modify the conditional parameters. In Access you can perform extremely
complex queries and view the data whatever way you want - reports or as
raw queries. The only limitation with Access - it can't read data from
some tables (e.g. Customer) because of index limitations (Access
problem).

Our company is on Vantage 6.1 and we use web-based reports (PDF's on our
Intranet) that pull directly from the database using ODBC. Problem -
these reports can't run directly from a Vantage menu. We can make them
run from a button on a VB Form, though - we've had tremendous success
with that.


Chris Gitzlaff
Major Industries


-----Original Message-----
From: Bruce Butler [mailto:bbutler@...]
Sent: Thursday, March 08, 2007 10:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress 91D & MS Access



I don't believe Crystal XI is compatible with 91D. We had to purchase a
downgrade from 10 to 8.5.

From my experience, the Crystal hassle is very well worth it. Access
reporting is a very limited tool compared to the power of Crystal. Not
to mention that Crystal is fully integrated into 8.0 & 8.03.

Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@... [mailto:vantage@...] On
Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 11:31 AM
To: vantage@...
Subject: [Vantage] Progress 91D & MS Access

Does anyone know of any reason why I should not use MS Access as my
reporting tool for Progress 91D instead of Crystal XI?

Thank you in advance,
Tony

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








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

I currently do all of my vantage reporting using Access and I have for
several years. I am using 9.1D and have had 2 issues, both of which I
have been able to work around. The first is that the Customer table has
too many indexes for access so it cannot be directly linked. There are
several work arounds for this, I believe most people create a view and
link to that instead. For some reason I didn't go that route and
instead have an export of the customer table that runs every night that
I link to instead. We only deal with about 30 customers and it is very
rare that we add a new one, so this has never caused us a problem.
However, if we were dealing with a lot of customers and adding/changing
them all the time, I would probably go the view route.

The other issue I have run into is if you use comment fields in your
query and the comments are too long (not sure how long is too long but
ours get very long) you will get an error basically stating that it is
too long and can't be diplayed - or something to that effect. I have
worked around this by using Dlookup instead of pulling the field
directly and that problem has gone away. Other than that, I love
reporting in access for many reasons (ease of end-user use, security
management, etc, etc) which I would be happy to elaborate on if anyone
is interested.

-Sarah
<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>
Chris,

Yes, I am running Vantage 6.1

I agree with you about Access. As far as the tables Access cannot
read, like the Customer table, due to the amount of indexes - I
asked Epicor about this and they said to simply create a View of the
Progress table then use that view. I have not tried this yet but I
have created many views in Progress so I believe this will work.

I will be using Crystal XI Server so I will have web reports. Do
you know if this is a problem with Progress 91D?

Thanks,
Tony

--- In vantage@yahoogroups.com, "Gitzlaff, Christopher"
<cgitzlaff@...> wrote:
>
> If the question is about Progress 9.1D, Tony is probably on
Vantage 6.0
> or 6.1.
>
> I think Crystal is definitely more limited than Access. With
Crystal,
> you are stuck with the query Vantage gives you - there isn't any
way to
> modify the conditional parameters. In Access you can perform
extremely
> complex queries and view the data whatever way you want - reports
or as
> raw queries. The only limitation with Access - it can't read data
from
> some tables (e.g. Customer) because of index limitations (Access
> problem).
>
> Our company is on Vantage 6.1 and we use web-based reports (PDF's
on our
> Intranet) that pull directly from the database using ODBC.
Problem -
> these reports can't run directly from a Vantage menu. We can make
them
> run from a button on a VB Form, though - we've had tremendous
success
> with that.
>
>
> Chris Gitzlaff
> Major Industries
>
>
> -----Original Message-----
> From: Bruce Butler [mailto:bbutler@...]
> Sent: Thursday, March 08, 2007 10:44 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Progress 91D & MS Access
>
>
>
> I don't believe Crystal XI is compatible with 91D. We had to
purchase a
> downgrade from 10 to 8.5.
>
> From my experience, the Crystal hassle is very well worth it.
Access
> reporting is a very limited tool compared to the power of Crystal.
Not
> to mention that Crystal is fully integrated into 8.0 & 8.03.
>
> Bruce Butler
>
> IT Manager
>
> Knappe & Koester, Inc.
>
> _____
>
> From: vantage@... [mailto:vantage@...] On
> Behalf
> Of sheehanam21
> Sent: Thursday, March 08, 2007 11:31 AM
> To: vantage@...
> Subject: [Vantage] Progress 91D & MS Access
>
> Does anyone know of any reason why I should not use MS Access as
my
> reporting tool for Progress 91D instead of Crystal XI?
>
> Thank you in advance,
> Tony
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I went on techsupport's recommendation for the 8.5. I never tested
Crystal 10 or XI against the 91D database. I am using XI now to convert
our 91D reports to Open Edge, and like it a lot.



There are a lot of times I have created reports in Access and get
frustrated over quirky things it does with page layouts like spreading
things over several pages. I really appreciate all the Crystal
functionality built in with grouped data. Subreports within Crystal are
a nice feature. The simple programming interface (formula fields)
within Crystal is a lot less cumbersome than some of the maneuvers you
need to make in Acess to get the same results. Copying totaled fields
from one group to another is a very specific advantage in Crystal that I
use a lot. Conditional output on data is easier within Crystal.



With all that, I would say for basic reports such as various lists,
Access is ok. But for more complicated reports, Crystal is far
superior. In order to keep the user interface as simple as possible, I
would pick one or the other. Given Crystal does more advanced
processing better, I would choose Crystal.



Just a few points from a Crystal junkie.



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 12:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Progress 91D & MS Access



Bruce,

I'm not sure I understand how it would not be compatible since it is
only a reporting tool that pulls data from the database. Is this
more of an ODBC issue?

I disagree about Access being very limited as I've been using it for
some time and have been able to produce any report I've ever
wanted. What type of limitations have you experience with Access?

Also, can you tell me the type of problems you experienced with
Crystal 10 that caused you to downgrade?

Thanks,
Tony

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Bruce Butler" <bbutler@...> wrote:
>
> I don't believe Crystal XI is compatible with 91D. We had to
purchase a
> downgrade from 10 to 8.5.
>
>
>
> From my experience, the Crystal hassle is very well worth it.
Access
> reporting is a very limited tool compared to the power of
Crystal. Not
> to mention that Crystal is fully integrated into 8.0 & 8.03.
>
>
>
>
>
> Bruce Butler
>
> IT Manager
>
> Knappe & Koester, Inc.
>
> _____
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of sheehanam21
> Sent: Thursday, March 08, 2007 11:31 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress 91D & MS Access
>
>
>
> Does anyone know of any reason why I should not use MS Access as
my
> reporting tool for Progress 91D instead of Crystal XI?
>
> Thank you in advance,
> Tony
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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

Thank you for your great explanations. I am interested in finding
out more about how you export the Customer table. Mainly because I
would like to know how to export numerous things out of Progress.

Also, the Dlookup you talked about. I am vaguely familiar with what
the functionality of this function is but am not sure how you use it
in Access for you lengthy fields. Can you elaborate?

Thanks,
Tony

--- In vantage@yahoogroups.com, <sarah.vareschi@...> wrote:
>
> Hi Tony,
>
> I currently do all of my vantage reporting using Access and I have
for
> several years. I am using 9.1D and have had 2 issues, both of
which I
> have been able to work around. The first is that the Customer
table has
> too many indexes for access so it cannot be directly linked.
There are
> several work arounds for this, I believe most people create a view
and
> link to that instead. For some reason I didn't go that route and
> instead have an export of the customer table that runs every night
that
> I link to instead. We only deal with about 30 customers and it is
very
> rare that we add a new one, so this has never caused us a problem.
> However, if we were dealing with a lot of customers and
adding/changing
> them all the time, I would probably go the view route.
>
> The other issue I have run into is if you use comment fields in
your
> query and the comments are too long (not sure how long is too long
but
> ours get very long) you will get an error basically stating that
it is
> too long and can't be diplayed - or something to that effect. I
have
> worked around this by using Dlookup instead of pulling the field
> directly and that problem has gone away. Other than that, I love
> reporting in access for many reasons (ease of end-user use,
security
> management, etc, etc) which I would be happy to elaborate on if
anyone
> is interested.
>
> -Sarah
> <DIV><font size="1.5" face="Bookman Old
Style">______________________________________________________________
____________________________________________________
>
> This email may contain material that is confidential, privileged
and/or attorney work product for the sole use of the intended
recipient. Any review, reliance or distribution by others or
forwarding without express permission is strictly prohibited. If you
are not the intended recipient, please contact the sender and delete
all copies.
>
_____________________________________________________________________
_____________________________________________<DIV><FONT>
>
Interesting points Bruce.

Thank you for your comments. I will take them under advisment.

Thanks again,
Tony

--- In vantage@yahoogroups.com, "Bruce Butler" <bbutler@...> wrote:
>
> I went on techsupport's recommendation for the 8.5. I never tested
> Crystal 10 or XI against the 91D database. I am using XI now to
convert
> our 91D reports to Open Edge, and like it a lot.
>
>
>
> There are a lot of times I have created reports in Access and get
> frustrated over quirky things it does with page layouts like
spreading
> things over several pages. I really appreciate all the Crystal
> functionality built in with grouped data. Subreports within
Crystal are
> a nice feature. The simple programming interface (formula fields)
> within Crystal is a lot less cumbersome than some of the maneuvers
you
> need to make in Acess to get the same results. Copying totaled
fields
> from one group to another is a very specific advantage in Crystal
that I
> use a lot. Conditional output on data is easier within Crystal.
>
>
>
> With all that, I would say for basic reports such as various lists,
> Access is ok. But for more complicated reports, Crystal is far
> superior. In order to keep the user interface as simple as
possible, I
> would pick one or the other. Given Crystal does more advanced
> processing better, I would choose Crystal.
>
>
>
> Just a few points from a Crystal junkie.
>
>
>
> Bruce Butler
>
> IT Manager
>
> Knappe & Koester, Inc.
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of sheehanam21
> Sent: Thursday, March 08, 2007 12:12 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Progress 91D & MS Access
>
>
>
> Bruce,
>
> I'm not sure I understand how it would not be compatible since it
is
> only a reporting tool that pulls data from the database. Is this
> more of an ODBC issue?
>
> I disagree about Access being very limited as I've been using it
for
> some time and have been able to produce any report I've ever
> wanted. What type of limitations have you experience with Access?
>
> Also, can you tell me the type of problems you experienced with
> Crystal 10 that caused you to downgrade?
>
> Thanks,
> Tony
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Bruce Butler" <bbutler@> wrote:
> >
> > I don't believe Crystal XI is compatible with 91D. We had to
> purchase a
> > downgrade from 10 to 8.5.
> >
> >
> >
> > From my experience, the Crystal hassle is very well worth it.
> Access
> > reporting is a very limited tool compared to the power of
> Crystal. Not
> > to mention that Crystal is fully integrated into 8.0 & 8.03.
> >
> >
> >
> >
> >
> > Bruce Butler
> >
> > IT Manager
> >
> > Knappe & Koester, Inc.
> >
> > _____
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of sheehanam21
> > Sent: Thursday, March 08, 2007 11:31 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Progress 91D & MS Access
> >
> >
> >
> > Does anyone know of any reason why I should not use MS Access as
> my
> > reporting tool for Progress 91D instead of Crystal XI?
> >
> > Thank you in advance,
> > Tony
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tony,

I do a lot of things in Access rather than in Report Builder. One issue
is that I get different figures from Report Builder (MS Access is more
accurate). Access has its limitations in the connectivity to certain
tables in Vantage. By doing views of tables, you may be able to go
around some of the issues.

What I like is that I can have a user click in a button in Access, and
Access connects, extracts, and provides whatever information in any
format needed and the user can play with the information without
affecting the live data.

I have done a multilevel BOM (up to 7 levels) and merge them all in 2
levels, I have done financial statements combined from different
companies and databases, I have upload orders and modify them using a
combination of Access and the EDI module (Access does the flat file to
upload with EDI).

So, I have a lot of fun with Access, but remember you are the one
supporting them all....Have fun!

Mario E. Aguirre - IT Manager
Lakin General Corporation, Inc.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 10:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress 91D & MS Access



Does anyone know of any reason why I should not use MS Access as my
reporting tool for Progress 91D instead of Crystal XI?

Thank you in advance,
Tony






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

Regarding the export and automating it, here is what I have set-up (I
have no idea if this is the 'best' way, but it's the way I knew):

1) Create the export in progress
-Using the progress procedure editor, I created an export procedure
called customer.p (if you want the code I will send it as an attachment
off-list since list doesn't allow attachments)
-I made a folder in my Vantage directory called 'Export' where I save
all my exports

2) In MS Access, I created a macro with 2 lines, the first being a
RunnApp line with the command line "z:\Progress\bin\prowin32.exe -db
z:\vantage\db\vantage.db -N TCP -S epic52 -H NMvantage -p
z:\vantage\export\Customer.p" which runs my progress procedure. The
second being a quit line which closes access.

3) I then have a batch file with code to run this macro and I have that
batch file schedule to run during the night.

Regarding the DLookUp it's just a function in access that allows you to
look-up data based on fields on your current report, form, query, etc.
So, if I need to show the comments field, if I use the dlookup to get it
rather than adding it directly to my query, I do not get the error. Not
sure why, but it works.

Let me know if you have any questions or want more info...

-Sarah





-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 12:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Progress 91D & MS Access

Hi Sarah,

Thank you for your great explanations. I am interested in finding
out more about how you export the Customer table. Mainly because I
would like to know how to export numerous things out of Progress.

Also, the Dlookup you talked about. I am vaguely familiar with what
the functionality of this function is but am not sure how you use it
in Access for you lengthy fields. Can you elaborate?

Thanks,
Tony

--- In vantage@yahoogroups.com, <sarah.vareschi@...> wrote:
>
> Hi Tony,
>
> I currently do all of my vantage reporting using Access and I have
for
> several years. I am using 9.1D and have had 2 issues, both of
which I
> have been able to work around. The first is that the Customer
table has
> too many indexes for access so it cannot be directly linked.
There are
> several work arounds for this, I believe most people create a view
and
> link to that instead. For some reason I didn't go that route and
> instead have an export of the customer table that runs every night
that
> I link to instead. We only deal with about 30 customers and it is
very
> rare that we add a new one, so this has never caused us a problem.
> However, if we were dealing with a lot of customers and
adding/changing
> them all the time, I would probably go the view route.
>
> The other issue I have run into is if you use comment fields in
your
> query and the comments are too long (not sure how long is too long
but
> ours get very long) you will get an error basically stating that
it is
> too long and can't be diplayed - or something to that effect. I
have
> worked around this by using Dlookup instead of pulling the field
> directly and that problem has gone away. Other than that, I love
> reporting in access for many reasons (ease of end-user use,
security
> management, etc, etc) which I would be happy to elaborate on if
anyone
> is interested.
>
> -Sarah
> <DIV><font size="1.5" face="Bookman Old
Style">______________________________________________________________
____________________________________________________
>
> This email may contain material that is confidential, privileged
and/or attorney work product for the sole use of the intended
recipient. Any review, reliance or distribution by others or
forwarding without express permission is strictly prohibited. If you
are not the intended recipient, please contact the sender and delete
all copies.
>
_____________________________________________________________________
_____________________________________________<DIV><FONT>
>





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links



<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>
I can think of a 1000 reason to use Access instead of Crystal. I spent
over 400 hours modifying our Crystal Reports. After they were all
working we decided to do the same thing in Access which is much easier
to work with. Believe me, I'm a software developer and the difference
between the two is tremendous. I can do many things with Access that
are not available in Crystal or difficult or just slow. We print our
quote acknowledgements, orders, invoices, production schedule, packing
slips, shipping labels and many more with Access. Once you learn Access
you'll never go back.

Lon A. Wiksell
R.O.M Corp

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 10:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress 91D & MS Access



Does anyone know of any reason why I should not use MS Access as my
reporting tool for Progress 91D instead of Crystal XI?

Thank you in advance,
Tony






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

Thank you for your comments. I am a lot more comfortable working in
Access then Crystal but the users here are use to using Crystal
because we are currently running Crystal Server 8.3.

Due to a licensing issue I need to either upgrade Crystal or start
using Access and convert all of our reports.

Thanks,
Tony

--- In vantage@yahoogroups.com, "Mario Aguirre" <maguirre@...> wrote:
>
> Tony,
>
> I do a lot of things in Access rather than in Report Builder. One
issue
> is that I get different figures from Report Builder (MS Access is
more
> accurate). Access has its limitations in the connectivity to
certain
> tables in Vantage. By doing views of tables, you may be able to go
> around some of the issues.
>
> What I like is that I can have a user click in a button in Access,
and
> Access connects, extracts, and provides whatever information in any
> format needed and the user can play with the information without
> affecting the live data.
>
> I have done a multilevel BOM (up to 7 levels) and merge them all
in 2
> levels, I have done financial statements combined from different
> companies and databases, I have upload orders and modify them
using a
> combination of Access and the EDI module (Access does the flat
file to
> upload with EDI).
>
> So, I have a lot of fun with Access, but remember you are the one
> supporting them all....Have fun!
>
> Mario E. Aguirre - IT Manager
> Lakin General Corporation, Inc.
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of sheehanam21
> Sent: Thursday, March 08, 2007 10:31 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Progress 91D & MS Access
>
>
>
> Does anyone know of any reason why I should not use MS Access as
my
> reporting tool for Progress 91D instead of Crystal XI?
>
> Thank you in advance,
> Tony
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
You can read the Customer table but you have to set up a VIEW of that
table. You can not read it directly. Access does have a limitation of
reading tables with only 36 indexes or less. The customer table has
over 50 indexes. I have never been able to understand why that table
needs so many indexes. As a database developer (DB2, Informix, SQL and
others) there are many issues with the Vantage tables - bad indexing,
poor table design, data not normalized, etc. It makes for a challenge
for anyone getting data out of the system.

I've been working with Vantage for 3 years now and still finding out the
strange world of the Vantage DB.

Lon A. Wiksell
R.O.M Corp.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gitzlaff, Christopher
Sent: Thursday, March 08, 2007 11:20 AM
To: vantage
Subject: RE: [Vantage] Progress 91D & MS Access



If the question is about Progress 9.1D, Tony is probably on Vantage 6.0
or 6.1.

I think Crystal is definitely more limited than Access. With Crystal,
you are stuck with the query Vantage gives you - there isn't any way to
modify the conditional parameters. In Access you can perform extremely
complex queries and view the data whatever way you want - reports or as
raw queries. The only limitation with Access - it can't read data from
some tables (e.g. Customer) because of index limitations (Access
problem).

Our company is on Vantage 6.1 and we use web-based reports (PDF's on our
Intranet) that pull directly from the database using ODBC. Problem -
these reports can't run directly from a Vantage menu. We can make them
run from a button on a VB Form, though - we've had tremendous success
with that.


Chris Gitzlaff
Major Industries


-----Original Message-----
From: Bruce Butler [mailto:bbutler@...
<mailto:bbutler%40knappe-koester.com> ]
Sent: Thursday, March 08, 2007 10:44 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Progress 91D & MS Access

I don't believe Crystal XI is compatible with 91D. We had to purchase a
downgrade from 10 to 8.5.

From my experience, the Crystal hassle is very well worth it. Access
reporting is a very limited tool compared to the power of Crystal. Not
to mention that Crystal is fully integrated into 8.0 & 8.03.

Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@... [mailto:vantage@...] On
Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 11:31 AM
To: vantage@...
Subject: [Vantage] Progress 91D & MS Access

Does anyone know of any reason why I should not use MS Access as my
reporting tool for Progress 91D instead of Crystal XI?

Thank you in advance,
Tony

[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]
I disagree Bruce. Access is the most powerful reporting tool currently
available. I can run rings around Crystal and I can do it much faster.
The Crystal hassle is not worth it.

Lon A. Wiksell
R.O.M Corp

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bruce Butler
Sent: Thursday, March 08, 2007 10:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress 91D & MS Access



I don't believe Crystal XI is compatible with 91D. We had to purchase a
downgrade from 10 to 8.5.

From my experience, the Crystal hassle is very well worth it. Access
reporting is a very limited tool compared to the power of Crystal. Not
to mention that Crystal is fully integrated into 8.0 & 8.03.

Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 11:31 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Progress 91D & MS Access

Does anyone know of any reason why I should not use MS Access as my
reporting tool for Progress 91D instead of Crystal XI?

Thank you in advance,
Tony

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






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

Sorry - we don't use Crystal server at all... I don't know if it is
compatible or not.

I believe we're supposed to use version 8.5 to modify reports on Vantage
6.1 - we use Crystal version 8 to and everything works fine for us.
Again, we only use Crystal where we absolutely have to (maybe 5 to 10
reports or so).


Chris


-----Original Message-----
From: sheehanam21 [mailto:sheehanam@...]
Sent: Thursday, March 08, 2007 11:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Progress 91D & MS Access



Chris,

Yes, I am running Vantage 6.1

I agree with you about Access. As far as the tables Access cannot
read, like the Customer table, due to the amount of indexes - I
asked Epicor about this and they said to simply create a View of the
Progress table then use that view. I have not tried this yet but I
have created many views in Progress so I believe this will work.

I will be using Crystal XI Server so I will have web reports. Do
you know if this is a problem with Progress 91D?

Thanks,
Tony

--- In vantage@..., "Gitzlaff, Christopher"
<cgitzlaff@.-..> wrote:
>
> If the question is about Progress 9.1D, Tony is probably on
Vantage 6.0
> or 6.1.
>
> I think Crystal is definitely more limited than Access. With
Crystal,
> you are stuck with the query Vantage gives you - there isn't any
way to
> modify the conditional parameters. In Access you can perform
extremely
> complex queries and view the data whatever way you want - reports
or as
> raw queries. The only limitation with Access - it can't read data
from
> some tables (e.g. Customer) because of index limitations (Access
> problem).
>
> Our company is on Vantage 6.1 and we use web-based reports (PDF's
on our
> Intranet) that pull directly from the database using ODBC.
Problem -
> these reports can't run directly from a Vantage menu. We can make
them
> run from a button on a VB Form, though - we've had tremendous
success
> with that.
>
>
> Chris Gitzlaff
> Major Industries
>
>
> -----Original Message-----
> From: Bruce Butler [mailto:bbutler@-...]
> Sent: Thursday, March 08, 2007 10:44 AM
> To: vantage@...
> Subject: RE: [Vantage] Progress 91D & MS Access
>
>
>
> I don't believe Crystal XI is compatible with 91D. We had to
purchase a
> downgrade from 10 to 8.5.
>
> From my experience, the Crystal hassle is very well worth it.
Access
> reporting is a very limited tool compared to the power of Crystal.
Not
> to mention that Crystal is fully integrated into 8.0 & 8.03.
>
> Bruce Butler
>
> IT Manager
>
> Knappe & Koester, Inc.
>
> _____
>
> From: vantage@... [mailto:vantage@-...] On
> Behalf
> Of sheehanam21
> Sent: Thursday, March 08, 2007 11:31 AM
> To: vantage@...
> Subject: [Vantage] Progress 91D & MS Access
>
> Does anyone know of any reason why I should not use MS Access as
my
> reporting tool for Progress 91D instead of Crystal XI?
>
> Thank you in advance,
> Tony
>
> [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]
Just curious, when you use access for reporting should you link to the vantage databases or import the database? What are the advantages and disadvantages of each option?

Also, what do you mean when you say 'View' the progress table?

Thanks,
Jasper

-----Original Message-----
From: sheehanam21 [mailto:sheehanam@...]
Sent: Thursday, March 08, 2007 12:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Progress 91D & MS Access



Chris,

Yes, I am running Vantage 6.1

I agree with you about Access. As far as the tables Access cannot
read, like the Customer table, due to the amount of indexes - I
asked Epicor about this and they said to simply create a View of the
Progress table then use that view. I have not tried this yet but I
have created many views in Progress so I believe this will work.

I will be using Crystal XI Server so I will have web reports. Do
you know if this is a problem with Progress 91D?

Thanks,
Tony

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Gitzlaff, Christopher"
<cgitzlaff@...> wrote:
>
> If the question is about Progress 9.1D, Tony is probably on
Vantage 6.0
> or 6.1.
>
> I think Crystal is definitely more limited than Access. With
Crystal,
> you are stuck with the query Vantage gives you - there isn't any
way to
> modify the conditional parameters. In Access you can perform
extremely
> complex queries and view the data whatever way you want - reports
or as
> raw queries. The only limitation with Access - it can't read data
from
> some tables (e.g. Customer) because of index limitations (Access
> problem).
>
> Our company is on Vantage 6.1 and we use web-based reports (PDF's
on our
> Intranet) that pull directly from the database using ODBC.
Problem -
> these reports can't run directly from a Vantage menu. We can make
them
> run from a button on a VB Form, though - we've had tremendous
success
> with that.
>
>
> Chris Gitzlaff
> Major Industries
>
>
> -----Original Message-----
> From: Bruce Butler [mailto:bbutler@...]
> Sent: Thursday, March 08, 2007 10:44 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Progress 91D & MS Access
>
>
>
> I don't believe Crystal XI is compatible with 91D. We had to
purchase a
> downgrade from 10 to 8.5.
>
> From my experience, the Crystal hassle is very well worth it.
Access
> reporting is a very limited tool compared to the power of Crystal.
Not
> to mention that Crystal is fully integrated into 8.0 & 8.03.
>
> Bruce Butler
>
> IT Manager
>
> Knappe & Koester, Inc.
>
> _____
>
> From: vantage@... [mailto:vantage@...] On
> Behalf
> Of sheehanam21
> Sent: Thursday, March 08, 2007 11:31 AM
> To: vantage@...
> Subject: [Vantage] Progress 91D & MS Access
>
> Does anyone know of any reason why I should not use MS Access as
my
> reporting tool for Progress 91D instead of Crystal XI?
>
> Thank you in advance,
> Tony
>
> [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]