Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling SQL Server stored proc from Crystal Enterprise

Status
Not open for further replies.
tadd

tadd

Programmer
Oct 28, 2001
70
US

I created a Crystal Report in CR10 that get its data from a SQL Server stored procedure. It works fine.

When we promote this report to Crystal Enterprise, we get a data access error. ("incorrect log on parameters") I just want to make sure that the problem is not that CRE does not support reports built on stored procs. Does anyone know for sure?

Thanks.

 
Sort by date Sort by votes
check the user access rights on the database for the crystal enterprise profile.



Mo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
882
Kennymc
Kennymc
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
691
hilfy
hilfy
Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
608
dgillz
dgillz
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
582
Ivan Kok
Ivan Kok
BTPJayW
  • Locked
  • Question
Verify Database Not Working Against Stored Procedure
Replies
1
Views
649
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top