Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

3
votes
0answers
232 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 ...
2
votes
0answers
69 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
0answers
182 views

SSRS Report in SharePoint Online

Can we use the SSRS report in SharePoint online using SharePoint Provider Hosted App?
2
votes
0answers
511 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
138 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
378 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
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 ...
1
vote
0answers
41 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
16 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
24 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
67 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
38 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
69 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
0answers
471 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
170 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
0answers
101 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
0answers
124 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
0answers
230 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
281 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
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
893 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
0answers
428 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
453 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 So ...
1
vote
0answers
142 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
572 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
320 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
934 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
296 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
368 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
46 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
262 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
107 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
146 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
307 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
543 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
321 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
96 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
87 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 ...
0
votes
0answers
17 views

How to render/embed SSRS report in SharePoint 2019?

I am working with SharePoint on premises 2019. There are several SSRS reports developed and I would like to render them on a either classic or modern page. Can someone help me with the best way to ...
0
votes
0answers
18 views

The requested Data Feed could not be found (rrDataFeedNotFound)

we have couple of rdl files with data alerts in SharePoint from past week we are getting status as The requested Data Feed could not be found (rrDataFeedNotFound)The log file contains detailed ...
0
votes
0answers
24 views

TaskDriverEventArgs.EventCriticalityType error while installing Microsoft SQLServer 2012 Rs Add-in for SharePoint

HI i when I try to install Microsoft SQLServer 2012 Rs Add-in for SharePoint in one of WFE server I get following exception and installation not succeeded and i get below error in ULS logs and event ...
0
votes
0answers
19 views

ReportServer -> ManageSubscription.aspx

Is it possible to add SPSubscriptionProperties.aspx properties like - CC, report format and etc -> in ManageSubscription.aspx view?
0
votes
0answers
61 views

Object reference not set to an instance of an object. Error

I'm getting this error when I'm trying to reach sites. Also I have this error on logs. Is there any opinion? UserProfileApplicationProxy.InitializePropertyCache: System.Configuration....
0
votes
0answers
80 views

Sharepoint Data source type is missing in visual stuido 2017

I am using Visual Studio 2017 enterprise edition to create a RDLC report. First of all my visual studio did not come with RDLC pre-installed, so I have successfully installed it via nuget package. ...
0
votes
0answers
17 views

What account(s) to use for SPD workflow that changes item approval status?

I have a custom SPD Workflow (2010 workflow on 2013) which mimics the OOTB Publishing Approval Workflow. The only difference is that if the files are in a certain subfolder in the library, the file ...
0
votes
0answers
159 views

Can SharePoint perform full-text indexing on SSRS reports?

We have installed SSRS on SP2013 on-premise. The report files (*.rdl) can be opened by users but the content are not being indexed. May I know is it possible to setup indexing on SSRS content? P.S. ...