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)

2
votes
1answer
265 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 ...
3
votes
1answer
51 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

unable to load client print control error while printing

in our sharepoint 2007 farm . we are facing print issue in SSRS and users are getting errors "unable to load client print control" . with the help of our DBA's we found out that the issue is in the '...
0
votes
0answers
14 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
51 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. ...
2
votes
2answers
58 views

Sharepoint reporting on permission

I wanted to get a report of all the user in SharePoint and know what each user has permission. I am trying to track down each user permission level for every site they have so I can identify if they ...
0
votes
1answer
28 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
42 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
14 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
20 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
135 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
47 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
45 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
1answer
141 views

SSRS Multi Parameter Report not working in Sharepoint 2013

I have a report which has 2 Parameters both 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
86 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
9 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
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 ...
0
votes
1answer
2k 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
31 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
83 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 ...
1
vote
0answers
320 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
36 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
87 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
48 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
0
votes
1answer
114 views

Manipulate Report Viewer Webpart Parameters via PowerShell on a SharePoint 2010 WebpartPage?

I want to set the parameters of a SSRS report which is displayed through the ReportViewerWebPart by PowerShell, all on SharePoint 2010 WebpartPage. Right now, I'm confused by the documentation of the ...
0
votes
0answers
41 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
36 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
126 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 ...
0
votes
0answers
28 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
1answer
49 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
0answers
60 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
2answers
102 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, http://SITEURL/_layouts/15/...
0
votes
0answers
15 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 ...
0
votes
1answer
149 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.
1
vote
1answer
49 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
23 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 ...
4
votes
2answers
2k 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
18 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 ...
0
votes
0answers
24 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
36 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
246 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
57 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
72 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
31 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
27 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
58 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
13 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
0answers
178 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
37 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
85 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 ...