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
1answer
28 views

Completely remove field from Content Type?

I recently tried to delete a Multi-line Text Field from a custom Content Type. I then attempted to delete this field, and re-create it as a Single line of text under the same field name. After ...
0
votes
1answer
1k 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 ...
0
votes
1answer
19 views

Should SSRS (Sharepoint mode) be installed on WFE or Application server?

Should SSRS (Sharepoint mode) be installed on WFE or Application server? I want to install SSRS on a sharepoint farm having 3 App server 3 Web front end servers 2 SQL servers
0
votes
0answers
14 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
12 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
52 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 ...
2
votes
1answer
25 views

Sharepoint reporting on permission

I wanted to get a report of all the user in SharePoint and know what each user has permission. I am trying to track down each user permission level for every site they have so I can identify if they ...
0
votes
0answers
16 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
23 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
0answers
75 views

Report Viewer web part connected parameters not visible

I have a SSRS report with two visible parameters, Location and department. I have hosted it in a sharepoint page using Report view web part. When I connect "Location" parameter of my report viewer web ...
3
votes
1answer
1k views

Is it possible to view/edit SSRS datasets from sharepoint?

I have a bunch of 'shared datasets' on my old report server and I want to copy them to a Sharepoint document library. I'm running SSRS integrated mode in Sharepoint 2013 and I've already created my ...
0
votes
1answer
12 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
132 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
4 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 ...
1
vote
2answers
38 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
6k 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
34 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
12 views

How to show report from 10 related large list in SharePoint 2013 online?

Since SSRS report is not available in SharePoint 2013 online, how can we show complex report combining data from few very large size and related lists? in case of on-prem we had used SSRS in similar ...
1
vote
2answers
4k views

Report Viewer Web Part Alternatives in SP2013

We have a need to upgrade from SP2010+PWA to SP2013+PWA. Our database server will be SQL Server 2008 R2. According to Technet, the SQL 2008 R2 Reporting Services add-in for SharePoint isn't ...
1
vote
0answers
7 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
41 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
16 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
36 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 ...
0
votes
0answers
29 views

RDL reports do not work in Mobile Devices in SharePoint 2013

RSViewerPage.aspx does not show all RDL reports in mobile devices.(IOS, Android) I have On-Premises SharePoint Farm application. It means I can change RSViewerPage.aspx if there is any need. Is ...
0
votes
1answer
195 views

SharePoint 2013 Workflow Reports

I created a workflow in SharePoint 2013 and would like to start collecting information on how long it takes for each task to be completed. I know of ways to build this type of data into the workflow, ...
1
vote
1answer
24 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
720 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
48 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
0answers
30 views

Issue where-in User is asked to login to the sharepoint site twice (with the same credentials)

We have set up some dashboards through Team Foundation Server, using the Team Foundation Project Portal (sharepoint site) feature. For the dashboards and various charts/reports required, we have used ...
0
votes
2answers
369 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: ...
0
votes
0answers
29 views

ReportViewer toolbar buttons are disabled

I've integrated ReportViewer 9 on a SharePoint 2013. The SSRS is configured in Native Mode. I can see the report with IE 11 but all buttons of the toolbar (next page, prev page, print etc) are visible ...
0
votes
0answers
16 views

Report with all links on a site

Working in SharePoint 2013. The issue at hand is that I would like to have a list of all the links within a site collection. In SharePoint 2010 there use to be a way you can obtain a report within ...
1
vote
2answers
61 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
16 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
0answers
14 views

Share point reporting services not working?

I have installed sql server 2012 sp2 and deployed rdl files into ReportingServer, and trying to hosting in the sharepoint 2013 foundation server . I have installed SP2. I am keeping data base for ...
0
votes
0answers
14 views

install reporting services on sharepoint 2013 stand alone

Is reporting services install on sharepoint 2013 stand alone? I install sql server feature and add-in Microsoft sharepint, when I complete create service I give an error: The database engine ...
0
votes
0answers
32 views

Manipulate Report Viewer Webpart Parameters via PowerShell on a SharePoint 2010 WebpartPage?

I want to set the parameters of a SSRS report which is displayed through the ReportViewerWebPart by PowerShell, all on SharePoint 2010 WebpartPage. Right now, I'm confused by the documentation of the ...
1
vote
1answer
127 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 ...
0
votes
0answers
53 views

Multiple Column Lookup in SSRS expressions

Hi I am working in SSRS 2012. My dataset/table schema is as below. ID,Name,Age,Address In my report table this data set is the source. What I want to do is I want to filter my data set in ...
0
votes
0answers
13 views

Sharepoint Workflow Email Report

Any idea how I can generate and email a SSRS report in sharepoint workflow. I have SSRS in sharepoint integration mode. Thanks.
2
votes
2answers
5k 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 ...
0
votes
0answers
18 views

SSRS breadCrumbs SharePoint 2010 Problem

I have SSRS Library in that I have one folder called UATReports and in that I have test.rdl SSRS report.When I try to open that test.rdl file I need to view breadCrumbs like below For read access ...
0
votes
0answers
14 views

Mutiple rows and columns SSRS report

I am working with SQL Server Reporting Services 2012 and have a requirement to design a report as shown below. But I am not sure in which control this kind of report will fit in.(Tablix/Matrix/List) ...
0
votes
0answers
55 views

Calculated field in SSRS dataset

I'm making an SSRS report using a SharePoint list as a data source and I want to create a calculated field in my data set. I want to use one field in my data set line type to determine the value of ...
0
votes
0answers
62 views

“Add Data Driven Subscription” missing in SSRS sharepoint mode

I'm using sharepoint 2013 with SQL server 2012 Enterprise Edition SP2. I am using SSRS in sharepoint integrated mode. When I hover over report options I see the "Manage Subscriptions" option and when ...
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
21 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
29 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
135 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
63 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 ...