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
10 views
Set SSRS Report Parameter Through JavaScript
I am running SSRS 2008 in SP2010. I want to set some report parameters through JavaScript. Is it possible if yes then how. Basically I read some values from the page itself and then set the report ...
1
vote
1answer
13 views
Is SSRS Required to use Report Builder 3.0
Do I need SQL Server Reporting Services configured to create reports against SharePoint 2010 Lists using Report Builder 3.0 ? I see that I can download an individual installer.
Bismarck
2
votes
0answers
14 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 ...
0
votes
1answer
15 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
0answers
15 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 ...
0
votes
1answer
59 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
22 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
18 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
132 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
47 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 ...
0
votes
0answers
24 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
21 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 ...
1
vote
1answer
86 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
50 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
18 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
57 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
1answer
74 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
0answers
18 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
28 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
2answers
183 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
41 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 ...
5
votes
1answer
81 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 ...
1
vote
1answer
49 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
39 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
2answers
102 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 ...
0
votes
0answers
78 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
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
25 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
67 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
37 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
0answers
65 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
0answers
67 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 ...
0
votes
1answer
171 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
65 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
186 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 ...
1
vote
1answer
167 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.
...
1
vote
4answers
853 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 ...
0
votes
0answers
73 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?
0
votes
0answers
81 views
Error on Sorting Sub Report SSRS 2008
I am working with SSRS 2008. I have one main report and a sub report( out of the main table). Both the reports are rendered correctly. But as soon as I sort any of the columns in my report (main or ...
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
1answer
44 views
Causes for really long page Request times?
We have a sharepoint portal running SSRS reports for our customers.
The reports themselves dont take that long to render, however the page requests take over 10-15 seconds which is simply ...
1
vote
1answer
98 views
SSRS SharePoint Integration on 2 Computer Deployment
I understand that on the computer running SSRS in SharePoint Integrated mode I must also have a minimal installation of SharePoint. The following from MSDN illustrates this:
My setup consists of a ...
1
vote
1answer
125 views
Service accounts for database connection
We have a SharePoint web application with multiple site collections under that. We have built a new site which will be hosted under the same web application but in a new site collection. It has some ...
0
votes
1answer
401 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
218 views
SharePoint 2010 and SSRS 2012 Setup and Licensing
I am trying to setup SSRS 2012 in Integrated Mode so that I can attach my SharePoint to it. The issue that I am having is that it seems like Microsoft removed integrated mode and switch to using ...
2
votes
1answer
345 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 ...
