Groups | Blog | Home
all groups > sql server reporting services > december 2004 >

sql server reporting services : Using with SQL Express 2005 -- question for MS.


billd
12/26/2004 9:43:04 AM
What are the capabilities/limitations of using Reporting Services with the
upcoming SQL Server Express 2005?

Is the Reporting Services service included with the SQL Express licence?

Thanks,
Robert Bruckner [MSFT]
12/27/2004 7:20:30 PM
SQL Express can be used as a data source of reports running on a RS 2005
server, or for the report controls included in the upcoming VS 2005.
See also: http://www.microsoft.com/sql/express/

--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Bruce L-C [MVP]
12/28/2004 8:06:30 AM
To clarify further, with the next version their will be really two ways of
using reports. The report controls mentioned below are either a winform or
webform control. They will work with a Reporting Services server but do not
require it. So it is possible to have a report and display it in your
application with no server. SQL Express can have the data you are reporting
off of but is not used by or includes the licensing for the RS server.

Think of it this way, today RS is a server product. No reports work without
the server and the licensing is based on SQL Server licensing. In the future
these controls change that to where the server product is optional. The
server product is what provides the Report Manager (think of it as the
portal), the subscriptions, scheduling, etc. If you use the controls without
the server product then you have to create the UI around the reports
yourself. Which is what you would have to do if you use SQL Express.

Robert, correct me if I am wrong.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

billd
12/28/2004 8:17:04 AM
Thank you Bruce. It seems clear.

To repeat what you said:

If I want things like report publishing and scheduling, I will need the full
RS server which is only included with SQL 2005 Std or Enterprise.

If I just want embeded reports in my application, I can use reporting
controls.

Bill

[quoted text, click to view]
Bruce L-C [MVP]
12/28/2004 10:52:51 AM
Yes. Note that controls allow either (stand alone or working in conjunction
with RS Server).


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button