On multiple computer SSRS deployment, Kerberos authentication
is needed. If Kerberos hasn’t been set up in the environment, trusted account
will work as an alternative. Trusted account settings can be added through central
admin, “General Application Settings” à
“Report Services Integration”.
On report service site, the IIS manager site requires to set
anonymous authentication to be disabled. If not, this may cause lots of issues;
one of those issues is that it won’t let you to deploy reports from your BIDS
to the SharePoint site. The most common
issue is the sharepoint site keep on popping up login windows. (http://technet.microsoft.com/en-us/library/bb326290.aspx
)
To verify Report Server and SharePoint integration, type in
browser window http://server_sitename/reportserver,
where server_sitename is the report server name.
RSReportServer.config file location: for non Kerberos, the
config needs to have RSWindowNTLM.
C:\Program
Files\Microsoft SQL Server\MSRS10.<InstanceName>\Reporting
Services\ReportManager
Once Integration has been
set up, you can create report from SharePoint document library by using report
builder.
Understanding Groups (Report Builder and
SSRS) http://technet.microsoft.com/en-us/library/dd255263.aspx
Other References (Please Select the appropriate version from the "Other Version" option)
SQL server 2008 r2 sp2: http://www.microsoft.com/en-us/download/details.aspx?id=30437
SQL Server 2008 r2 sp2 CU4: http://support.microsoft.com/kb/2777358/en-us
Microsoft® SQL Server® 2008 R2 Service Pack 1 http://www.microsoft.com/en-us/download/details.aspx?id=26727
Microsoft® SQL Server® 2008 R2 Service Pack 2 http://www.microsoft.com/en-us/download/details.aspx?id=30437
Reporting Services Execution log & Log Files:
Report Server Execution Log and the ExecutionLog3 view http://msdn.microsoft.com/en-us/library/ms159110(v=sql.105).aspx
Reporting Services Log Files http://msdn.microsoft.com/en-us/library/ms157403(v=sql.105).aspx
Reporting Services Report Design Best Practices:
Reporting: Best Practices http://msdn.microsoft.com/en-us/library/windows/desktop/bb226815(v=vs.85).aspx
Report Design: Best Practices and Guidelines http://msdn.microsoft.com/en-us/library/cc966445.aspx
Report Design Tips and Tricks http://msdn.microsoft.com/en-us/library/bb395166(v=sql.90).aspx
Reporting Services Recipes Book Released http://blogs.msdn.com/b/robertbruckner/archive/2010/03/21/reporting-services-recipes-book-released.aspx | http://blogs.msdn.com/b/robertbruckner/archive/2010/04/11/reporting-services-recipes-book-downloads.aspx
Deciding Whether to Use an Expression or a Variable in SSRS http://sqlserverpedia.com/blog/sql-server-bloggers/deciding-whether-to-use-an-expression-or-a-variable-in-ssrs/
Global variables in embedded code Reporting Services 2008 deployment http://social.msdn.microsoft.com/Forums/en-NZ/sqlreportingservices/thread/17b25a5a-e7d2-4813-8afc-6fb002357542
