Solved

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

Posted on 2007-11-28
11
215 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
Comment Utility
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
Comment Utility
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
Comment Utility
Is Crystal installed on the PCs?

mlmcc
0
 
LVL 13

Author Comment

by:TommyTupa
Comment Utility
:)  

Yes

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

Expert Comment

by:mlmcc
Comment Utility
Is Crystal on all the machines even th eones that work?

mlmcc
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 13

Author Comment

by:TommyTupa
Comment Utility
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
Comment Utility
solved it via:
KB article: c2012126
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
None of my comments are really solutions.  

PAQ / refund

mlmcc
0
 
LVL 1

Expert Comment

by:Vee_Mod
Comment Utility
Closed, 500 points refunded.
Vee_Mod
Community Support Moderator
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

728 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

8 Experts available now in Live!

Get 1:1 Help Now