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)

2
votes
0answers
123 views

Issue with SSRS Loading Report from Definition From Assembly

I am using SharePoint 2010. I created web-part where there is report viewer control. On the page load of the control. I am writing below codes to load report from definition. Web part is not giving ...
2
votes
0answers
202 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. ---> ...
2
votes
0answers
161 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
132 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
29 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
0answers
106 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
71 views

Sharepoint and SSRS query issue

I am using SSRS 2008 R2 with Sharepoint 2010 list and I have two reports from same SharePoint list. They return the same thing, only diffrence is the filtering part. How can we check in a CAML query ...
1
vote
0answers
111 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 ...
1
vote
0answers
51 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
224 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
175 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
518 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
161 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
154 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
38 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
139 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
80 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
103 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
205 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
175 views

SSRS reports deployment in production server

We have 50 SSRS report created in SharePoint 2010 integrated mode. Now we want to move these 50 SSRS reports to production server. Do we need to create script for this deployment (of report in ...
1
vote
0answers
304 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
204 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
75 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
646 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
79 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 ...
1
vote
0answers
210 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 ...
0
votes
0answers
20 views

Displaying all versions of a field in a list on a report

I use SharePoint 2010 and SQL Report Builder 3.0. I am creating a new report whereby I want to display all the versions of a data field on the report. One of the fields I need to report on is called ...
0
votes
0answers
21 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 dataset. I want to use one field in my data set (line type) to determine the value of ...
0
votes
0answers
9 views

SSRS Integration and SharePoint 2013?

I have a new SharePoint 2013 farm that is running on a SQL 2012. I have SSRS libraries working in SharePoint but we also have seperate SSRS servers (some SQL 2008 R2 and some SQL 2012). We want to ...
0
votes
0answers
19 views

Dropdown parameter of ssrs report in sharepoint webpart got hang when clicked

I am creating a web part which will have a SQL server report integrated into it. i have 6 parameter in the parameter box. one of the parameter have drop down in it. when i click on the drop down for ...
0
votes
0answers
15 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
0answers
10 views

SSRS 2014 wITH SharePoint 2013 foundation

I am a SAP BI consultant and have been more than itching to get on MSBI bandwagon. I have had a major roadblock in the form of SharePoint. I have SQL Server 2014 installed on my laptop which is 16GB ...
0
votes
0answers
12 views

Use [Me] As Parameter In SSRS Report Builder 3.0 Report

How can I roll up tasks using the SharePoint equivalent of [Me] as a parameter in a Report Builder 3.0 report?
0
votes
0answers
10 views

Fetch User Access permissons from SharePoint reports(.rdls)

I have a sharepoint site where DWH reports are hosted. I wanted to create a report which provides me the list of existing users having the access on each .rdl. Is there any PowerShell script or Sql ...
0
votes
0answers
37 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 ...
0
votes
0answers
60 views

HTTP 403 Forbidden on accessing layouts pages from a SharePoint 2013 app web

I have added the report content types (that comes with reporting services) to a document library in an app web. But when creating an new report by the ribbon > New document I get a 403 Forbidden ...
0
votes
0answers
30 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
0answers
27 views

rsItemNotFound, while adding XXX.rsds

I'm getting rsItemNotFound Error while creating Report Data Source in SP2010, Report Services is activated. Any help on this.
0
votes
0answers
31 views

Connecting using SSRS Report SharePoint list datasource - Windows Integrated Security doesn't work

I have a report I'm building using SSRS and a SharePoint List as datasource. The report works ok only if I login with my credentials before viewing the report. My credentials do not pass automatically ...
0
votes
0answers
34 views

Reporting Service Integration mode and Key not valid for use in specified state

I had to uninstall SharePoint Foundation 2013 and reinstall it. What I have done: I uninstalled SharePoint and after that I removed all databases. I reinstalled SharePoint Foundation 2013 and it ...
0
votes
0answers
14 views

SSRS 3.0 Reporting on Folder Inside List

How can I create a report that uses a specific folder inside a SharePoint 2013 list as a Data Set?
0
votes
0answers
47 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. ---> ...
0
votes
0answers
32 views

Ad-Hoc Reports in SSRS Sharepoint 2013

Is it possible to generate models in SSRS from SharePoint Lists? When trying to create Models, through Report Builder Model as SharePoint List as datasource, following error is displayed. Data ...
0
votes
0answers
21 views

How can I display remote SSRS reports

We have a new installation of SharePoint 2013 on-premis using SQL Server 2012 R2 database. We have not installed or setup SSRS in this SharePoint environment, and we hope to not have to. This ...
0
votes
0answers
9 views

Query to get name of document, which modified in given time line

I am creating the SSRS reports in Visual Studio 2008 using SharePoint 2010 list as Data source. Structure of list is: When users select the region and timeframe, it should go the associated ...
0
votes
0answers
47 views

Printing Report Crashes IE - SP Integrated SSRS / SP2010

Scenario: A SharePoint 2010 Site dedicated to SSRS Reports When a user navigates to a report and clicks on the report name, the report opens fine When a user selects the "Print" option from the ...
0
votes
0answers
66 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, ...
0
votes
0answers
81 views

Generate automatically SSRS reports via SharePoint Workflow

I have developed SSRS reports (.rdl) and I want when a user subscribes to a report, this one will be generated by a workflow periodically, how can i do that on SharePoint 2010 ?
0
votes
0answers
38 views

SSRS Web Part Page - HTTP 400 Bad Request

I have several pages that have a single instance of an SSRS ReportViewer web part. Switching between pages or simply refreshing the page adds a new Reserved.ReportViewerWebPart.axd request cookie. ...
0
votes
0answers
37 views

CAML query reporting services, date field

I am using reporting service to query (with CAML) a list on SharePoint. The list has an external content type, my problem is that just the Date field is not rendered fine. This is my result: ...