Skip to Main Content
Microsoft® SQL Server 2005 Reporting Services
book

Microsoft® SQL Server 2005 Reporting Services

by Michael Lisin, Jim Joseph
March 2006
Beginner to intermediate content levelBeginner to intermediate
480 pages
11h 17m
English
Sams
Content preview from Microsoft® SQL Server 2005 Reporting Services

Appendix C. FAQ

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 to an Oracle database?

A A direct connection between Report Builder 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 OLEDB-or ODBC-compliant data source, including Oracle.

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

A Although it is not possible to join two data sets directly, it is possible to simulate this feature. Depending on what you are trying to accomplish, there might be ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server™ 2008 Reporting Services Unleashed

Microsoft® SQL Server™ 2008 Reporting Services Unleashed

Michael Lisin, Jim Joseph, Amit Goyal

Publisher Resources

ISBN: 0672327996Purchase book