Can we add templates to SSRS?

Hi. Is it possible to add a custom template to SSRS for new reports? We'd like to create a template that has our logo and colors. Can you point me to a tutorial on this? Your help is much appreciated.

Yes, it is possible. For more details, check out this blog entry:

http://blogs.msdn.com/bimusings/archive/2005/12/06/500462.aspx

Can someone tell me whats wrong with this code?

Hi All

I keep getting back VINET and not Lilas...can someone point me in the
right direction?

Thanks a lot

DECLARE @.idoc int
DECLARE @.doc varchar(1000)
SET @.doc ='
<ROOT
<CustomerID>VINET </CustomerID
<CustomerID>Lilas</CustomerID
</ROOT>'
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @.idoc OUTPUT, @.doc
-- Execute a SELECT statement that uses the OPENXML rowset provider.
SELECT *
FROM OPENXML (@.idoc, '/ROOT',2)
WITH (

CustomerID varchar(100) )I'm not an expert on SQL Server and XML, but it seems to me that
OPENXML is very picky about the XML form that it will accept; can you
modify your XML statement to read like this?

SET @.doc ='
<ROOT>
<Customer>
<CustomerID>VINET </CustomerID>
</Customer>
<Customer>
<CustomerID>Lilas</CustomerID>
</Customer>
</ROOT>'

and then your OPENXML to statement to read like this:

SELECT *
FROM OPENXML (@.idoc, '/ROOT/Customer',2)
WITH (
CustomerID varchar(100) )

Don't know why it works, but it does.

Stu|||Try this...

DECLARE @.idoc int
DECLARE @.doc varchar(1000)
SET @.doc ='
<ROOT
<CustomerID>VINET </CustomerID
<CustomerID>Lilas</CustomerID
</ROOT>'
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @.idoc OUTPUT, @.doc
-- Execute a SELECT statement that uses the OPENXML rowset provider.
SELECT *
FROM OPENXML (@.idoc, '/ROOT/CustomerID',2)
WITH (

CustomerID varchar(100) '.')

EXEC sp_xml_removedocument @.iDoc|||Thank you Mark that works great!!!!
Can you explain to my why '.' needed to be included? I can't seem to
locate it in Books online...

Thanks again|||(reezaali@.gmail.com) writes:
> Thank you Mark that works great!!!!
> Can you explain to my why '.' needed to be included? I can't seem to
> locate it in Books online...

Books Online says about col-pattern:

Is an optional, general XPath pattern that describes how the XML nodes
should be mapped to the columns. If the ColPattern is not specified, the
default mapping (attribute-centric or element-centric mapping as
specified by flags) takes place.

'.' maps to the current node, which is /Root/CustomerID.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thank you...

Can RS 2005 point to SQL 2000 DB?

I would like to install Reporting Services 2005 on one IIS box and point to a
separate SQL Server 2000 box which would be used to host its two databases
(ReportingServer and ReportingServerTempDB).
Will this work?
--
LulkYes. You need a 2005 license on the IIS box but the databases can be on 2000
(I am running in this configuration).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>I would like to install Reporting Services 2005 on one IIS box and point to
>a
> separate SQL Server 2000 box which would be used to host its two databases
> (ReportingServer and ReportingServerTempDB).
> Will this work?
> --
> Lulk|||Yes, this will work. The database will have to have its schema updated, but
can be hosted on SQL Server 2000. You can use the Reporting Services
Configuration Tool to accomplish this easily enough.
Rodney
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>I would like to install Reporting Services 2005 on one IIS box and point to
>a
> separate SQL Server 2000 box which would be used to host its two databases
> (ReportingServer and ReportingServerTempDB).
> Will this work?
> --
> Lulk|||Does it require two SQL Server licenses if you are going to run RS 2005 on a
separate ISS server and point to a separate 2000 SQL Server? What if I point
to a separate SQL 2005 Server, would that configuration still require two SQL
Server licenses?
--
Lulk
"Bruce L-C [MVP]" wrote:
> Yes. You need a 2005 license on the IIS box but the databases can be on 2000
> (I am running in this configuration).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lulk" <Lulk@.discussions.microsoft.com> wrote in message
> news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
> >I would like to install Reporting Services 2005 on one IIS box and point to
> >a
> > separate SQL Server 2000 box which would be used to host its two databases
> > (ReportingServer and ReportingServerTempDB).
> >
> > Will this work?
> > --
> > Lulk
>
>|||Yes. Whatever box RS is running on needs a license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:3A86DA3A-674D-4F8E-BAF2-9CB0823DEF9A@.microsoft.com...
> Does it require two SQL Server licenses if you are going to run RS 2005 on
> a
> separate ISS server and point to a separate 2000 SQL Server? What if I
> point
> to a separate SQL 2005 Server, would that configuration still require two
> SQL
> Server licenses?
> --
> Lulk
>
> "Bruce L-C [MVP]" wrote:
>> Yes. You need a 2005 license on the IIS box but the databases can be on
>> 2000
>> (I am running in this configuration).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Lulk" <Lulk@.discussions.microsoft.com> wrote in message
>> news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>> >I would like to install Reporting Services 2005 on one IIS box and point
>> >to
>> >a
>> > separate SQL Server 2000 box which would be used to host its two
>> > databases
>> > (ReportingServer and ReportingServerTempDB).
>> >
>> > Will this work?
>> > --
>> > Lulk
>>