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
127 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
207 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
167 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
182 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 ...
2
votes
0answers
140 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
38 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
112 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
85 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
120 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
55 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
241 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
183 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
539 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
167 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
180 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
147 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
83 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
108 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
213 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
319 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
212 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
76 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
685 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
211 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
17 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
0answers
15 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
14 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 ...
0
votes
0answers
14 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
12 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
11 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
15 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 ...
0
votes
0answers
9 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
8 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.
0
votes
0answers
11 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
16 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
32 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 ...
0
votes
0answers
24 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
36 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
23 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
28 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
19 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
13 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
17 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
11 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
56 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
83 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
48 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
41 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.