Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2007-11-28
11
Medium Priority
?
230 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 101

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 101

Expert Comment

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

mlmcc
0
Industry Leaders: 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 101

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 101

Expert Comment

by:mlmcc
ID: 20371066
0
 
LVL 101

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

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.
How to increase the row limit in Jasper Server.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

722 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