Friday, March 9, 2012

Reporting Services in Express SP2

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.
DavidOn Feb 27, 4:38 pm, "David" <dlch...@.lifetimeinc.com> wrote:
> 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|||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
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1172635810.340693.99970@.8g2000cwh.googlegroups.com...
> On Feb 27, 4:38 pm, "David" <dlch...@.lifetimeinc.com> wrote:
>> 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
>|||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.
"David" <dlchase@.lifetimeinc.com> wrote in message
news:eWXCZj0WHHA.4240@.TK2MSFTNGP06.phx.gbl...
>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
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1172635810.340693.99970@.8g2000cwh.googlegroups.com...
>> On Feb 27, 4:38 pm, "David" <dlch...@.lifetimeinc.com> wrote:
>> 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
>|||That is ok as this will be the only database reported on. Are all output
formats available (PDF, Excel, etc.)? Thanks.
David
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uJ09dY1WHHA.1200@.TK2MSFTNGP04.phx.gbl...
> 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.
>
> "David" <dlchase@.lifetimeinc.com> wrote in message
> news:eWXCZj0WHHA.4240@.TK2MSFTNGP06.phx.gbl...
>>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
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1172635810.340693.99970@.8g2000cwh.googlegroups.com...
>> On Feb 27, 4:38 pm, "David" <dlch...@.lifetimeinc.com> wrote:
>> 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
>>
>|||http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <dlchase@.lifetimeinc.com> wrote in message
news:%2349vdu1WHHA.4624@.TK2MSFTNGP03.phx.gbl...
> That is ok as this will be the only database reported on. Are all output
> formats available (PDF, Excel, etc.)? Thanks.
> David
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uJ09dY1WHHA.1200@.TK2MSFTNGP04.phx.gbl...
>> 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.
>>
>> "David" <dlchase@.lifetimeinc.com> wrote in message
>> news:eWXCZj0WHHA.4240@.TK2MSFTNGP06.phx.gbl...
>>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
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1172635810.340693.99970@.8g2000cwh.googlegroups.com...
>> On Feb 27, 4:38 pm, "David" <dlch...@.lifetimeinc.com> wrote:
>> 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
>>
>>
>

No comments:

Post a Comment