SQL Server Reporting Services Reports in Access

[AG]

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.

 

[Charles Wang [MSFT]]

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]

Ok, thanks.

 

[Stefan Hoffmann]

hi,

Is there a way to display SQL Server Reporting Services reports in Access
2007?

You should be able to simply display it in WebBrowser control (ActiveX).

If so, links to documentation/examples would be appreciated.

http://technet.microsoft.com/en-us/library/ms155874(SQL.90).aspx


mfG
--> stefan <--

 

[AG]

Thank you!

--

AG
Email: npATadhdataDOTcom

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 <--