Questions tagged [reporting-services]

SQL Server Reporting Services (SSRS) is server-based report generator from Microsoft. It provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality. Administered via a web interface, it can be used to prepare and deliver a variety of interactive and printed reports.

136 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
8
votes
4answers
7k views

Report Viewer Web Part Alternatives in SP2013

We have a need to upgrade from SP2010+PWA to SP2013+PWA. Our database server will be SQL Server 2008 R2. According to Technet, the SQL 2008 R2 Reporting Services add-in for SharePoint isn't ...
3
votes
1answer
4k views

SSRS data source: Can't use stored Windows credentials, “SharePoint does not use Windows authentication”

I'm running a single-server deployment of SharePoint 2013 and SQL Server 2014 with SSRS in SharePoint-integrated mode. When trying to set up a subscription for a new report, I get a popup saying: ...
3
votes
1answer
2k views

SharePoint 2013 SQL Reporting Services 2014 500 error

We have a 3 server farm: 2 WFE, 1 App. SharePoint Enterprise license The App server has the SQL 2014 reporting services integrated SharePoint with the add in installed. The WFEs all have the Add in ...
3
votes
1answer
2k views

How to have Report Viewer Web Part for SP 2013 and SQL Reports 2008 R2

I am trying to display a SQL Reports 2008 R2 report in SharePoint 2013. I am confused because I can not find a web part for SharePoint 2013 that can display a SQL Server 2008 R2 Report. Am I ...
3
votes
0answers
233 views

Removing leading spaces/newlines left from unchecked Multi-Select box

I have a multi-select box with 15-20 values in it corresponding to SharePoint users. The problem I'm having is that for every entry in the Multi-Select box that is not chosen, a new line or blank line ...
3
votes
1answer
3k views

Is it possible to view/edit SSRS datasets from sharepoint?

I have a bunch of shared datasets on my old report server and I want to copy them to a SharePoint Document Library. I'm running SSRS integrated mode in SharePoint 2013 and I've already created my ...
2
votes
0answers
70 views

SSRS 2008 R2 Shared Datasource References Gone

I have a farm with SharePoint 2010 integrated mode SSRS 2008 R2. A few days ago, one night at about 02:00 AM, almost all shared data source references had gone. I couldn't find any clue at neither ...
2
votes
1answer
343 views

Error occurred during report processing. Report server is unable to access encrypted data. Apply backup key or delete all encrypted content

I have migrated the SQL Server Reporting Sevices from SharePoint 2010 to SharePoint 2013. I followed Migrating SharePoint 2010 Reporting Services To SharePoint 2013 to migrate SQL Server Reporting ...
2
votes
1answer
1k views

SharePoint report viewer error There are no addresses available for this application

i have single server (sql 2016 +all SharePoint 2016 role) when i click on a report to run (uploaded rdl file) SharePoint give me error There are no addresses available for this application and in ...
2
votes
0answers
193 views

SSRS Report in SharePoint Online

Can we use the SSRS report in SharePoint online using SharePoint Provider Hosted App?
2
votes
1answer
186 views

Display SharePoint report in Windows Forms Report Viewer

I have a report uploaded in SharePoint and it works fine. However i need to insert this report in Report Viewer inside Windows Forms. I get this error while using below code "The permissions ...
2
votes
0answers
539 views

Zoom SSRS Report to fit Web Part size

I am creating a dashboard in SSRS made up of eight SSRS charts all displayed on a single page. This page is to be resizeable / work on numerous screen resolutions. I have made the SQL Server ...
2
votes
0answers
139 views

Report alerts still sending after alert and report was deleted

I have an SSRS report in SharePoint 2010, there was an alert set to send every minute regardless of whether the data changed. This alert was deleted, then the report was deleted, but its still sending ...
2
votes
1answer
405 views

Sharepoint and SSRS query issue

I am using SSRS 2008 R2 with Sharepoint 2010 list and I have two reports from same SharePoint list. They return the same thing, only diffrence is the filtering part. How can we check in a CAML query ...
2
votes
0answers
383 views

Error on creating Report Model :Data extension does not support model generation

I'm trying to create a Report builder Model using a SP Custom List as Datasource. But it returns me the following error: Data extension does not support model generation. ---> Microsoft....
2
votes
0answers
251 views

What is the ConsumerConnectionPointID to use when adding an SSRS Report Viewer Web part declaratively?

I'm having trouble connecting my custom web part to my report viewer web part when using XML markup. My custom web part implements ITransformableFilterValues, so in order to pass values to the SSRS ...
2
votes
1answer
473 views

SSRS reports deployment in production server

We have 50 SSRS report created in SharePoint 2010 integrated mode. Now we want to move these 50 SSRS reports to production server. Do we need to create script for this deployment (of report in ...
2
votes
0answers
216 views

Package and Deploy SSRS Reports / Datasets etc

I have a VS report solution that contains around 40 reports as well as the child reports, sub reports, shared data sets, and data sources. How do I package these for SharePoint to deploy as a managed ...
2
votes
1answer
267 views

Moving reports from sharepoint 2007 to 2010

I currently have both a sharepoint 2007 farm and a sharepoint 2010 farm, both have an SSRS server. I need to move the reports from SP 2007 to SP 2010 and I'm not sure how to do this easily.
1
vote
0answers
50 views

Sharepoint List's Custom Field value appears empty in ssrs report when run in sharepoint integrated mode

I have a sharepoint list that contains custom field(its is developed as .wsp solution), its a file upload control and two rendering templates 'display' and 'edit' templates are defined. 'Display' ...
1
vote
0answers
17 views

Report Server URL on SharePoint Integrated Mode

I have a SSRS 2008R2 integrated mode SharePoint 2010 environment and this environment is not working fine. So I want to reach the report server on that farm. On native mode, http://www.example.com/...
1
vote
0answers
30 views

Client cannot open report builder on reports on other subsites

We have SSRS that is Sharepoint integrated. We have report builder downloadable from our sharepoint server as well when users modify rdl reports. We have one client that is able to open reports in ...
1
vote
0answers
72 views

Failing sending mail: Report Server has encountered a SharePoint error.Mail will not be resent

I am using SharePoint to schedule subscriptions for SSRS reports. I have one report that has roughly 40 subscriptions and has been working perfectly for 6 months up until last week. Last week all of ...
1
vote
0answers
41 views

Some pages in SharePoint not accessible with FQDN

My customer's network is designed to enforce business users to only access web applications with FQDN. Business users can only access SharePoint site with FQDN example: http://abc-intranet.abc.local ...
1
vote
0answers
71 views

SSRS hosted on SharePoint 2013 Export to Excel unable to open the exported Excel file

We have a SSRS Report hosted on SharePoint 2013. The problem is when we export it in Excel and try to open it Excel gives us an Error that "Excel found unreadable content in this file". Strange part ...
1
vote
1answer
353 views

SharePoint 2016 SOAP Query Not Returning ViewFields

I'm using SQL Server Report Builder to migrate an old report from MOSS 2007 to SharePoint Server 2016, and, in this report there are 3 data sets. I've changed out the view GUIDs to the new values they ...
1
vote
2answers
125 views

View or log to see who has run a report

The client has SP 2013 with SSRS reporting integrated. I have built some reports for them and they work great. On one of the reports, the client would like to be able to see who has run the report as ...
1
vote
0answers
498 views

ReportingService Databases running in compatibility range, upgrade recommended

We are running a stand alone SharePoint 2013 install. I have gotten the following message regarding various databases within the install on different occasions and I am always able to resolve them ...
1
vote
0answers
183 views

http://<Server Name>/ReportServer/ReportExecution2005.asmx unable to load the web service in browser

http:///ReportServer/ReportExecution2005.asmx unable to load the web service in browser I get HTTP 500 error on the Browser. In ULS logs i get the below mentioned error: Token Cache: Could not find ...
1
vote
2answers
411 views

Power View reports no longer open in SharePoint - “Server cannot be found”

I have SharePoint 2013 + SQL Server 2012 SSAS Tabular Mode + SSRS running in SharePoint integrated mode for business intelligence reports. This is in 2 environments, QA and PROD, which are identical ...
1
vote
1answer
571 views

using SSRS to generate a report based on a Calendar in Sharepoint 2013

We use the calendar in SP2013 to collect information when a user is away on holiday and when there will be any visitors. It works fine as a calendar but now struggling to generate a report in SSRS to ...
1
vote
2answers
136 views

How to export Sharepoint 2013 list to SQL Server

Suggest best possible way to add data from SharePoint 2013 list to SQL. If the suggested option is SSIS please elaborate on how to perform the same, i am not able to find any links or video tutorials ...
1
vote
0answers
104 views

Temporary profile error when creating Reporting Service Application

This is the first time I am setting up a farm, so please bear with me. The SharePoint farm has following servers: 2 SP Web Front Ends(Having Load balancing) 2 SP Application Servers 1 SP Database ...
1
vote
1answer
272 views

error while configure reporting services and run configuration wizard

I want to configure SQL Server reporting services service sharepoint 2013. install sql server 2012 then install manually service pack 1. In During installation of service pack 1, Reporting Services ...
1
vote
0answers
128 views

Reporting Services SubReport only works first time

Well, this is weird: My server: SharePoint 2013 Enterprise farm with SRSS up & running & several simple reports working. My development environment: Microsoft Visual Studio 2013 Pro with SQL ...
1
vote
1answer
916 views

SharePoint error Report Server has encountered

I am trying to configure SSRS 2008 R2 using SharePoint Integration mode on SharePoint 2010 server, I have followed some blogs including MSDN to configure SSRS in Integrated mode. But once I click on ...
1
vote
1answer
252 views

SSRS and SharePoint List - rsSPDataProviderError when changing fields

I have a report saved to a SharePoint library. With that report, I have a shared dataset and datasource. The report, dataset, and datasource are linked together. I recently made a change to a ...
1
vote
1answer
322 views

Report Server Integrated 401 unauthorised error

I have set up Report Server in Integrated mode, using the Service Account as Network Service. On the report server I can log onto the web service using my credentials just fine. However when I try and ...
1
vote
2answers
97 views

Rendering SSRS Report located in _layouts folder?

Does anyone have any knowledge on how to load an SSRS report located in the _layouts folder? I am able to load it if it's in a document library and here is the URL that it has: http://mysite/...
1
vote
0answers
238 views

Error when Uploading an RSDS File to SharePoint, collection and SSRS out of synch

I have a site collection with an RSDS file in it that gets modified by a powershell script. The script downloads the rsds file, modifies it, then uploads the new copy. It works great but the file is ...
1
vote
0answers
38 views

Error when setting up Reporting Services

I'm trying to set up Reporting Services on my SharePoint farm however I am getting this error when I try to access the URL: The configuration parameter SharePointIntegrated is set to True but Share ...
1
vote
0answers
298 views

Can't find the cause of user credential prompts in SharePoint site

I have a SharePoint 2013 instance that runs our company intranet site. This past weekend we moved our site to a new set of servers and we also set the site up use SSL (https). Since this move, some, ...
1
vote
1answer
23 views

Separating SharePoint instance from Reporting Services (currently shared instance)

Currently we are running SharePoint 2007 and Reporting Services on the same server. Our reporting group would like to decouple this integrated environment. I've found several sources on how to ...
1
vote
0answers
2k views

Mail won't send - specified string is not in the form required for an e-mail address - SSRS Subscriptions

I am running SharePoint 2013. We use Exchange Online for e-mail. Because we have this set to require SSL, and SharePoint won't send mail with SSL, I have a local SMTP relay set up on the SharePoint ...
1
vote
0answers
909 views

Removing SQL Server reporting services from Sharepoint 2013

I installed SQL server reporting services on one of our front ends and everything stopped working -- images stopped displaying, users got permissions errors. I tried to remove it from installed ...
1
vote
0answers
33 views

Report Server has encountered a SharePoint error

I'm trying to deploy a report created with SQL Business Intelligence 2008 on a Sharepoint 2007. I've done this process a lot of time, but since yesterday I receive this error when deploying: "...
1
vote
0answers
91 views

Connecting MS Access Web Database Tables and Queries

I have created MS Web Access Database (2010) and hosted in SharePoint 2010. I would like to create reports in SharePoint using MS Web Access Database Tables; possibly using SSRS. I'm able to develop ...
1
vote
1answer
81 views

How transform results of caml query to rows into columns

Can anyone tell me how to transform results of caml query to rows into columns. Caml query is returning results from sharepoint list in the below format. Column1 Column2 Column3 Value 1 Value 2 ...
1
vote
2answers
215 views

Report published from BIDS not trigger “new-item” workflow

SharePoint 2013, SSRS 2013 SharePoint integrated mode. Document library with correct content types for SSRS. Workflow on that library set to run on "new item" and "edit item". Workflow is set to a ...
1
vote
1answer
155 views

SSRS Code Behind and SharePoint

I have a couple of general questions about using VB code with SSRS reports in SharePoint. I have noticed that when I use an expression on my report, the expression only talks to the data that is in ...