March 12, 2003 at 1:58 pm
I was wondering if there is a way I can use a report from Access 97 to print a certificate using SQL Server and being displayed in ASP as well?
March 12, 2003 at 2:05 pm
Quick and Dirty:
Set up a system DSN to your database, attach the required tables to the Access db having the report and run the report from Access.
ASP, You can view and print an Access report from ASP. Search 4guysfromrolla.com for a description on how.
March 12, 2003 at 2:18 pm
when you say dns is that using SQL server capabilities.
I would like to migrate the report to SQL Server from access if possible
March 12, 2003 at 2:20 pm
since that's where all my data has been migrated to
March 13, 2003 at 11:32 am
If you're talking about the report query, then bring the SQL over (slightly modified to work with T-SQL) into a stored procedure. If you need help doing this, post the Access SQL code.
If you're talking about the actual report object in Access, there is no such thing in SQL Server. SQL Server is a database server, whereas Access is a front-end development tool, similar to VB, Powerbuilder, etc, with a built-in desktop database engine...
YOu would have to develop the new report either in Crystal, or use the Access report designer to display the results of your SQL Server stored procedure that is exposed through the DSN to Access...
Let us know what help you need...
Jay
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply