Solved

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

Posted on 2007-11-28
11
225 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

752 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