SQL Server 2008
(1)
SQL Server
(1)
Access 2007
(1)
Office
(1)
Excel
(1)
NpATadhdataDOTcom
(1)
Database
(1)
AGEmail
(1)

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

Hi AG,No,there is no compatible interface for converting SSRS report to

changli replied to AG
08-Feb-10 06:10 AM
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

Ok, thanks.--AGEmail: npATadhdataDOTcom

AG replied to changli
08-Feb-10 08:03 AM
Ok, thanks.

--

AG
Email: npATadhdataDOTcom

hi,On 07.02.

Stefan Hoffmann replied to AG
08-Feb-10 08:11 AM
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 <--
Thank you!--AGEmail: npATadhdataDOTcom
AG replied to Stefan Hoffmann
08-Feb-10 01:22 PM
Thank you!

--

AG
Email: npATadhdataDOTcom
Post Question To EggHeadCafe