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 ...
2
votes
2answers
23 views
Where to Install Reporting Service
To use Reporting Service integrated with SharePoint, where to install Reporting Service?
Suppose that SharePoint env. has two physcical servers: application and database server.
Should reporting ...
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
86 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
3answers
144 views
Issue with SSRS and Sharepoint2010
I am adding a SQL Server Reporting Service Report Viewer Webpart onto a webpart page and i place a report generated using SSRS in the document library. I have two reports one with no parameter and one ...
0
votes
2answers
189 views
SharePoint 2010 Reporting Services Integrated Mode error on client
I am examine the different possibilities of SharePoint & Reporting Services Native Mode vs. Integrated Mode. So i set up an environment with both possibilities.
I have a SharePoint farm with ...
0
votes
1answer
77 views
SP2010 and Report Builder
I have an SSRS report integrated with SP 2010, the data in the report is loaded from a SP list. The current issue that I am facing is not being able to read minimum and maximum date time field for the ...
4
votes
2answers
436 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
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
0
votes
0answers
160 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 ...
1
vote
0answers
260 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 ...
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
1answer
208 views
Upgrade failed: SQL 2008 R2 SSRS (SharePoint Integrated) to SQL 2012
I upgraded a SharePoint-integrated SQL 2008 R2 SSRS server to SQL 2012 SSRS over the weekend. The installer said that the installation succeeded, but it appears that the SSRS database upgrade* may ...
1
vote
1answer
822 views
Programmatically set data source link for SSRS Report files
I have a scenario where I export/import a site collection with the Content Deployment Wizard. The problem is that all Reporting Services (SQL Server 2008 R2) reports (all located in the same document ...
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
315 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
55 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
1answer
153 views
Reporting Services Subscriptions doesn't fire Event Receivers
I have a SPItemEventReceiver on a SharePoint library which renames added files. Normally this works fine (Upload from website / WebDav).
There is also a report server subscription which drops pdf's ...
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
1answer
276 views
Sharepoint 2010 with existing SQL Reporting Services
going through my list for things I need to prep for in my upcoming Sharepoint 2010 installation.
We'll be installing SP2010 Enterprise to make use of the BI components, with the web server on it's ...
0
votes
2answers
62 views
What do I have to do prior to site creation of a “Report center” template?
I have a SSRS service installed, I have Sharepoint 2010 Enterprise Edition.
As I read on the internet, I should activate the Report Server Central Administration Feature in site settings > Manage ...
0
votes
1answer
31 views
Can SSRS reports be integrated into the free version of SharePoint?
Do I have to upgrade to another edition of SharePoint to integrate SSRS reports or is SharePoint integrated mode with SSRS available with the free version of SharePoint (Sharepoint Services 3)?
2
votes
1answer
82 views
SSRS 2008 and SharePoint integrated mode - security flaw?
Here is my scenario: I've got SSRS 2008 R2 running in integrated mode with SharePoint 2010.
Everything works as expected in that I can create data sources, models (either through studio or via the ...
1
vote
1answer
446 views
“Reporting Services” missing from SharePoint 3.0 Central Administration
Ok, I am getting into SharePoint development for my company and they have an existing installation of SharePoint that runs Reporting Services in "SharePoint integrated mode". Since I'm new to ...
0
votes
0answers
376 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 ...
3
votes
1answer
751 views
Connecting Web Parts across pages in SharePoint Designer
I am trying to connect some web parts across different pages (in the same site) and the behavior I am seeing doesn't make sense to me. I think I am missing something in my understanding.
I am using ...
0
votes
1answer
477 views
How to find invalid character in SharePoint item value
I try to create a dataset with Reporting Services from a SharePoint list (inside the root web).
When I want to build the query for the dataset I get the following error:
...
1
vote
1answer
190 views
Edit Manage Subscription Page
I have SharePoint 2010 with SSRS integrated. When I right click on a report and select Manage Subscriptions I am presented with a list of the current subscriptions. The columns are:
Type, Delivery ...
2
votes
1answer
2k views
Create reports from SharePoint lists
We currently have SharePoint 2010 Standard with SQL Server 2008 R2 Enterprise, and Visual Studio 2010 Ultimate for development. As I understand it, to be able to create reports from SharePoint lists I ...
0
votes
0answers
157 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) ...
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 ...
0
votes
1answer
90 views
Report Toolbar in SharePoint 2010
I have a SharePoint farm using SQL Server 2008 R2 and SharePoint 2010. In my production environment, my SSRS report within a Performance Point dashboard renders with the "old school" toolbar, which is ...
1
vote
1answer
219 views
SSRS reports not visible to all users in spite of permissions?
I have added a SSRS report to one of my department home pages and two things concern me:
It is very slow - almost a minute to render and any slicing takes a minute as well.
Reporting services ...
0
votes
1answer
114 views
RS Web parts title doesn't change
After installing the RSwepart that come with SQL server 2008.
I noticed that the webpart title doesn't change. After i have tried changing it from Report Explorer to something else.
See them here:
...
0
votes
1answer
1k views
Where are the Sharepoint Reporting Services webpart 2010
In SP 2007 there was a RS web part -(RS explorer and RS viewer webpart).
And all you need to do is just connect them.
But in SP 2010 i can't seem to find a anything similar.I can only see the ...
0
votes
1answer
369 views
SSRS Row Limit Only With Co-Located Data/Report
I've got a 2010 farm with reporting services running in integrated mode (trusted account). On that farm, I've got a report in a site collection that queries a list with more than 2000 items. When ...
1
vote
2answers
594 views
Installing SSRS on the Sharepoint Box as opposed to the SQL Box?
We currently have two SQl boxes (2008 R2) with multiple instances on them. One for test and the other for production databases.
We also have two sharepoint servers (2010 Enterprise). One in the DMZ ...
0
votes
2answers
53 views
Reporting Server Integration with Sharepoint Server 2010
I have a Sharepoint server 2010 Enterprise in a public domain and a SQL2008 standard in a local domain (with an installation of sharepoint 2010 to support report integration). Does Microsoft support ...
4
votes
1answer
1k views
Reporting Services, get data from any Sharepoint List
I am trying to build an SSRS (2008R2) report based on a Sharepoint (2010) List.
The main problem is that the List on which the report will run has to be a report parameter.I know what the list ...
0
votes
1answer
461 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
1answer
255 views
Why are Reports returning a 504 Gateway error?
I've created some reports in BIDS and uploaded the .rdl and .rds files to a SharePoint Report Library. Attempting to access the reports leads to a 504 Gateway Time-out The server didn't respond in ...
1
vote
1answer
206 views
ows_MetaInfo field including carriage returns
I have an InfoPath 2010 form promoting fields to SP 2010. Using SSRS 2008 R2, I'm pulling those fields into a report to report off of. I'm finding that some fields in the ows_MetaInfo blob have a ...
0
votes
2answers
1k views
Sharepoint output list of users
I would like to output the users of a group, for 40 groups, or for every group within the SharePoint Portal. I would like to do this programatically through powershell or a command line tool for the ...
1
vote
2answers
6k views
Tracking and reporting in sharepoint 2010 ? user accessing what kind of data ?
I want to track
How many times a particular user has accessed what document in document library?and i need to show this in a report format.
Also, i need to check what are links being accessed in the ...
0
votes
1answer
81 views
SharePoint 2007 integration Reporting Services 2005 having error!
Previously the reporting services in SharePoint 2007 are working fine. Suddenly it appear an error as below:-
The request failed with HTTP status 401: Unauthorized.
at
...
0
votes
1answer
251 views
SP2010 Reporting Services 401 unauthorized for one web app but working for the others
I have deployed Reporting Services to my farm. From the application server, reporting services are working for all web apps. However, via my WFEs, I have one web app which reports 401 Unauthorized, ...
1
vote
1answer
40 views
Not able to see reports in SharePoint site
I have a SharePoint site containing more than 100 reports.But i am not able to see few reports.When i browse the report it executes for 15 to 20 mins then it gives blank page with error at the bottom ...
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 ...
