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
89 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
87 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 ...
1
vote
1answer
81 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 ...
0
votes
0answers
125 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
61 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
1answer
298 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
0answers
10 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 ...
3
votes
2answers
184 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 ...
2
votes
1answer
7k views

The permissions granted to user 'MYDOMAIN\ryanhayes' are insufficient for performing this operation. (rsAccessDenied)

I'm getting several users getting access denied for some SSRS reports that are in a reports directory in SharePoint 2010. I have a single sharepoint group with all users in it so all users have the ...
0
votes
2answers
195 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 ...
1
vote
0answers
19 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
1answer
145 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 ...
1
vote
0answers
53 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 ...
0
votes
1answer
137 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 ...
1
vote
1answer
48 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 ...
3
votes
1answer
937 views

Connect all SSRS Reports in SharePoint library to DataSource using Powershell

We are migrating MOSS to SP2010 and have a library with hundreds of SSRS reports that use a Shared DataSource (in SharePoint Integrated mode.) Since the ReportServer database location has also ...
2
votes
1answer
67 views

How to add SharePoint List as one of the data connection type in SSRS report?

I want to create a report with SSRS that consumes data from SharePoint list. When I add a new shared data source in the Business Intelligence Studio, all the options other than the SharePoint List are ...
0
votes
2answers
500 views

RS Web parts title doesn't change

After installing the RSwepart that come with SQL server 2008. I noticed that the webpart title doesn't change. After i have tried changing it from Report Explorer to something else. See them here: ...
1
vote
2answers
125 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 ...
0
votes
0answers
36 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 ...
1
vote
1answer
416 views

Cannot add ReportViewer Webpart via Powershell to Page

On my SharePoint 2010 I want to automate Website-Provisioning with customized homepage. The homepage should show some SSRS ReportViewerWebparts. I get error messages, I am very surprised of and cannot ...
2
votes
2answers
6k views

How to change Native Mode to SharePoint Integrated Mode in SQL Server 2012

I have installed SQL Server 2012 in Native Mode. How can I change it to SharePoint Integrated Mode? In the Reporting Service Configuration Manager Tool I found that there is no option to change Native ...
2
votes
2answers
1k views

SSRS ReportViewerWebPart Height Issue

I am working with a customized page that has an embedded ReportViewerWebPart inside of a content tag. In this case, it's inside of "PlaceHolderMain". It looks like this: <asp:Content ...
0
votes
1answer
44 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
2answers
33 views

Error while configuring Reporting Services Integration

I am trying to configure Reporting services with SharePoint via central admin -> General Setting -> Reporting Services Integration Error is as shown below. What is the problem?
0
votes
1answer
681 views

SharePoint error after adding SQL Server Reporting Services Report Viewer webpart

We created a new wiki page. Then, we add a new webpart to this page -> SQL Server Reporting Services Report Viewer webpart. Now the page gives error. What could be the problem?
0
votes
1answer
181 views

What is difference between SQL Report viewer webpart and showing the report via page viewer webpart?

We have not yet configured Reporting integration on our SharePoint site. Currently the way we show TFS reports are by adding the page viewer webpart to the SharePoint dashboard and then pointing this ...
1
vote
2answers
5k views

SharePoint 2013 SP1 Installation Issue- SSRS Content Type Missing for New SC

Recently I have Installed SharePoint SP1 (15.0.4571.1502) I have Create a New Web application and SC with BI Center Template. Activated the Report Server integration feature and deployed PowerPivot ...
0
votes
1answer
528 views

How to have Report Viewer Web Part for SP 2013 and SQL Reports 2008 R2

I am trying to display a SQL Reports 2008 R2 report in SharePoint 2013. I am confused because I can not find a web part for SharePoint 2013 that can display a SQL Server 2008 R2 Report. Am I ...
2
votes
1answer
159 views

Cannot create subscription in SSRS (2008) . Sharepoint 2010 as datasource(XML)

I created a report which displays sharepoint list in SSRS using XML as datasource. I can view the report but i cannot create subscription in SSRS. Here is the error Subscription cannot be created ...
0
votes
0answers
27 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 ...
1
vote
1answer
26 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 ...
0
votes
0answers
387 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
65 views

SSRS and Item-Level Permissions

Simple and straight question: Will users that access the SSRS reports I have connected to my SharePoint list inherit the permissions set for that list, including item-level permissions?
3
votes
1answer
185 views

What to do when SharePoint Lists and SSRS isn't enough?

I've developed a complicated InfoPath web form for reporting outages. This system will be maintained by someone with little technical skill, so in a lot of places the form populates its dropdowns from ...
0
votes
1answer
80 views

Reporting Services not working

I have DC 1, SQL1 and SP1 in a 3 tier virtual environment. In SP1 I installed Reporting Services - SharePoint Integrated and Reporting Services Add-in for SharePoint. Once the install was done I ...
0
votes
1answer
76 views

Item-level Security on SSRS report from SharePoint list

We have created an SSRS report from SharePoint 2010 list. We have item level permission in the source list, so the user can view only the items for which they have privilege. But in SSRS report it ...
1
vote
2answers
868 views

Reporting Services Error after doing a restore on a new farm and attempting to view a report

The SharePoint site with the id {GUID} could not be found. (rsSPSiteNotFound) The source farm reports work fine, but after the restore to a new farm, some (not all) reports get this error. Looked ...
3
votes
1answer
25k views

Generate report from sharepoint 2010 list

I need to generate a report from sharepoint 2010 list using any good and easy method. Any suggestions along with the procedure are welcome.
0
votes
1answer
484 views

Pass current user filter to ssrs hidden parameter

I have a SSRS report hosted in sharepoint (in Report Viwer Webpart).That report has a hidden parameter "username". I want to pass current user to that ssrs report. But when I tried to connect to ...
0
votes
0answers
116 views

Invalid URL Error when deploying rdl to SharePoint 2010

Has anyone come across the following error when trying to deploy a .rdl file onto SharePoint 2010? Report Server has encountered a SharePoint error. ---> Microsoft.ReportingServices.Diagnostics....
1
vote
1answer
22 views

Sharepoint reports showing up as xml

We recently installed PowerPivot into our SharePoint environment and it started causing issues with our reports(.rdl) which are now displaying as XML. Any ideas what might cause this?
1
vote
1answer
99 views

Is there a way to log specific clicks?

I need to log when users click on specific links on our SharePoint site. Something like: bob@company.com - Clicked Special Link #1 - 02/13/2015 14:41 joe@company.com - Clicked Special Link #7 ...
0
votes
2answers
1k views

Why are Reports returning a 504 Gateway error?

I've created some reports in BIDS and uploaded the .rdl and .rds files to a SharePoint Report Library. Attempting to access the reports leads to a 504 Gateway Time-out The server didn't respond in ...
1
vote
2answers
98 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. ...
0
votes
1answer
54 views

SharePoint 2013 and ReportingServices2010 CreateDataSource Example

Can anybody help me with how to use CreateDataSource with SharePoint 2013 to Create a Data Connection in C# code?
0
votes
1answer
36 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 ...
1
vote
1answer
816 views

SharePoint 2013 Manage Reporting Services Application crashing

I had integrated reporting services working nicely, then I changed something and when I go into Manage Reporting Services Application -> System Settings this happens: Sorry, something went wrong The ...
0
votes
1answer
91 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 ...