Manage a data source for a report found in a SharePoint Document Library

I was working for 2 days on integrating reporting services with MOSS 2007.

The problem i faces was to create a data source for the

uploaded report (Not created using a wizard ) that will connect

me to the SQL server.

As i clicked on the arrow near the uploaded report to manage the data source, i found no

data source for this item.

I would be pleased to know the howto create this data source and where.

Best Regards,

Lana

Here are two recommended approaches to create a shared data source in MOSS 2007:
- Create one in the Report Designer and deploy it to the apprpriate SharePoint Document Library OR
- Add the "Report Data Source" content type from the Document Library Settings. Next, select the "Report Data Source" content type from the Document Library's "New" menu. Next, you should see a web page to create a shared data source.

Hope this helps.

thanx,
Prash

|||

Dear Prash,

I created the doc library that reads a data source

I uploaded a dataSource.rds but it was uploaded as hidden coz i

viewed the content of the doc in the Actions --> open with

explorer view.

Nevertheless, i created a new Report Data Source having the Data

Source Type as Microsoft SQL server but i didn't know what to insert in

theConnection string (Enter a connection string for accessing the report data source).

Although my connection string was empty, i clicked on my uploaded report to manage the data source but i found no data source for this item.

Thanks,

Lana

|||

Please note, that the .rds file is not the shared data source file in SharePoint. For details on creating Shared Data source Refer to SQL BOL topic "How to: Create and Manage Shared Data Sources (Reporting Services in SharePoint Integrated Mode) "

Have you tried deploying the shared data source and Report directly from the designer instead of manually uploading the file into SharePoint? If you manually upload a .rdl file with reference to a shared data source you will have to edit the reference once you have uploaded it to SharePoint via "Manage Data Sources". Generally, deploying the report and shared data source from the designer should preserve the reference from the report to the shared data source.

For details on connection string information refer to SQL BOL topic on "Connecting to a Data Source".

Hope this helps.

thanx,
Prash

sql