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 ...

learn more… | top users | synonyms (1)

0
votes
0answers
7 views

RSViewerPage breadcrumb, where to change link

Received a request today to modify the URL for this breadcrumb on a Report (RDL). We have are using the internal ReportServer setup for SharePoint. Visual: I have looked at the RSViewerPage to see ...
0
votes
0answers
14 views

SSRS report issue inside of SharePoint 2013 reports

Win7, IE11, SP2013, SQL12, and SSRS the Printer Icon never renders for users to print a report? Have updated the ReportViewer dll, SP1 for SP2013, SP1 for SqlServer with cumulative patch 8 applied. ...
0
votes
0answers
14 views

How can you get results from a SharePoint document library (with folder and child items) in a SSRS report?

I have a SSRS report that uses a SharePoint document library as a data source. The issue is that the list has folder and in those folders are child items. The dataset is only returning items from the ...
0
votes
1answer
13 views

How can i work out if my SharePoint 2010 has a Report Server set up?

I have been given a SharePoint 2010 environment, and wanting to know if a report server has been set up. Is there anyway I can tell? When I go to Set server defaults in General Application settings ...
0
votes
0answers
20 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 ...
0
votes
1answer
11 views

what binaries do i need to get SP reports working on sharepoint 2010

I am configuring the report services on my sql server and am wondering what sharepoint binaries I need to install on the server to get the reports up and running.
1
vote
0answers
10 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 ...
0
votes
1answer
37 views

SQL Server Reporting Services Service Application Encryption Error

I'm trying to create a new SQL Server Reporting Services Service Application, I go in and set all my settings and the application creates just fine. But when I click on the service application i ...
1
vote
0answers
16 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, ...
0
votes
0answers
20 views

SSRS multi parameters problem in sharepoint 2013

I have a reports which has 5 Parameters are multi select. It works fine in SSRS Reporting Manager and Report Builder but when I host in SharePoint and try to select multiparameter it doesn't do ...
0
votes
0answers
14 views

How to enable MS Project Server Web App Reporting in MS Project server 2013?

I have MS Project server 2013, I want to enable reporting I have followed steps given in (https://technet.microsoft.com/en-us/library/ee662106.aspx ) but still when I click first it opens excel and ...
0
votes
0answers
8 views

Removing an SSRS Server

We have a server in our SharePoint 2010 farm that runs SSRS in "integrated mode". We would like to remove this server from our farm and run it in "Native mode". How can this be accomplished? Do I ...
1
vote
1answer
22 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 ...
0
votes
1answer
49 views

SSRS reporting in SharePoint Online

Can we Create SSRS Reports in SharePoint Online? https://community.office365.com/en-us/f/154/t/239208 This article states that we cannot, but the information is old, What's the latest on this?
1
vote
1answer
19 views

SQL Report Builder 3- build report from different lists dynamically

I have an script that automatically creates a SharePoint list for each new SiteCollection in my WebApplication, so I have many different lists each contains the same columns. The lists name matches to ...
0
votes
1answer
31 views

Usage Reports of SharePoint 2013 site are showing empty data. Yet Timerjobs are running properly

I am working on SharePoint 2013 usage reports. And I need to check that at how many times the users have hit the SharePoint 2013 SSRS reports in the document library on monthly and daily basis. I have ...
0
votes
0answers
14 views

Can't access SSRS reports on SharePoint 2007 farm

We get this error in the Report Server logs when trying to access a report on the SSRS server: security!ReportServer_0-7!20c0!12/22/2015-10:41:11:: i INFO: Exception while running with ...
2
votes
1answer
55 views

Is it possible to get data from excel file and create a pie chart and display on a sharepoint site?

Can we create a pie chart using excel reporting service. I have a excel file (.xlsx) on my SharePoint document library. I want to use excel data and create a pie chart but don't want to create this ...
3
votes
2answers
41 views

How to check SharePoint Installed in “SharePoint integration Mode”

Is Reporting Service Integration Mode available in the server farm or not. How to check? Environment: SharePoint 2013 Enterprice SQL Server 2008 R2
3
votes
0answers
21 views

List of all subscription

How to check all report's subscriptions on Sharepoint 2010? I know only how to check subsciption on specific report:
0
votes
0answers
29 views

BCS is to get external data into SP, what about the other way around?

I am going to migrate/update our SP 2010 to 2013 or 2016 (depending on when it actually gets released). Preferably cloud. What our fear is currently is... if we go cloud will we really have access to ...
0
votes
1answer
17 views

Upgrade SSRS in SharePoint integrated mode from 2012 to 2014?

I can't find the specific procedure for doing this. I've tried running the upgrade wizard from the SQL install utility, and the upgrade goes fine. However, the ServerUpgradeHistory table for the ...
0
votes
0answers
61 views

An unexpected error occurred while compiling expressions. Native compiler return value: `-1073741511'

I keep getting the error in the title when I try to access or modify any RDL file that uses an embedded data source from a SharePoint report library (I have approximately 14 reports). This error is ...
1
vote
0answers
75 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 ...
0
votes
0answers
21 views

SharePoint online - API data access quality

How much access to the data will I have if I use SharePoint online? Will I be able to do reporting from any list or rdl hosted in SP online via the available javascript api? What about pulling data ...
0
votes
0answers
23 views

Windows Authentication with SSRS Subscriptions

We're starting to develop some SSRS reports using SSRS in SharePoint integrated mode. Environment consists of SharePoint 2013 with SQL Server 2012. Things are working great, except for using ...
0
votes
0answers
25 views

How to change the path “_layouts/15/” of RSViewerPage.aspx in IIS 8, when configured Reporting Services to run in SharePoint Integration Mode

I want to add the folder LAYOUTSBWBI which is exactly the copy of the LAYOUTS folder. As I have been told to do some customization on "RSViewerPage.aspx". And as we know that the RSViewerPage.aspx ...
0
votes
1answer
22 views

Want to add logo image and add some UI in RSViewerPage.aspx page under “/_layouts/15/ReportServer/”

I want to add one image as a logo in "RSViewerPage.aspx" in sharepoint 2013 site under "/_layouts/15" folder. Where SSRS reports are shown. I want to add some UI to that page, as per my requirement. ...
0
votes
2answers
46 views

Not able to open RSViewerPage.aspx page in SharePoint Designer 2013

I need to customize SharePoint Reports and show bar charts on it and do some customization's on it. I am trying to open following URL in SharePoint Designer 2013, ...
0
votes
0answers
12 views

Orphanded SSRS 2008 content types in SharePoint

We had upgraded from SP 2010 to 2013. Prior to the upgrade, it appears we had a broken install of SSRS 2008. It never worked. I was hoping the upgrade and the new version of SSRS (2012) would fix the ...
1
vote
1answer
38 views

Configure SSRS with SharePoint 2010 Complete Server without AD

Is it possible to configure SharePoint 2010 in claims mode on an all-in-one development box with SQL Server 2012? If so, how? To be clear, this is a development box that is NOT attached to a domain. ...
0
votes
1answer
56 views

SharePoint image list item how to display in SSRS report using Report Builder?

Creating SSRS report using SharePoint site as a data source how to display SharePoint list image item URL in SSRS Report display image.
0
votes
1answer
12 views

Can we Integrate Cube report from different DB Server with SP2013?

We have a standalone farm Installation of SharePoint 2013. All the below components are on single server say Server1: SharePoint 2013 SQL Server Reporting Services (SSRS) I want to integrate cube ...
0
votes
0answers
66 views

SSRS integrated Sharepoint Actions Menu Data Fetch Error

In our environment, we have SSRS 2012 integrated with SharePoint 2013. One of our report we get error when we click on Actions menu An error has occured with the data fetch. Please refresh the ...
0
votes
0answers
45 views

SP2013 Analytics - user visits per page

wondering if anyone can help with a few questions I have on SP13, and the OOTB functionality (or there is any third part tools) that produce the following stats... Page views by user (i.e. a list ...
0
votes
0answers
11 views

Create SSRS data alerts programatically or XML

I'm just getting into data alerts and see from technet (https://msdn.microsoft.com/en-us/library/gg492251.aspx) that data alert definitions are unique to the selected parameters. My problem is that it ...
4
votes
2answers
505 views

Publish SSRS report to SharePoint document library

This question is a copy of my question on stack overflow. Didnt know this forum existed until now. I cannot find a way to publish/deploy my reports to a SharePoint document library. I have exhausted ...
0
votes
0answers
22 views

Charts using PerformancePoint or SSRS; What is best for Graphical Reports/Charts?

I have a InfoPath Form Library and a SharePoint List. By apply union on these I want to create Pivot Tables and represent the results in Pivot charts. What is the best way of creating graphical ...
0
votes
0answers
24 views

SSRS208 with sharepoint 2010 Intrigrated mode- ERROR: Appdomain:4 WindowsService_2 failed to initialize. Error: The endpoint cannot be created

I am trying to run SQL server 2008 SSRS with sharepoint Intrigrated mode and end up with ERROR: Appdomain:4 WindowsService_2 failed to initialize. Error: The endpoint cannot be created. Production ...
0
votes
0answers
153 views

The user name or password is incorrect-Log on failed. The remote server returned an error: (500) Internal Server Error

Situation: 1. Windows 2008 R2 Data Center Edition > Data Base Server – Microsoft SQL 2008 R2 RTM > Data Base 2. Windows 2008 R2 Enterprise > WFE – SharePoint 2010 Enterprise – PowerPivot ...
2
votes
0answers
37 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 ...
0
votes
1answer
65 views

SSRS Report Management and Deletes

How do I properly delete reports and data sources when deployed to a SharePoint list? There doesn't appear to be any report control from the App service management page and while I can certainly just ...
0
votes
0answers
17 views

Subscriptions table on ReportServer database is suddenly empty

We have sharepoint 2010 and I have become the one over time to start maintaining it. The trick is of course I didn't build the system and have inherited a system that has been passed between multiple ...
0
votes
0answers
16 views

Issues in the SSRS report deployed in the sharepoint

I am working on an SSRS report and have deployed that in the SharePoint. My SSRS report has a column grouping and I have configured some columns as hidden and can be toggled based on the textbox ...
0
votes
0answers
34 views

SSRS using SharePoint list - integrated security vs. stored credentials

I have an SSRS report that uses a SharePoint list as a data source. The report works using integrated security; however not all of the users will have access to the list (and I cannot grant additional ...
0
votes
0answers
8 views

SharePoint 2013 SSRS invalid certificate

Our SharePoint is on the internet, but our SSRS is not. We are trying to use the SSRS webpart but keep getting invalid or untrusted certificate errors. We can eventually click on proceed anyway, but ...
1
vote
1answer
343 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 ...
0
votes
0answers
76 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 ...
0
votes
0answers
31 views

Unable to see active subscriptions on SharePoint Reports

We have reports (rdl files) loaded into a report library in SharePoint 2013. The files are successfully sending out weekly reports via email. However, besides the person who created the ...
0
votes
1answer
57 views

Completely remove field from Content Type?

I recently tried to delete a Multi-line Text Field from a custom Content Type. I then attempted to delete this field, and re-create it as a Single line of text under the same field name. After ...