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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored procedure as a data source 2

Status
Not open for further replies.
awhitsel

awhitsel

Programmer
Feb 22, 2001
80
US
Can a SQL stored procedure be used as a data source for a Crystal Reports 8.5/9 file, and if so, how do you establish the connection between the report and the procedure?

Please advise.

Thank you.
 
Sort by date Sort by votes
I'll guess that you mean that you're using MS SQL Server, SQL is a database programming language common to many databases.

Make sure that you turn on the File->Options->Database->Show->Stored Procedures to enable this.

Next time you connect to SQL Server you'll see the SP listed.

-k
 
Upvote 0 Downvote
Also make sure that the SP only return a single table as a final product, CR is very fussy about that.

Mo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
Outlook as a Datasource?
Replies
0
Views
270
dgillz
dgillz
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
303
Ivan Kok
Ivan Kok
BTPJayW
  • Locked
  • Question
Verify Database Not Working Against Stored Procedure
Replies
1
Views
334
hilfy
hilfy
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
572
LyleU
LyleU
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
394
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top