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 ...
0
votes
1answer
11 views
InfoPath 2013 to replace formated SSRS reports of Single SharePoint List items?
New to Infopath.
Can we natually and easily use Infopath 2013 to do the following with SharePoint:
Format SharePoint List Data on a sharePoint WebPart web page for a single SP List item (determined ...
0
votes
1answer
388 views
Ordering Stacked Column Chart Series SSRS 2008
I am working with SQL Server Reporting 2008. I have a stacked column chart.There are around 8-10 series stacked on each other. I want my series to come in a defined order from Top to bottom. I have ...
2
votes
1answer
342 views
Adding Report Viewer Control on Custom Web Part ASCX Control
I am trying to use Report Viewer control in one of my custom web part (on ascx) of SP 2010. As I drop the report viewer control on my ascx it register its assembly on top with assembly version ...
0
votes
0answers
14 views
SP2013 SSRS, Tabular and OLAP Install
I've been reading the install guides for analysis services for sharepoint 2013, but I do not see any mention of the different types of analysis services installs. Do I just repeat the install process ...
3
votes
1answer
318 views
SSRS Managing parameters default value different behavior 2007 to 2010
Issue: After uploading a SSRS 2008 R2 RDL to SharePoint 2010, a listing of possible values of a query based parameter is not populated into a dropdown list next to the “use this value” radio button ...
0
votes
1answer
51 views
SSRS Parameters passed through URL not refreshed on Web Part Page
My working environment is SSRS 2008 and SharePoint 2010.I have a report with parameters running in SP 2010. I call my report page in SP 2010 from a page with all the parameters in query string. On the ...
0
votes
0answers
20 views
Deploying SSRS report from BIDS to SharePoint 2010
I am having an issue deploying a report from BIDS to a SharePoint Integrated Report Services Server. I have set up SSRS and everything is successful from the configuration wizard, I am using a Domain ...
0
votes
0answers
15 views
Is it possible to use Powerview with SharePoint 2010 SP1 on SQL Server 2008 R2
I have a SharePoint 2010 SP1 environment configured over SQL Server2008 R2.
I have an Analysis Server running on a separate physical server which is also SQL 2k8 R2. I want to create a powerview ...
0
votes
1answer
12 views
SharePoint 2010: How to determine in what mode SQL Server Reporting Services is installed
SharePoint 2010 Standard farm.
How can I determine in what mode the SQL Server Reporting Services is installed?
When installing SQL Server Reporting Services (SSRS), you must choose the mode in ...
0
votes
0answers
114 views
SQL Server Reporting Services: The remote server returned an error: (500) Internal Server Error
I'm running a SharePoint 2010 Standard farm. I have 2 Web Front-end Servers, an application server running SSRS and 2 Database servers.
SSRS is installed using the Microsoft SQL Server 2012 RS Add-In ...
0
votes
0answers
249 views
SharePoint 2010 configured for Windows and Forms Based Authentication issue with SQL Report Builder
I have a report library in a SharePoint 2010 (SP1) site configured for both Windows and Forms Based Authentication. SQL Report Services 2008 R2 is configured on the same machine using SharePoint ...
0
votes
0answers
373 views
Error: Report item expressions can only refer to fields within the current dataset scope, System_State, TFS 2010 WSS 3.0 Report Builder 2008 R2
When I add comments to the Burnrate and Burndown reports in Report Builder to the query (dsVelocity or dsBurndown) I get:
Error: The Field expression for the dataset 'dsVelocity' refers to the field ...
0
votes
0answers
45 views
Convert Local Time (SSRS datetime parameter) to UTC Time
I am working with SSRS 2008 and SP 2010. My report has 2 parameters 1. TimeZone this parameter is read from SharePoint site (timezone of the site as per regional settings) the other is simple datetime ...
1
vote
1answer
85 views
SharePoint 2007 List as Datasource for SSRS 2005 - Query invalid and formating SharePoint Dates?
I have this XML query that pulls all entries and fields from a SharePoint list.
<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
...
0
votes
0answers
22 views
SSRS add 2 date time Fields
I have 2 datetime Fields in SSRS and iam summing both of them like : =TimeSpan.FromTicks(sum(Fields!Logout_Time.Value-Fields!Login_Time.Value)). the out is correct but is in hh:mm:ss format, i need ...
0
votes
0answers
20 views
SSRS Dataset valid, but data does not show up in generated reports
I have created a Sql Reporting Services Report from a SharePoint list. I am creating this report in Microsoft SQL Server Report Builder.
When I hit "run query" on my dataset in the query designer, I ...
5
votes
0answers
72 views
Using SharePoint UserAccountDirectoryPath with SSRS
I've got a SharePoint 2010 Enterprise multi-tenant setup integrated with a new SSRS 2008 R2 instance in SharePoint-Integrated mode and have FINALLY managed to get everything working. However, there ...
0
votes
0answers
49 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
0answers
17 views
PerformancePoint data source from Oracle
I have a requirement to create KPI and dashboard for which all data comes from Oracle. I am looking for getting this data into PerformancePoint to create KPIs..
Can anybody point me to the right ...
0
votes
1answer
53 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
2answers
100 views
SSRS 2008 R2 Querystring parameters Sharepoint Integrated Mode
I’m trying to run a report via the following url:
http://portal/dashboards/hr/reports/_vti_bin/ReportServer?http://portal/dashboards/hr/reports/reports/Test.rdl
However, I get a 401 Unauthorised ...
1
vote
1answer
166 views
Calling Reporting Services API from SharePoint 2013 application page
While upgrading from SharePoint 2010 to 2013 I am facing the following problem.
I have an application page, from which an SSRS API call is made to get all subscriptions for a report.
...
0
votes
1answer
70 views
Join multiple lists using XML web service
Implement a new XML web service, in the web service, use the
SharePoint API to merge or join two or more list. Then, in SSRS,
retrieve data from the XML web service using XML data source type.
...
0
votes
2answers
164 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 ...
0
votes
0answers
16 views
Usage statistics of the times sharepoint documents downlaoded viewed from an SSRS report hosted on sharepoint server
I have an SSRS report which displays data retrieved from a SharePoint Library. What is the best way to collect usage information about that SSRS report? specifically, which documents have been ...
0
votes
0answers
26 views
How to automatically generate the URL for the “URL Access” of SSRS Reports in a Report Library?
This is my setup:
I've a few reports developed using Business Intelligence Development Studio & deployed on Reporting Services in SharePoint Integrated mode.
The RDL files are deployed to a ...
0
votes
0answers
40 views
Native SSRS reports inside SPO 2013 with claims-based authentication
We have 1000s of SSRS 2005 reports in native SSRS mode and about 300 hosted inside SharePoint 2007 in SP integrated mode.
As we consider moving to SPO 2013 (o365) SSRS is not offered with SPO, and ...
1
vote
1answer
47 views
SharePoint, LINQ & Reporting Services Tools
I'm new to SP and SSRS, so I want to check if my thoughts are correct.
Report Builder and BIDS suck on data retrieval so I have to go deeper using code.
Is it possible to write some code in C# using ...
0
votes
0answers
32 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
0answers
13 views
Report Subscriptions and YOU!
We're using SQL 2008 R2 in SharePoint Integration Mode to provide reporting functionality for our end users. I have a task to create subscriptions for all my end users to these reports, however I ...
0
votes
0answers
75 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 ...
0
votes
0answers
24 views
Problem in Invoking SQL Server Reporting Services by SharePoint Timer Job
I'm facing some problem with the Render of some Reports during my SharePoint Timer Job. The same code running in a Console Application works correctly but in SharePoint Timer job stops working without ...
0
votes
0answers
63 views
SSRS report viewer webpart defalut zoom
I have few reports in SharePoint and I am using the Report Viewer web part to the display the reports. I want to set the default zoom of the report to 75% in the web part. I know we can use the ...
0
votes
0answers
10 views
Limiting Report Subscription Options
We are using SharePoint Enterprise 2010 to provide reporting functionality for our sales team, using SSRS RDL files. The report's themselves work just fine, but we are going to train our sales team ...
0
votes
0answers
36 views
Sharepoint Snapshot/Subscription Issue
On a production environment we are deploying to, we are getting the following error when trying to execute a Subscription on a ssrs report by taking a Snapshot:
Failed to validate the delivery ...
0
votes
1answer
451 views
Reporting Services Error after Content database restoration
I have migrated two web application content databases to from one SharePoint 2010 farm to another.
Reporting services seems to work fine on one of the web application.
http://webapp1/sites/intranet
...
0
votes
0answers
61 views
SharePoint SSRS SubRepots and CAML Query
I have a SSRS report where first I get some values from SPList1 and store in a Parameter that accepts multiple values, then I pass these values from my mail report to a subreport (subreport is from ...
1
vote
1answer
3k 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 ...
4
votes
2answers
425 views
Missing SSRS Web Services Directory
So the SQL Reporting Services Service Application is running, but from Central Administration, when I click on the service, then click "System Settings", it returns an error.
Digging through ...
1
vote
0answers
65 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
1answer
280 views
Deploying reports with enabled Forms Based Authentication (FBA)
Configuration:
Sharepoint 2010
Reporting Services Integrated Mode
Claims Authentication with Windows Authentication (NTML) and Forms Based Authentication Enabled
I can deploy reports from Visual ...
0
votes
1answer
162 views
How to scale out Reporting Services on SharePoint Integrated Mode over NLB
I have a SharePoint 2010 Enterprise farm with the following topology :-
2 WFE SERVER (behind NLB 1)
1 APP SERVER (used for Search)
1 APP SERVER (used for other service applications)
1 DB Cluster ...
0
votes
0answers
20 views
Share SSRS Server across two farms? Only ever using one at a time
We have two farms, one DR and LIVE. In Live we have an SSRS box, and in DR we have an SSRS box. In a scenario where the live farm dies then obviously the second farm picks it up, however in the ...
0
votes
0answers
42 views
SSRS 2012 SharePoint Mode Subscriptions Permissions
We have set up SSRS 2012 in SharePoint mode. The vast majority of our users only have read access to the reports, which works as expected. However they are unable to create subscriptions for the ...
0
votes
0answers
64 views
SSRS SP Integrated Using Trusted Authentication Mode but Data Souce Using Windows Integrated
I configured our Reporting Service Integration in Central Admin to use the Trusted authentication mode. From what I understand, this mode allows a data source to run using stored credentials. I also ...
0
votes
1answer
178 views
Creating SSRS report in SharePoint 2010 with multiple SPLists
I have SP Lists
Students: StudentID, Name, Address,Email
Course: CourseID, Name, Duration, Fees
StudentCourse: StudentID, CourseID
How can I query these lists and create a SSRS report displaying ...
0
votes
6answers
340 views
Test drive of PerformancePoint and SSRS on SharePoint
I need to build advanced reports on SharePoint, where radars, pivots and cumulative values are involved. One obvious option is Excel Services, but I'd be interested to compare it with PerformancePoint ...
1
vote
4answers
788 views
SharePoint 2013 Standalone VM for Development good enough?
I'm building a VM for SP 2013 development. Will be developing Solutions, WebParts, Custom forms, Dataviews, Business Data Connectivity, Custom Fields, inline Jquery, SSRS reports for deployment into ...
3
votes
1answer
143 views
Why are web part connections in a template breaking?
We have a SharePoint site that we created based on a blank site template.
We add lists, pages, webparts (including some connected web parts) and then save this site as a template (.wsp file).
We ...
0
votes
0answers
69 views
How can I schedule recurring email in sharepoint 2013
I have set of Power View reports and Excel reports on Sharepoint 2013. Is it possible to schedule email to send snapshot of Power View and Excel reports daily to a set of users?
