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

Getting data into report from MS SQL server

Status
Not open for further replies.
sfn6

sfn6

Programmer
Aug 30, 2001
11
US
Howdy. We're using an .adp (Access 2k) for our front end with a MS SQL server 2000 db.

Using a .mdb we had the reports getting data by creating, using, then deleting (after the report was created) access queries and pointing the report to the query. Now with the .adp, queries are gone. How could we link the report to a stored procedure or create a view on the fly to use in place of the query?

Thanks in advance.
Scott
 
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
438
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
658
caykamanj1966
caykamanj1966
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
446
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
488
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
428
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top