Crystal Reports and ODBC

Yahoo Archive
1
Have you made sure that under the Advanced Setting tab on your ODBC DSN
setup dialog that the Default Isolation Level is set to "Read Uncommitted"?
If this is set to something else then it will lock your records and other
users can access the data.
Just a thought
Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Dan Shallbetter [mailto:dans@...]
Sent: Wednesday, January 22, 2003 8:17 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports and ODBC


Lori,

Is this a new problem? If it is a concurrent user problem I would look at
the properties of the ODBC group in Progress Explorer. Epicor might have
something on their website that explains the parameters.

Dan Shallbetter
States Electric Mfg

-----Original Message-----
From: Lori Baker [mailto:lbaker@...]
Sent: Tuesday, January 21, 2003 6:18 PM
To: Vantage Onelist (vantage@onelist.com)
Subject: [Vantage] Crystal Reports and ODBC


I have created several reports using Crystal Reports and have given my users
access to them through Vantage so that they are able to enter data asked by
parameters. I am having major issues with one user tying up the access to
all other users. For instance, I have created a new PO report that has added
our account number with the vendor and have compiled and distributed through
Crystal. When a user is using this report, other users are not able to
access the modified job pick list or quoting reports. I have setup ODBC on
each workstation as a system dsn. Each user logs in to Crystal with
sysprogress as the user. Do I need to create additional users through
Progress and if so, how is this done? Any help would be greatly appreciated.
We rely on the Crystal Reports since we are able to export them to Word and
Excel without a lot of issues.

Thanks,

Lori

Lori A. Baker
Director of Information Systems
WindStone Medical Inc. (formerly Cardio Pak Inc.)
406.259.6387
lbaker@... <mailto:lbaker@...>
www.windstonemedical.com < http://www.windstonemedical.com/
<http://www.windstonemedical.com/> >







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


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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
I have created several reports using Crystal Reports and have given my users
access to them through Vantage so that they are able to enter data asked by
parameters. I am having major issues with one user tying up the access to
all other users. For instance, I have created a new PO report that has added
our account number with the vendor and have compiled and distributed through
Crystal. When a user is using this report, other users are not able to
access the modified job pick list or quoting reports. I have setup ODBC on
each workstation as a system dsn. Each user logs in to Crystal with
sysprogress as the user. Do I need to create additional users through
Progress and if so, how is this done? Any help would be greatly appreciated.
We rely on the Crystal Reports since we are able to export them to Word and
Excel without a lot of issues.

Thanks,

Lori

Lori A. Baker
Director of Information Systems
WindStone Medical Inc. (formerly Cardio Pak Inc.)
406.259.6387
lbaker@... <mailto:lbaker@...>
www.windstonemedical.com <http://www.windstonemedical.com/>




[Non-text portions of this message have been removed]
3
Lori,
If the PO report you modified is the POForm.rpt report, I'm wondering why you compiled it? You should be able to run it through Vantage without compiling it.

Troy Funte
Liberty Electronics


----- Original Message -----
From: Lori Baker
To: Vantage Onelist (vantage@onelist.com)
Sent: Tuesday, January 21, 2003 7:18 PM
Subject: [Vantage] Crystal Reports and ODBC


I have created several reports using Crystal Reports and have given my users
access to them through Vantage so that they are able to enter data asked by
parameters. I am having major issues with one user tying up the access to
all other users. For instance, I have created a new PO report that has added
our account number with the vendor and have compiled and distributed through
Crystal. When a user is using this report, other users are not able to
access the modified job pick list or quoting reports. I have setup ODBC on
each workstation as a system dsn. Each user logs in to Crystal with
sysprogress as the user. Do I need to create additional users through
Progress and if so, how is this done? Any help would be greatly appreciated.
We rely on the Crystal Reports since we are able to export them to Word and
Excel without a lot of issues.

Thanks,

Lori

Lori A. Baker
Director of Information Systems
WindStone Medical Inc. (formerly Cardio Pak Inc.)
406.259.6387
lbaker@... <mailto:lbaker@...>
www.windstonemedical.com <http://www.windstonemedical.com/>




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


Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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

Is this a new problem? If it is a concurrent user problem I would look at
the properties of the ODBC group in Progress Explorer. Epicor might have
something on their website that explains the parameters.

Dan Shallbetter
States Electric Mfg

-----Original Message-----
From: Lori Baker [mailto:lbaker@...]
Sent: Tuesday, January 21, 2003 6:18 PM
To: Vantage Onelist (vantage@onelist.com)
Subject: [Vantage] Crystal Reports and ODBC


I have created several reports using Crystal Reports and have given my users
access to them through Vantage so that they are able to enter data asked by
parameters. I am having major issues with one user tying up the access to
all other users. For instance, I have created a new PO report that has added
our account number with the vendor and have compiled and distributed through
Crystal. When a user is using this report, other users are not able to
access the modified job pick list or quoting reports. I have setup ODBC on
each workstation as a system dsn. Each user logs in to Crystal with
sysprogress as the user. Do I need to create additional users through
Progress and if so, how is this done? Any help would be greatly appreciated.
We rely on the Crystal Reports since we are able to export them to Word and
Excel without a lot of issues.

Thanks,

Lori

Lori A. Baker
Director of Information Systems
WindStone Medical Inc. (formerly Cardio Pak Inc.)
406.259.6387
lbaker@... <mailto:lbaker@...>
www.windstonemedical.com < http://www.windstonemedical.com/
<http://www.windstonemedical.com/> >







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