Reporting Service look and feel

Hi,
Can the pages that are shown by SQL Server 2005 reporting services be
customised. The pages that are shown are rather "techy" looking. I want to
change some of what is on there for my users' requirements and also be able
to badge with corporate colours, logos, etc.
Thanks
DavidI just wrote about some options here:
http://weblogs.asp.net/jgalloway/archive/2006/12/12/reporting-services-add-a-logo-to-the-report-manager.aspx
David Hyde wrote:
> Hi,
> Can the pages that are shown by SQL Server 2005 reporting services be
> customised. The pages that are shown are rather "techy" looking. I want to
> change some of what is on there for my users' requirements and also be able
> to badge with corporate colours, logos, etc.
> Thanks
> David|||Hmmm, not straight forward then. MS missed that one.
Thanks very much.
<jongalloway@.gmail.com> wrote in message
news:1165970930.225111.181230@.f1g2000cwa.googlegroups.com...
>I just wrote about some options here:
> http://weblogs.asp.net/jgalloway/archive/2006/12/12/reporting-services-add-a-logo-to-the-report-manager.aspx
> David Hyde wrote:
>> Hi,
>> Can the pages that are shown by SQL Server 2005 reporting services be
>> customised. The pages that are shown are rather "techy" looking. I want
>> to
>> change some of what is on there for my users' requirements and also be
>> able
>> to badge with corporate colours, logos, etc.
>> Thanks
>> David
>|||Read this in books on-line. It discusses changing and using custom style
sheets. It might not get all the way to what you want but at least some of
the way.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/df805cff-b1de-4062-b2ac-423f37390fbd.htm
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Hyde" <david*nospam*.hyde@.celeton.com> wrote in message
news:1166003621.3958.0@.proxy02.news.clara.net...
> Hmmm, not straight forward then. MS missed that one.
> Thanks very much.
> <jongalloway@.gmail.com> wrote in message
> news:1165970930.225111.181230@.f1g2000cwa.googlegroups.com...
>>I just wrote about some options here:
>> http://weblogs.asp.net/jgalloway/archive/2006/12/12/reporting-services-add-a-logo-to-the-report-manager.aspx
>> David Hyde wrote:
>> Hi,
>> Can the pages that are shown by SQL Server 2005 reporting services be
>> customised. The pages that are shown are rather "techy" looking. I
>> want to
>> change some of what is on there for my users' requirements and also be
>> able
>> to badge with corporate colours, logos, etc.
>> Thanks
>> David
>

Reporting Server vs. Database Server

Hi everyone,
After reading through countless Microsoft pages I'm still very
confused about how to setup a correct datasource connection. I have a
database server where all the data is kept, and a reports server that
I would like to use only to generate and deploy reports to. I have
Visual Studio 2005 installed on my client computer, and I DO NOT want
to create a data source that connects directly to the database
server.
Theoretically, there is a way to load VS and connect to the database
server through the reports server. I don't want any of my client
computers directly touching the database server, but they have to be
able to generate reports from that data. How can I accomplish this?
Anyone who can solve this conundrum gets a batch of my wife's home-
made cookies!Not possible. The computer that is running VS 2005 has to have a datasource
to the data being reported off of. All the users do not need to connect to
the database server but any developer using the report designer has to have
a data source created to hit the server.
I use mixed mode on the database server, create a readonly login that I use
for reporting.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<nlandis22@.gmail.com> wrote in message
news:1177429176.362218.226390@.t38g2000prd.googlegroups.com...
> Hi everyone,
> After reading through countless Microsoft pages I'm still very
> confused about how to setup a correct datasource connection. I have a
> database server where all the data is kept, and a reports server that
> I would like to use only to generate and deploy reports to. I have
> Visual Studio 2005 installed on my client computer, and I DO NOT want
> to create a data source that connects directly to the database
> server.
> Theoretically, there is a way to load VS and connect to the database
> server through the reports server. I don't want any of my client
> computers directly touching the database server, but they have to be
> able to generate reports from that data. How can I accomplish this?
> Anyone who can solve this conundrum gets a batch of my wife's home-
> made cookies!
>|||On Apr 24, 12:38 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Not possible. The computer that is running VS 2005 has to have a datasource
> to the data being reported off of. All the users do not need to connect to
> the database server but any developer using the report designer has to have
> a data source created to hit the server.
> I use mixed mode on the database server, create a readonly login that I use
> for reporting.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <nlandi...@.gmail.com> wrote in message
> news:1177429176.362218.226390@.t38g2000prd.googlegroups.com...
>
> > Hi everyone,
> > After reading through countless Microsoft pages I'm still very
> > confused about how to setup a correct datasource connection. I have a
> > database server where all the data is kept, and a reports server that
> > I would like to use only to generate and deploy reports to. I have
> > Visual Studio 2005 installed on my client computer, and I DO NOT want
> > to create a data source that connects directly to the database
> > server.
> > Theoretically, there is a way to load VS and connect to the database
> > server through the reports server. I don't want any of my client
> > computers directly touching the database server, but they have to be
> > able to generate reports from that data. How can I accomplish this?
> > Anyone who can solve this conundrum gets a batch of my wife's home-
> > made cookies!- Hide quoted text -
> - Show quoted text -
That's for the help. I think having a read-only login is probably a
safe way to go. The only reason I asked was because of this article
that I found earlier. I don't quite understand Report Server Model's
yet... but I get the feeling it's something for Report Builder, and
not for Report Designer (VS).
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/2aef6082da0ab4a4/8db0b06920500fc2?lnk=gst&q=data+source&rnum=6#8db0b06920500fc2