Appendix C. Frequently Asked Questions and Additional Information

The intention of this appendix is to share answers to some common questions about SSRS. The appendix is presented in the Q&A (question-and-answer) fashion.

Q Can I connect Report Builder 1.0 to an Oracle database?

A direct connection between Report Builder 1.0 and Oracle is not supported; however, you can connect to an Oracle database by leveraging link servers or the Analysis Services Unified Data Model. Both provide a thin layer of abstraction and allow usage of any OLE DB- or ODBC-compliant data source, including Oracle.

Q Can I join two separate data sets in a report?

Although it is not possible to join two data sets directly, it is possible to simulate this feature. Depending ...

Get Microsoft® SQL Server™ 2008 Reporting Services Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.