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