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

accessing stored procedures

Status
Not open for further replies.
welshone

welshone

Programmer
Jul 30, 2001
414
GB
hello,
how can I use a SQL server 7 stored procedure instead of a table for my crystal report ? version 8.

I am trying to connect via ODBC but can only see my tables, ( no SP's can be seen)

thank you for any info.
 
Sort by date Sort by votes
In Crystal, go to File>Options>Database tab, and make sure that Stored Procedures is checked under "Show:".

-dave
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BTPJayW
  • Locked
  • Question
Verify Database Not Working Against Stored Procedure
Replies
1
Views
925
hilfy
hilfy
hpl2001
  • Locked
  • Question
Report stored in history getting updated
Replies
5
Views
388
lbass
lbass
allyne
  • Locked
  • Question
Crystal 2008 Stored Procedure with parameter
Replies
1
Views
231
hilfy
hilfy
Halliarse
  • Locked
  • Question
Pass and retrieve data to and from a Stored Procedure
Replies
11
Views
560
Halliarse
Halliarse
lesleycampbell
  • Locked
  • Question
Stored Procedure Parameter
Replies
1
Views
164
PeterDimitrov
PeterDimitrov

Part and Inventory Search

Sponsor

Back
Top