Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 549

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 reporting functionality. Administered via a web interface, it can be used to prepare and deliver a variety of interactive and printed reports.

0 votes

Connecting with SSRS using XML Data Source leads to 401 Unauthorized

Try going into the SSRS Config utility and set up an execution account, then grant that execution account read access to the site you're trying to get to.
James Love's user avatar
  • 25.5k
1 vote

Using SharePoint UserAccountDirectoryPath with SSRS

Do this in PowerShell: $w = Get-SPWebApplication http://yourwebapp $w.GrantAccessToProcessIdentity("DOMAIN\SSRSServiceAccount") That's it. Every time I've gotten a "RS has encountered a SharePoint …
James Love's user avatar
  • 25.5k
1 vote

Set SSRS Report Parameter Through JavaScript

Doing this via the Report Viewer Web Part might be quite tricky - as the way this web part sets the Report Parameter values is all done server-side. The closest you'd get to client side interactivenes …
James Love's user avatar
  • 25.5k
1 vote
Accepted

SharePoint, LINQ & Reporting Services Tools

Think you're going to want to create a Custom DataSource. This post on StackOverflow asks pretty much the same question as yours (though generalised to more than just SharePoint as a source), with so …
Community's user avatar
  • 1
0 votes

SSRS 2008 R2 Querystring parameters Sharepoint Integrated Mode

I'd highly recommend using only the RSReportViewer.aspx page located in the _layouts directory. Passing MDX Member Unique Names is fully supported. Use the Parameters Panel on RSReportViewer.aspx to a …
James Love's user avatar
  • 25.5k
2 votes
Accepted

SharePoint 2010 and SSRS 2012 Setup and Licensing

See the post history for my previous version of this answer, it's actually wrong. SSRS 2012 as a service application is the equivalent of the Add-In in 2010. You can probably install and license in e …
James Love's user avatar
  • 25.5k
1 vote

Deploying reports with enabled Forms Based Authentication (FBA)

There are quite a few situations where applications don't talk nicely to web apps with both authentication methods enabled, PerformancePoint Dashboard Designer being one of them - and I think Visual S …
James Love's user avatar
  • 25.5k
2 votes
Accepted

Can SSRS reports be integrated into the free version of SharePoint?

SSRS works fine in SharePoint Integrated Mode on WSS3, but you'll need to remember to install the Reporting Services Add In for the appropriate version of SQL Server you have installed.
James Love's user avatar
  • 25.5k
1 vote

Test drive of PerformancePoint and SSRS on SharePoint

PerformancePoint without any other data sources is very limited. If you have a SharePoint environment, find out if you can have access to an instance of SSAS on the SQL Server. You'll then be able to …
James Love's user avatar
  • 25.5k
1 vote

SP2010 Reporting Services 401 unauthorized for one web app but working for the others

Have you enabled the Report Server Integration site collection feature on site collections in that web app? Is this SSRS SQL Server 2012? Have you associated the Service Application with that Web App …
James Love's user avatar
  • 25.5k
1 vote

SSRS Managing parameters default value different behavior 2007 to 2010

Since this question was asked in January with no response since (it's now July), I might suggest patching SQL Server 2008 R2 to the latest cumulative update/service pack (as of writing, SQL Server 200 …
James Love's user avatar
  • 25.5k
1 vote

Report Toolbar in SharePoint 2010

This is probably most definitely something introduced with the SQL Server cumulative updates. However, just to be sure, can you check the version number of SharePoint you have installed? PPS' integra …
James Love's user avatar
  • 25.5k
1 vote
Accepted

Lightest possible SSRS Integrated Mode machine

I'd say a standard SharePoint Foundation installation. One WFE, and your SQL server that'll be running SSRS.
James Love's user avatar
  • 25.5k
2 votes
Accepted

Publishing Report PDFs Monthly - multiple permissions to view them

Needing to review and approve content is precisely one of SharePoint's core use-cases, so that requirement is definitely not an issue :) I would have the reports sent to separate Document Libraries, …
James Love's user avatar
  • 25.5k
0 votes

SharePoint 2010 and reporting services mutiple lists

You can add one data source per list for your report (ie: multiple data sources within your report), this Q on StackOverflow asked something similar I think: https://stackoverflow.com/questions/3531 …
Community's user avatar
  • 1

15 30 50 per page