Reporting Services 2008 : Customising Report Manager

Customising Report Manager in SQL Reporting Services 2008

Here's how to add your company logo to 'Report Manager'

1) Copy image file to >

c:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager\images\companylogo.jpg

2) Edit Style Sheet at

c:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\ReportingServices\ReportManager\Styles\ReportingServices.css

3) Find this code>

.msrs-uppertitle
{
font-family:Verdana;
font-size:x-small;
}

4) Change it to >

.msrs-uppertitle
{
font-family:Verdana;
font-size:x-small;
    BACKGROUND: url(http://ServerName/Reports/Images/CompanyLogo.JPG) no-repeat;
    HEIGHT: 42px;
    WIDTH: 155px;
    TEXT-INDENT: -5000px;
POSITION:absolute;
TOP: 15px;
RIGHT:330px;
}

Here's where I found out >
http://weblogs.asp.net/jgalloway/archive/2006/12/12/reporting-services-add-a-logo-to-the-report-manager.aspx

Reporting Services 2008 : Invalid Namespace

Got the following error, when trying to connect to my new Reporting Services 2008 build.

" No Report Servers were found.

Details : Invalid Namespace "

Fortunately, Justin King has already solved it for us, and has an really easy to follow guide to resolving this issue here >

http://www.kingjustin.com/post/2008/08/Reporting-Services-2008-Invalid-Namespace.aspx

( Thank you, Justin ! )

Reporting Services : Installing 32bit version on a 64bit server

SQL 2005's 'System Configuration Check' reported a version clash on my Windows 2008 box when trying to install Reporting Services.
" 64-bit ASP .Net is Registered. Required 32-bit ASP .Net to install Microsoft Reporting Service 2005 (32.bit). "
Sounds a bit backwards to me!
I needed to revert to 32-bit .NET on 64-bit IIS 7.0 (which is basically done by changing which DLL IIS is using)
Here's what to do...

1) from a command prompt >

C:\>cd C:\inetpub\AdminScripts

C:\inetpub\AdminScripts>cscript adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 Microsoft (R) Windows Script Host Version 5.7 Copyright (C) Microsoft Corporation. All rights reserved. Enable32bitAppOnWin64 : (BOOLEAN) True


2) Install Reporting Services (and SP2, and hotfixes... yawn...)

3) Configure Reporting Services (subject of another post, i'm sure...)


see also http://technet.microsoft.com/en-us/library/ms143293.aspx

Reporting Services : Installing IIS on Windows 2008

Installing Internet Information Services (IIS) on Windows 2008

This is a pre-requisite for Reporting Services >

1) Launch 'Server Manager'
2) Expand 'Roles'
3) Click 'Add Role' (over there on the right...)
4) Add ' Web Server(IIS) ' Role

When install is done >

5) Expand 'Roles'
6) Select 'Web Server (IIS) (right hand pane will change)
7) Scroll down to 'Role Services' in the pane on the right.
8) Click 'Add Role Services' and add the following roles >

> Web management tools
> IIS 6 Management Compatibility
> IIS 6 WMI Compatibility
> IIS Metabase and IIS 6 configuration compatibility

> World Wide Web Services
> Application Development Features
> ASP.NET
> ISAPI Extensions
> ISAPI Filters

> Common Http Features
> Default Document
> Directory Browsing
> HTTP Redirection
> Static Content

> Security
> Windows Authentication