pepps11976
asked on
SSRS Report Saved In Sharepoint Libary
Hi All
I am still new to SSRS And Report Builder i have created a report and saved it onto my sharepoint Library, however if a user clicks in the .rdl report file to view it they get the following error message
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Its probably something i have missed can anybody help?
Thank You
I am still new to SSRS And Report Builder i have created a report and saved it onto my sharepoint Library, however if a user clicks in the .rdl report file to view it they get the following error message
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Its probably something i have missed can anybody help?
Thank You
Try setting the connection properties of the data source in SharePoint. Do this to the actual library item in SharePoint.
ASKER
Ok This might be wear i am going wrong all i did was click save as in report builder and saved to a document libary, i am not ware of any data source created, where would this be?
This would be in a library that has the SSRS data source content type. It can be the same library as the report. Create a Shared Data source in report builder and save it (publish) to the document library. Once its there, you can edit its connection properties. You will need to use this data source in your report instead of an embedded one.
ASKER
You only have the option to Use an Existing One Or Create an Embedded one in Report Designer.
So i have used the embedded one and i have found where it puts it in sharepoint, the only way that i can get it to work is by using The SA account where you select the radio button for stored credentials.
This cant be the right way to do this though
So i have used the embedded one and i have found where it puts it in sharepoint, the only way that i can get it to work is by using The SA account where you select the radio button for stored credentials.
This cant be the right way to do this though
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.