Reporting with SQL2K

  • Thread starter Thread starter Bob Baker
  • Start date Start date
B

Bob Baker

Hi,
Someone can direct me to some online help on howto create Reports using
SQL2K's views and/or stored procedures?
Evidently, the process is slightly different from the ACC.
TIA
Bob
 
Someone can direct me to some
online help on howto create Reports using
SQL2K's views and/or stored procedures?
Evidently, the process is slightly different
from the ACC.
Click to expand...

If you are in an Access MDB, an SQL Server View appears to Access just the
same as an SQL Server Table -- link it and use it in your Report's Record
Source Query or SQL Statement.

I'll have to let someone else address the issue of using Stored Procedures
as Report's Record Sources.

Larry Linson
Microsoft Access MVP
 
The best way is to use a pass-thru query to run the view or stored
procedure.
you have to code the connection string into the query and have it remember
it
and then use SQL Server syntax to run the view/stored proc.

Example "Exec mystoredproc @Salary=50000" or "select * from myview"

This way it runs everything on the server and returns the results to access.

Second best way is to use linked tables/views.

Note: Sub reports do not work using pass-thrus.

HTH,
Mark
RPT Software
http://www.rptsoftware.com

PS: Check out our products when you want to start doing web-based reporting
using Access/SQL Server
(that's my favorite combination).
 
Back
Top