Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SSRS in sharepoint

  Asked By: Aida    Date: Jul 12    Category: Sharepoint    Views: 1187

I have some data in oracle, and some data in sqlserver.Is it possible to build one ssrs report with these two data sources....



1 Answer Found

Answer #1    Answered By: Virendar Chaudhari     Answered On: Jul 12

This is not a MOSS query but an SQL Reporting Services query, anyways the quick answer is you will have to create your own provider that will combine both the datasource (also one quick workaround would be to created LinkedServers in SQL and create a SQL Stored proc with that).

Search on your favourite search engine for SQL RSS and datasource, you will find multiple answers.

Didn't find what you were looking for? Find more on SSRS in sharepoint Or get search suggestion and latest updates.