Groups | Blog | Home
all groups > sql server reporting services > june 2005 >

sql server reporting services : sql server reporting services in 2005 general questions



gl
6/24/2005 12:04:02 PM
Does sql 2005 reporting services still require you to host reports off IIS?
Or can you embed them into an app similar to crystal reports? For instance, i
need a reporting service that works disconnected.

I'm planning on making an application that uses a locally stored sql server
express 2005 instance as a database, however each client machine has no IIS
installed. Can I still use reporting services 2005 on the machine in this
instance (in a disconnected state). Is there a description somewhere of how
to do this?

i dont' want to have to use crystal reports if i don't have to.
Bruce L-C [MVP]
6/24/2005 2:59:37 PM
Visual studio 2005 will ship with two controls, winform and webform. They
can operate in local mode where you pass the control a dataset and the
report. The beta 2 of Widbey has this. VS 2005 and SQL Server 2005 both will
be released in November.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Christoph Wienands
6/27/2005 8:55:14 AM
Hey gl,

[quoted text, click to view]

I guess there are two theoretical scenarios:

1) You have part/all of the data from the server database and want to
generate reports locally.

2) You only want to look at reports locally.

About 1), I'm not sure if you can use RS without IIS. First of all it
requires a license, either included in SQL Server or stand-alone (makes each
client expensive). Second, the only "official" interface is through SOAP,
which in turn requires IIS.

About 2), you can use SOAP while you're connected to pull reports in all
kinds of formats (HTML, Word, PDF, etc.) store them locally and display them
later through your application. I don't think you'll have all the features
of a stand-alone app like Crystal.

Christoph

AddThis Social Bookmark Button