What is the best way to get reports to Sharepoint for the customer to run for the latest data? The reports are created in SSRS right now. I just want the customer to click a button for the static report to pull the latest data in a view that is easy for them, maybe a pdf. I know there is PerformancePoint and a publish in SSRS. How do I know which one to pick? Help please!
You can setup SSRS to run in Native SharePoint mode so you can deploy reports to SharePoint. SSRS already lets you export to PDF so if you just create a basic report that way they already have that option. In regards to pulling data, when you deploy the report and parts like data sources, keep in mind the different methods of authentication needed and what will work best for your environment. For instance, are you currently using Windows Authentication for reports and database access? If so, that's probably the way to go with data sources for reports. If you don't have that locked down already, you could embed credentials into report but there are security implications there you may want to consider.
We have a bunch of free webinars you can watch to help you decide which architecture you want to go with:
Zero to Dashboard with PerformancePoint - http://pragmaticworks.com/Resources/webinars/WebinarSummary.aspx?ResourceID=327
Using PerformancePoint and Reporting Services to create an interactive dashboard - http://pragmaticworks.com/Resources/webinars/WebinarSummary.aspx?ResourceID=206
Developing and Deploying PerformancePoint scorecards and dashboards - http://pragmaticworks.com/Resources/webinars/WebinarSummary.aspx?ResourceID=328
Intro to SSRS 2008 - http://pragmaticworks.com/Resources/webinars/WebinarSummary.aspx?ResourceID=59
I do watch a lot of your videos. Is your suggestion then not to go through PerformancePoint for what we need?
I am having problems just deploying from SSRS to Sharepoint. It asks for a logon and I try the sql server logon that I am remoted in to and I have tried my own personal id and password that has a lot of access.
Sorry, didn't mean to slant vids toward PP, just did quick search on upcoming webcasts. The problem you may be running into is a Kerberos issue. Are you SharePoint, SQL Server and Reporting Services servers separate? If so, you may want to read up on Kerberos and Reporting Services: http://blogs.msdn.com/b/prash/archive/2010/07/15/configuring-kerberos-authentication-for-ssrs-2008-r2-with-sharepoint-2010.aspx
Edit: Also look at the various deployment topologies: http://technet.microsoft.com/en-us/library/bb510781.aspx
From what I read about PerformancePoint, it is used for the customers to create their own reports. I have already created the reports that they want and just need the ability to put them on Sharepoint for the customer to refresh by clicking to open them. I don't want them to be able to change the details of the report at all. It seems that I want to use Reporting Services then. I cannot find a clear document to tell me how to do this though. There is a lot of information out there and it is very confusing. I will be watching a couple of your videos tomorrow and I hope they answer my question, but if not, please help. Thanks!
Ah ok, so you're only looking to deploy SSRS in SharePoint Integration mode. Check out these really thorough posts on it:
http://blog.datainspirations.com/2010/02/20/installing-reporting-services-2008-r2-in-sharepoint-integrated-mode/ (Read first)
Once its up, you should be able to deploy reports in the typical RS fashion. Let me know if this helps.
Ok, so we found out that our Report Server was not connected. It is up and running now.
Now, I am trying to deploy from Visual Studio and it wants a TargetReportFolder. Is this a folder that I need to create on the Sharepoint site or the Report Server?
I get the following error:
Error 1 The path of the item '/Scope Reports/Brand In Fee Scope List' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. 0 0