DataBase - SQL Server Reporting Services Reports in Access
Asked By AG
07-Feb-10 02:05 PM
Using Access 2007 and SQL Server 2008.
Is there a way to display SQL Server Reporting Services reports in Access
2007?
If so, links to documentation/examples would be appreciated.
--
AG
Email: npATadhdataDOTcom
SQL Server 2008
(1)
SQL Server
(1)
Access 2007
(1)
Office
(1)
Excel
(1)
NpATadhdataDOTcom
(1)
Database
(1)
AGEmail
(1)
changli replied to AG
Hi AG,
No,there is no compatible interface for converting SSRS report to Access
2007 now.You may consider first export your SSRS report to an Excel file
and then embed an OLE object "Microsoft Office Excel 97-2003 Worksheet". If
you only need the data, you can directly import data from Excel to your
Access database.
Best regards,
Charles Wang
AG replied to changli
Ok, thanks.
--
AG
Email: npATadhdataDOTcom
Stefan Hoffmann replied to AG
hi,
You should be able to simply display it in WebBrowser control (ActiveX).
http://technet.microsoft.com/en-us/library/ms155874(SQL.90).aspx
mfG
--> stefan <--
AG replied to Stefan Hoffmann
Thank you!
--
AG
Email: npATadhdataDOTcom
Access 2007 with SQL Server 2008 R2 Express DataBase Has anyone tried using Access 2007 linking to tables / views in SQL Server 2008 R2 Express? Any problems? - - AG Email: npATadhdataDOTcom Access Discussions SQL Server 2008 R2 (1) SQL Server 2005 (1) Windows Server 2008 R2 (1) SQL Server 2005
proof DataBase https: / / mcp.microsoft.com / authenticate / validatemcp.aspx transcript: 944364 AccessCode: helloworld Access Discussions SQL Server 2008 R2 (1) SQL Server 2008 (1) SQL Server 2005 (1) Microsoft SQL Server Reporting Services (1) Regards Larry Linson Microsoft Office Access (1
GP 9.0 on SQL 2008 DataBase Is GP9.0 supported on SQL Server 2008? Does GP9.0 appear to perform correctly on SQL Server 2008? Thank you. Great Plains Discussions SQL Server 2005 (1) SQL Server 2008 (1) Database (1
Install and Configure SQL Server DataBase I downloaded SQL Server 2008 Express from here: http: / / www.microsoft.com / express / sql / download / I'm reading a book called 'Microsoft SQL Server 2008 Step by Step'. It says I should have this: Click Start | All Programs | Microsoft
SQL Server 2008 R2 Express Database Size Limit Increased to 10GB DataBase SQL Server 2008 R2 Express Database Size Limit Increased to 10GB Great news for SQL Server Express users today! We increased the maximum database size in SQL Server 2008 R2 Express