Reporting Services

Hi there

Have been using the "vanilla" SQL Express for some time now and feel that I kind of know what I'm doing.

However, I have no idea what can be acheived with the Reporting Services that come with the "advanced" SQL Express.

Can someone please explain what I can do with Reporting Services?

Reporting Services is a web server that allows you to provide a reporting exerience for your database that can be accessed on a web site rather than requring people to open up a specific application. Think about things like summary or rollup reports; there is no need to have everyone install a specialized application, you just create reports and Deploy them to RS and then folks can look at them.

Like any access to SQL, you can use either Windows or SQL Auth, depending on how your SQL Server is configured, and then use that to control access to the data.

RS Express provides some limited Export capability (PDF & XLS) and can only access local, relational data. There is more information in BOL and a whole series of webcasts you can view to learn more at http://msdn.microsoft.com/sql/bi/reporting/default.aspx.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

Reporting Service Report Background Property

Hi

I have created a report and I'm trying to adjust the background color so that the color of the report fits in better with the look and feel of the website. Thus far no luck! Any offers of help?

Check it out here:

http://www.autowired.co.uk/store/rept_serv_prob.gif

Many thanks

you probably have found this by now but just in case

in Reporting Services Property - under Background image - there is an X and and Y - try changing this to match your background colour.

cheers

jewel

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
>