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
35 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
81 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
3
votes
1answer
45 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
39 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
33 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
117 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
266 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
26 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
115 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
50 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
44 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
91 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 ...
1
vote
1answer
44 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
129 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
22 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
114 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
76 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
15 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
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
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
226 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
56 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
71 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
27 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
26 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
54 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
1answer
679 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 ...
1
vote
0answers
161 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
75 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 ...
0
votes
0answers
40 views

Should SSRS (Sharepoint mode) be installed on WFE or Application server?

Should SSRS (Sharepoint mode) be installed on WFE or Application server? I want to install SSRS on a sharepoint farm having 3 App server 3 Web front end servers 2 SQL servers
0
votes
0answers
83 views

Where to install SSRS SharePoint mode in a multi-server environment?

Hi I am setting up sharepoint and sql server integration environment. I am considering the following topology: PowerPivot for SharePoint 2013 and Reporting Services in SharePoint mode Two Server ...
0
votes
0answers
81 views

Issue when display SSRS report in Sharepoint 2010 SQL reporting Services report viewer web part with Query string (URL) filter Parameter

i'm trying to display SSRS report(with parameter) in SharePoint 2010 using SQL report viewer web part . So far .. 01 . deploy the SSRS report to SP2010 02 Add and configure SQL report viewer web ...
2
votes
2answers
53 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
0answers
122 views

SQL Server reporting services report viewer parameters not visible after applying filters(Query string URL filter)

I am currently working on SharePoint 2013 and SSRS 2012. I have added a SQL Server Reporting Services Report Viewer web part on a page with few parameters. Next, I've configured QSUF (Query string URL ...
0
votes
0answers
55 views

How to deploy SSRS report in production server

For SharePoint 2013 on-prem project, we have created SSRS report and published all report in the development server but right now wants to take all of them to production. I heard just uploading the ...
0
votes
1answer
28 views

A Different SQL Server for Reporting Services

Is it possible to configure SharePoint to use one SQL Server setup with Database Engine Services for configurations and content databases and another SQL Server setup with SharePoint Reporting ...
0
votes
0answers
9 views

data filter ssrs 2010 dosent work

My sharepoint list has 7000 items, I made report from this list 10 month ago, report made by data tools 2010. I have date filter in my report, table of report filter by parameter as date type. I ...
0
votes
2answers
182 views

Configure SSRS for SharePoint 2013 with PowerShell

So I have to configure SSRS on my box and i tried to search feature name "Report Server Integration Feature" and could not found and my search lead to below two post. Installing Reporting Services In ...
3
votes
2answers
173 views

Import-SPWeb - Feature 'ReportServer' is deployed but its version '14.0.0.0' is below the miniumum required version of '15.0.0.0'

I am trying to import a site from my production to test environment but am getting the error below. I've run psconfig but this hasn't upgraded the feature. Any advice on what I need to do to upgrade ...
0
votes
0answers
17 views

How to show report from 10 related large list in SharePoint 2013 online?

Since SSRS report is not available in SharePoint 2013 online, how can we show complex report combining data from few very large size and related lists? in case of on-prem we had used SSRS in similar ...
1
vote
0answers
16 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
50 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
131 views

Conditional subtraction

I need to create a calculation that basically is a subtraction between two fields (2 date fields). However it should be done only if a 3rd field is equal to a value of 5 or 6. My first field is ...
0
votes
1answer
115 views

Get rid of Duplicates in SQL Report Drop down Parameter (SharePoint Report embedded)

Is it possible to have a drop down parameter only show a unique value if I have multiple values? If I have 5 items with 123, I only want 123 to show up once in the drop down. Currently I have a ...
0
votes
0answers
56 views

RDL reports do not work in Mobile Devices in SharePoint 2013

RSViewerPage.aspx does not show all RDL reports in mobile devices.(IOS, Android) I have On-Premises SharePoint Farm application. It means I can change RSViewerPage.aspx if there is any need. Is ...