Reporting Services in Express SP2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 27 Feb 2007 22:38 GMT

Can reports I created in SQL Server 2005 using Reporting Services run on SQL
Express 2005 with SP2? I am a developer and some of our clients use SQL
Express. Thank you.

David

Reply to this Message

EMartinez - 28 Feb 2007 04:10 GMT

> Can reports I created in SQL Server 2005 using Reporting Services run on SQL
> Express 2005 with SP2? I am a developer and some of our clients use SQL
> Express. Thank you.
>
> David

Prior to SP2, this was no problem. I would assume the same afterwards;
however, someone else may know for certain.

Regards,

Enrique Martinez
Sr. SQL Server Developer

Reply to this Message

David - 28 Feb 2007 14:57 GMT

I thought it still requires and SQL Server license, correct? So if a small
company only uses SQL Express then I think they cannot install Reporting
Services. Can anyone verify that for me or point me to documentation?
Thanks.

David

>> Can reports I created in SQL Server 2005 using Reporting Services run on
>> SQL
[quoted text clipped - 10 lines]
> Enrique Martinez
> Sr. SQL Server Developer

Reply to this Message

Bruce L-C [MVP] - 28 Feb 2007 16:33 GMT

If the data is local to SQL Server Express there is a version of SQL Server
Express that comes with RS.

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
http://msdn.microsoft.com/vstudio/express/sql/

It is free with the one caveat. The data being reported off of is local
(i.e. on express as well). You cannot use this to report off of other SQL
Servers, or Oracle or etc etc.

>I thought it still requires and SQL Server license, correct? So if a small
>company only uses SQL Express then I think they cannot install Reporting
[quoted text clipped - 17 lines]
>> Enrique Martinez
>> Sr. SQL Server Developer

Reply to this Message

David - 28 Feb 2007 17:11 GMT

That is ok as this will be the only database reported on. Are all output
formats available (PDF, Excel, etc.)? Thanks.

David

> If the data is local to SQL Server Express there is a version of SQL
> Server Express that comes with RS.
[quoted text clipped - 28 lines]
>>> Enrique Martinez
>>> Sr. SQL Server Developer

Reply to this Message

Bruce L-C [MVP] - 28 Feb 2007 17:22 GMT

http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> That is ok as this will be the only database reported on. Are all output
> formats available (PDF, Excel, etc.)? Thanks.
[quoted text clipped - 33 lines]
>>>> Enrique Martinez
>>>> Sr. SQL Server Developer

Reply to this Message