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 ...
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 ...
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 ...
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 ...
2
votes
1answer
45 views
Moving reports from sharepoint 2007 to 2010
I currently have both a sharepoint 2007 farm and a sharepoint 2010 farm, both have an SSRS server.
I need to move the reports from SP 2007 to SP 2010 and I'm not sure how to do this easily.
1
vote
1answer
85 views
SharePoint2010 configured with Win, FBA and SSRS with Integrated,reports working fine but after enable the anonymous subsite reports are not working
Site Details
SharePoint web application
Enable Windows Authentication with NTLM
Enable FBA(With appropriate setting)
Reporting Services with Integrated Mode
Reports configured with Trusted Account
...
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
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
1answer
391 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 ...
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 ...
1
vote
0answers
66 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
32 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
256 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
47 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
150 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
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 ...
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
0answers
117 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
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
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 ...
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
0answers
17 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 ...
0
votes
0answers
33 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
77 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
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
64 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
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 ...
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
0answers
70 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
78 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 ...
0
votes
0answers
153 views
Adding new field to embedded data set SSRS 2008
I am working with SSRS 2008 (SharePoint Integrated mode) and SharePoint 2010. I want to add a field to my existing embedded data set in one of my reports. Field is already being returned from the ...
0
votes
0answers
268 views
passing url query string parameters to SSRS Report in SharePoint 2007 integrated mode
Is there some trick to doing this? Most guides suggest I just add the parameter to the url address, but that does not see to work. Is this a SharePoint 2007 issue?
0
votes
0answers
213 views
SharePoint and SRSS integration using SQL Server 2012
I am trying to integrate my SSRS database (SQL Server 2012) with SharePoint. I followed this site: http://msdn.microsoft.com/library/gg492276(SQL.110).aspx#bkmk_create_serrviceapplication
I go to ...
0
votes
0answers
312 views
Bind parameters to my custom reportviewerwebpart and refresh it
I'll try to explain my problem in the easiest way I can, since even for me it is difficult to understand.
I've created a custom web part in which I have two columns: a datalist and a few buttons on ...
0
votes
0answers
54 views
Basic breakdown for use of SQL Reporting Services
I would like to utilize SQL Reporting Services (SQL Server 2008 R2) to generate charts based on list information within my site collection. I am looking for a basic guide on how to configure an ...
0
votes
0answers
37 views
Problem on configure SSRS with SharePoint 2007
I came across of setting up SQL 2005 Reporting Services into SharePoint 2007,I had install the reporting service and SharePoint add in and now stuck in Reporting Service Configuration Manager.
The ...
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
65 views
Client facing Sharepoint site - avoiding User Controls for SSRS report input
I inherited a SharePoint (2007) website that my former co-worker was managing for our company. I only have limited experience with SharePoint.
A bit about how the system is designed as far as I ...
0
votes
0answers
61 views
DashBoard is not appearing in sharepoint 2010 for PPS
I configured a Performance Point Services in my application. Now I created a list based on the PerformancePointcontent list. List created fine. But when i click the add new item link in that list, it ...
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
156 views
Add ReportViewer WebPart at runtime
I am working with feature receivers in SP2010. I can successfully create web part pages and drop web part on the pages on feature activation.I was trying to add ReportViewerWeb Part (Integrated Mode) ...
