Showing posts with label document. Show all posts
Showing posts with label document. Show all posts

Wednesday, March 28, 2012

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

Monday, March 12, 2012

Make a document repository application with blob fields?

Hello, my company is thinking in make a document repository application and I have read many times that its not recommended to save the files to the database, because it adds ovverhead to other users that are using transactions or something else.

I need to convince my boss that its a bad practice to put the files on BLOB fields inside the database.

Any ideas!!

Well, my first question would be "how would you plan on getting them OUT of the database?". That is always the problem with BLOBs.

In order to display the "file" from the BLOB, you will need to convert it back to a file. So just keep it a file, and use the database to index to it. If you are concerned about security, then create a process which copies the file from a secure area to a place the user can get it, and then delete it when done.