Solved

Designer Version 10: reports don't prompt to logon to Enterprise

Posted on 2007-11-28
11
222 Views
Last Modified: 2012-06-21
I'm having trouble getting Crystal 10 Reports located on a network drive to work on two of our PCs.  The reports work great on every other PC.  The reports were previously located in Crystal 10 enterprise and were saved to the network.

On the PCs where the reports work, they automatically ask the user to logon to Crystal Enterprise prior to opening in designer. Upon execution they login to the databaes and run just fine.

On the PCs where the reports fail, they open right to designer. Upon execution they successfully attempt to logon to the database and then fail with the error: "Failed to open a rowset. Details: HY100[DataDirect][ODBC Oracle Driver][Oracle]ORA-06550: line 1 column 8:  PLS-00306 wrong number or types of arguments in call to xxx...PLS\SQL Statement ignored. "   

Can anyone assist?

0
Comment
Question by:TommyTupa
  • 5
  • 4
11 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 20370518
Do the users of those machine have databse permissions?

How are you connecting the report to the database?
Is it using database security or Windows authentication?

Do those users have Crystal Enterprise permissions?

mlmcc
0
 
LVL 13

Author Comment

by:TommyTupa
ID: 20370679
The reports  connect via ODBC. The same ODBC drivers appear on all the PCs.  The database is using database security, there is only one username and password. This works fine all all PCs.  The PCs are being logged in with my profile and my passwords.  That is to say, no other users are involved at the present time  (we're in pre-production).  I can successfully login to Enterprise from Designer on the PCs where the reports don't work.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 20370836
Is Crystal installed on the PCs?

mlmcc
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 13

Author Comment

by:TommyTupa
ID: 20370867
:)  

Yes

" ...On the PCs where the reports fail, they open right to designer..."
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 20370885
Is Crystal on all the machines even th eones that work?

mlmcc
0
 
LVL 13

Author Comment

by:TommyTupa
ID: 20370909
Yes.   Guess my question wasn't  near as clear as I thought.  

"...On the PCs where the reports work, they automatically ask the user to logon to Crystal Enterprise prior to opening in designer.."



0
 
LVL 13

Accepted Solution

by:
TommyTupa earned 0 total points
ID: 20371033
solved it via:
KB article: c2012126
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 20371066
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 20379574
None of my comments are really solutions.  

PAQ / refund

mlmcc
0
 
LVL 1

Expert Comment

by:Vee_Mod
ID: 20391039
Closed, 500 points refunded.
Vee_Mod
Community Support Moderator
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question