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)

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:
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 ...
2
votes
0answers
256 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. ---> ...
2
votes
0answers
197 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
0answers
228 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
157 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 ...
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 ...
1
vote
0answers
15 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
0answers
65 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
13 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
32 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
0answers
241 views

Data Refresh Account - Login Failure: the user has not been granted the requested logon type at this computer

I am trying to configure my Unattended Data Refresh Account and continue to get the following error with the account I am using: The data refresh for 'sqltestrefresh.xlsx' on Report Center - QA ...
1
vote
0answers
161 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 ...
1
vote
0answers
171 views

SharePoint 2013 Reporting Service Integration mode

I face a difficult problem that I don't understand. What I have: SharePoint 2013 Enterprise SQL Server 2012 with all installed SP features, but configured in NATIVE mode. Both on the same server ...
1
vote
0answers
85 views

Reporting Services Webparts not Available in SharePoint Designer 2010

Firstly, I work as a DBA and have very limited understanding about how everything hangs together in SharePoint, so apologies if this is something pretty basic. We have just recently upgraded our WSS ...
1
vote
0answers
325 views

SSRS report on sharepoint becomes blank when clicking back

We're displaying SSRS reports using report viewer webpart. On Internet Explorer, we face a quite strange problem. Normally, reports display just fine. However, sometimes (yes, sometimes, not always), ...
1
vote
0answers
236 views

SSRS 2012 .rdl exposed in aspx page hosted as a web part in SharePoint Online 2013

From what I've read, there's no standard option for adding SSRS 2012 reports to SharePoint Online 2013. Instead, would it be possible to expose a report rdl in an aspx page hosted in SharePoint Online ...
1
vote
0answers
666 views

Problem connecting Sharepoint 2010 to SSAS through a RSDS

As the title says, I'm trying to create a Report Data Source on Sharepoint 2010 where I have an SQL2012 instance with the PowerPivot, SSRS and the sharepoint add-in configured. I choose "Microsoft ...
1
vote
0answers
202 views

Permission are insufficient after Migrating SSRS from Native mode to SharePoint 2013 Integration Mode

I have some SSRS reports which are in native mode on reporting server. The reports have 2 kinds of data sources: database connection and report model. I can run/view the report using my account ...
1
vote
0answers
237 views

Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException

I'm getting following error in the General Application Settings-->Reporting Services-->Set Server Defaults section and also viewing reports on SharePoint. The version of the report server database is ...
1
vote
0answers
41 views

sharepoint ssrs report get query strings

I have a reporting service in sharepoint integrated mode. How could I get report parameters via query strings? please explain it with some examples! Thanks a lot in advanced!
1
vote
0answers
178 views

SSRS Report Designer and SharePoint 2010 Mixed-mode Authentication

We have a SharePoint 2010 installation that connects to a SQL Server 2008 R2 reporting server which is running in SharePoint Integrated Mode. Initially, our web application was using Classic Mode ...
1
vote
0answers
92 views

No email attachments to Document library when using data driven subscriptions

We have recently migrated to SharePoint 2013 and setup document libraries to publish reports to. When we send an email with an attachment to the document library from a users mailbox, the document ...
1
vote
0answers
116 views

Anonymous proxy authentication

So I was just reading How to set Anonymous User as a Specific User and I am not sure exactly how to implement and if it will fully cover my situation. I am trying to tunnel users from Salesforce into ...
1
vote
0answers
249 views

Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint

I'm using SharePoint 2010 and I have access to InfoPath and BCS services. Iā€™m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
1
vote
0answers
383 views

“Actions” menu hidden in Report Viewer web part?

The Actions menu which allows for export to excel, pdf and other functions is hidden in all of my report viewer web parts. I did try to browse to the web part galleries to see if I can set it up ...
1
vote
0answers
244 views

Use an Access Web Database as a data source for Excel?

I have an Access 2010 Web Database published to SharePoint as described here: http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx If my Access ...
1
vote
0answers
80 views

Hide report builder link on Report Services Report Explorer web part

Is it possible to hide the "Report Builder" link that is displayed in the upper right hand corner of the Report Explorer web part? This is on SharePoint Services 3.0
1
vote
0answers
829 views

How to get current Login User Name from sharepoint in SSRS report instead of the SSRS report user name show the serviceAccount name

Currently when run SSRS in development, the user name is show correctly. But, once deploy it to sharepoint, the user name become static which means it keep display service Account name and not the ...
1
vote
0answers
79 views

Query Fields in Sharepoint db via Report Builder

Which is the best way to build a report to display the count of all upload files of a specific group of content types, foreach site collection? Should I use the table AllDocs to create de DataSet or ...
1
vote
0answers
216 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 ...
0
votes
0answers
13 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
0answers
19 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
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
11 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 ...
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 ...
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
0answers
53 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
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
20 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
24 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
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 ...
0
votes
0answers
60 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 ...
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
152 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 ...
0
votes
0answers
16 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 ...