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.

141 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
0
votes
1answer
153 views

SharePoint product configuration wizard was stuck since one day in one of app server where i installed reporting services as in share point mode

SharePoint product configuration wizard was stuck since one day in one of app server where i installed reporting services as in share point mode. i recently updated sharepoint farm with september ...
0
votes
1answer
274 views

How to write Query in SQL Reporting Services query designer to get current sharepoint Login user?

I Want to create a report using SQL Server Reporting Services. In Visual Studio I created a report to get SharePoint data from a list. I want to get the current logged in user in SharePoint and check ...
0
votes
0answers
168 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. ...
0
votes
1answer
604 views

SSRS bar-chart do not show the x-axis name when value is zero

We have a Dashboard implemented by SSRS in SharePoint 2010 and data source is a SharePoint list. We have a bar table in which the x-axis is month but when data is zero it doesn't show the month name ...
0
votes
3answers
64 views

Auto updating chart from a list in SharePoint 2010

I have a SharePoint list and I want to show it in a tabular table in home page of SharePoint and data be online in which by changing data in the list the data of the table change automatically. What ...
0
votes
0answers
286 views

SSRS report and performance point filter issue in sharepoint 2013

Deployed a dashboard in a sharepoint site this dashboard it has a Performance point filter which is get data from report database and it has a performance point report it is connected with a report ...
0
votes
0answers
2k views

PartialChain: A certificate chain could not be built to a trusted root authority error in performancepoint dashboard designer

when access PerformancePoint dashboard designer I got below error message in event viewer and unable to connect to SharePoint site collection. An operation failed because the following certificate ...
0
votes
1answer
184 views

Access Oracle View to Generate reports in SharePoint 2013

I have one view created in oracle database and I need to display some reports based on it on a SharePoint 2013 enterprise farm. I want to know which approach is preferable, should I create a BCS ...
0
votes
1answer
24 views

Deploying User Profile Application - My Sites

I need to use specific features available when deploying UPA. Hence I need to create a "my sites" site collection because I need to use the "Site feed" feature. I need to know if deploying the my ...
0
votes
1answer
743 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
1answer
609 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 ...
0
votes
1answer
465 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 ...
0
votes
0answers
83 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
103 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
1answer
712 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
1answer
651 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
28 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
2answers
649 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 ...
0
votes
0answers
120 views

Calculated column used in reporting services shows #Error

I am using the following formula in a calculated column to extract the month from the "ResolvedDate" column. =""&MONTH(ResolvedDate) It works well, but now I intend to use it in reporting ...
0
votes
1answer
83 views

Sharepoint - Customizing Reports

I've recently been given the task of customizing our reports on sharepoint. Being brand new to sharepoint, I'm kinda walking through the dark. I was wondering, is there a way to take the reports ...
0
votes
0answers
50 views

Report off SharePoint List

I have a SharePoint 2013 list. This is On Prem. The list has a notes section. I run a report daily that pulls certain fields from that list, including the note section. I am having a formatting ...
0
votes
1answer
328 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
1answer
525 views

SSRS integrated report refreshes after idle time

I’m experiencing an issue with a SSRS 2012 report integrated with SharePoint 2013 and it’s usage in Chrome and Firefox. The issue presents itself when the following conditions are met. 1. User ...
0
votes
1answer
129 views

What is the best practice to create some SSRS report to show info from a list, and show in a webpart in SP 2010?

I am using SP2010. I have a list with some important info. I would like to generate some report in SSRS. What is the best practice to create a SSRS report with the source from a SharePoint list? I ...
0
votes
1answer
45 views

Create a ReportingServices data source and upload to a data connection library

I have installed reporting services 2012 in SharePoint 2013 integrated mode. I need to create a report data source and upload it to a data connection library using C#. As I know it uses the ...
0
votes
0answers
1k views

How to get “SQL Server Analysis Services Filter” to work?

In an SharePoint 2013 BI Portal I am using two Report Services Report Web Parts with a common data source (.rsds file). Reports work fine and I want to filter the data of one report (or both reports ...
0
votes
0answers
7k views

SSRS SharePoint Integrated Mode: The status code returned from the server was: 12019

I am running SSRS in SharePoint Integrated Mode and just recently started receiving the following error message when viewing a long-running report: Sys.WebForms....
0
votes
1answer
207 views

How can I test an SSRS 2012 environment on production

I have a SharePoint 2010 site with SSRS 2008 running. I'd like to dabble with SSRS 2012 to check report compatibility, etc. Can anyone advise on how I can go about standing up an SSRS 2012 instance, ...
0
votes
0answers
978 views

sql server reporting services web url not getting resolved

I have installed "sql reporting services in sharepoing integrated mode" on my SharePoint dev server.I have set the service account for the reporting services to be my admin/farm account . The ...
0
votes
0answers
44 views

Customized User and Graphical Interface for reports's website

If I have about 80 reports from SSRS that need to be applied to different website at SharePoint's intranet. Let's say about 20 for a webpage, 50 for a another webpage and 10 reports in a another ...
0
votes
1answer
582 views

Connecting with SSRS using XML Data Source leads to 401 Unauthorized

I am currently working on Report Builder 2.0 with Reporting Services 2008 and am trying to connect to a SharePoint 2013 site using an XML data source query. SharePoint and Report Builder/Services are ...
0
votes
1answer
67 views

How is SSRS report Deployed to remote server in SharePoint 2010

How is SSRS report deployed in the remote production server where there will be no connection between prod/ staging & production server? you can only send some staff to prod server. What are the ...
0
votes
1answer
1k views

SSRS add 2 date time Fields

I have 2 datetime Fields in SSRS and I am summing both of them like: =TimeSpan.FromTicks(sum(Fields!Logout_Time.Value-Fields!Login_Time.Value)). The output is correct but is in hh:mm:ss format, I ...
0
votes
0answers
304 views

SharePoint 2010 multiple report viewer webparts - very slow

I have 7 report viewer webparts on one SharePoint page. It takes ages to load all of them, if I open the RDL directly, the report loads within 2 seconds. If I remove 6 web parts (thus, only 1 web part ...
0
votes
2answers
132 views

SP2010 and Report Builder

I have an SSRS report integrated with SP 2010, the data in the report is loaded from a SP list. The current issue that I am facing is not being able to read minimum and maximum date time field for the ...
0
votes
0answers
1k views

passing url query string parameters to SSRS Report in SharePoint 2007 integrated mode

Is there some trick to doing this? Most guides suggest I just add the parameter to the url address, but that does not see to work. Is this a SharePoint 2007 issue?
0
votes
0answers
762 views

Bind parameters to my custom reportviewerwebpart and refresh it

I'll try to explain my problem in the easiest way I can, since even for me it is difficult to understand. I've created a custom web part in which I have two columns: a datalist and a few buttons on ...
0
votes
0answers
405 views

Add ReportViewer WebPart at runtime

I am working with feature receivers in SP2010. I can successfully create web part pages and drop web part on the pages on feature activation.I was trying to add ReportViewerWeb Part (Integrated Mode) ...
0
votes
1answer
36 views

Show MS Excel sheet in SharePoint list

I have an Excel document where we track team projects' travel periods. Preview Info: Users are ordered in 1st column. Bellow is Projects coloring legend. Team members are on site like User1, 20.11....
-1
votes
1answer
122 views

Dynamically pass sharepoint list name in ssrs report

I want to pass Dynamic SharePoint list name. I want to give access to users to provide the parameter value in ssrs report for SharePoint list and get the data. So, to dynamically pass the data i am ...