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.

140 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
81 views

How transform results of caml query to rows into columns

Can anyone tell me how to transform results of caml query to rows into columns. Caml query is returning results from sharepoint list in the below format. Column1 Column2 Column3 Value 1 Value 2 ...
1
vote
2answers
215 views

Report published from BIDS not trigger “new-item” workflow

SharePoint 2013, SSRS 2013 SharePoint integrated mode. Document library with correct content types for SSRS. Workflow on that library set to run on "new item" and "edit item". Workflow is set to a ...
1
vote
1answer
155 views

SSRS Code Behind and SharePoint

I have a couple of general questions about using VB code with SSRS reports in SharePoint. I have noticed that when I use an expression on my report, the expression only talks to the data that is in ...
1
vote
1answer
36 views

Impact of upgrading Sharpoint 2013 to Sharpoint 2013 Service Pack 1 on SSRS Reports

Hope you all are doing well! We have a BI System that consists of SQL server Reporting Services 2008 R2 and we have deployed the reports on Sharepoint 2013. We were planning to upgrade the Sharepoint ...
1
vote
2answers
157 views

PerformancePoint webpart showing report from Reporting Service, but is showing cached content!

I am using sharepoint 2010. I have created some reporting service report. On some page, I have created the PerformancePoint webpart to show the reporting service report. It works and shows content. ...
1
vote
0answers
434 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
2answers
77 views

How to decide between native SharePoint Lists or External Content Types?

We need some guidance on where we should house data for an application that will have all the data entry performed through SharePoint. Our team is building a HelpDesk ticketing system in SharePoint. ...
1
vote
0answers
473 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
143 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
1answer
547 views

Dates returned as #error in SRSS report from SharePoint list

I have connected an SRSS report (in SQL Reporting Services 2012) to a SharePoint 2013 list. Date fields all return #error, but other fields return data successfully. May query looks like this: <...
1
vote
0answers
575 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
937 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
298 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
1answer
629 views

Adding Report Viewer Web Part to Default page programmatically

I am new to Sharepoint. I need to know the best way to add a ReportViewWebPart to a page through C# code behind. I have tried accessing the web part from WebPartCatalog. It leads me to the ...
1
vote
0answers
373 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
47 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
264 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
1answer
151 views

SharePoint Reporting Services NLB Configuration Problems with Routing

I have a problem with Reporting Service Integration on my environment. We have 2 WFE's. Reporting services is configured on both. However, on the SharePoint Central Admin under reporting services ...
1
vote
1answer
146 views

SSRS Intermittant Exceptions

Someone assisted me this morning with one issue related to Reporting Services in SharePoint Integrated mode: SharePoint Reporting Services - NLB issue Now I seem to have another issue. The post ...
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
308 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
1answer
56 views

automate reporting, create a separate report for every instance in a report via the schedule manager

is it possible to create a separate report for every instance in a report via the schedule manager in sharepoint? If not what other way is there? Thanks for your help
1
vote
1answer
81 views

Is SSRS Required to use Report Builder 3.0

Do I need SQL Server Reporting Services configured to create reports against SharePoint 2010 Lists using Report Builder 3.0 ? I see that I can download an individual installer. Bismarck
1
vote
2answers
2k views

SSRS - Get LookupSet results on different cells

Sorry if I'm missing something obvious but I'm a newbie to SSRS (SQL Server 2012 R2) and SharePoint 2010. My boss wants some basic reports from our internal SP site (list data) and I'm doing some ...
1
vote
0answers
549 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
1answer
410 views

SharePoint2010 configured with Win, FBA and SSRS with Integrated,reports working fine but after enable the anonymous subsite reports are not working

Site Details SharePoint web application Enable Windows Authentication with NTLM Enable FBA(With appropriate setting) Reporting Services with Integrated Mode Reports configured with Trusted Account ...
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
1answer
2k 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
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
20 views

SSRS 2016 native mode fail to connect SharePoint list datasource

We are using SP2016 with SQL 2016 standard (13.0.5026.0 SQL Server 2016 Service Pack 2 (SP2)). SSRS feature is enabled in SQL server and service started. I am able to browse the SSRS portal with http:/...
0
votes
1answer
15 views

Install SSRS SP mode after SP2016 is setup not working

We are using SP2016 on-premise with SQL 2016 enterprise edition. After everything is setup we realize we also require SQL Reporting service enable on the farm. Hence, on our application server we ...
0
votes
1answer
20 views

Unable to View SSRS Report after Deployment

Apologies for the long post: I have a SharePoint 2013 server with Reporting Services 2014 installed in SharePoint Integrated mode, plus a document library with Reporting Services content types enabled....
0
votes
1answer
14 views

SSRS 2016 Report Builder connection to Sharepoint Online List

I was able to connect to my on prem SharePoint 2013 server list, but since we migrated to SharePoint online i no longer get it to connect. I am getting access is denied error. Account i am using has ...
0
votes
0answers
42 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
20 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
32 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
21 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
74 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
1answer
629 views

“Report Server Central Administration Feature” is missing in Central Administration Site collection features

I am using SharePoint Server 2016 and SQL Server 2016 SP1. I installed "Reporting Services - SharePoint" feature on the Application server(Custom Role) and "Reporting Services Add-in for SharePoint ...
0
votes
1answer
349 views

How to open SSRS report anonymously in sharepoint integrated mode?

We have deployed one ssrs report on sharepoint server. For accessing that report anonymously, we have configured anonymous access on reports document library. But the following error is showing on ...
0
votes
1answer
216 views

sharepoint 2013 and reporting add in 2016 no render correctly

I have a server with Sharepoint 2013 installed and I have installed reporting services - Sharepoint 2016 and the reporting services complement for SharePoint products, and successfully configured the ...
0
votes
1answer
88 views

How to create a report in SharePoint that would sort/group several entries in a list together

I am trying to create a printable report that takes several entries in a list and groups them together. My company is moving equipment that we have inventoried and we want to have a print out for each ...
0
votes
1answer
65 views

SSRS in SharePoint 2013

If I do not choose Reporting Services SharePoint Integrated Mode while installing SQL Server and also I didn't installed Reporting services Add-in for SharePoint and in future I need to have SSRS in ...
0
votes
1answer
394 views

Page viewer not displaying ssrs report as it

Scenario: I have created report inside ssrs and want to display the same into sharepoint. The page take URL Parameter hence we have created html page and add the URL into the iframe and then added the ...
0
votes
1answer
244 views

Join two lists in SSRS report

How can a report have 2 lists in SharePoint? I need to join 2 lists and report by SSRS or SSIS
0
votes
1answer
340 views

SSRS add in in sharepoint 2013

I am quite new to sharepoint. I want to use ssrs reports in sharepoint. I came to know by google that we need to install reporting services add in. My dev environment details are as follows. App ...
0
votes
1answer
87 views

problem with sharepoint ssrs reports in safari

hi we have sharepoint 2013 and sql server 2014 we use ssrs 2014 to show dashboards which get information from another sql server 2008 R2 we can see ashboards internally but over internet in iphone ...