Solved

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

Posted on 2007-11-28
11
221 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
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

813 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now