Monday, February 20, 2012

MS Reporting Service for Client Application

1. We have Thin Client which is connecting to the Sql Express database. Is it
possible to use MS Reporting Service in Sql Express database.
2. What are the pre requisites shoule be there in my thin client to see my
reports in the thin client.SQL Express is not supported for RS 2000. It will be supported for RS 2005
with SQL Express but this will be a release after the release of SQL Server
2005. My understanding is sometime in the first half of next year.
What is your thin client? You can integrate reporting services multiple
ways. You can use URL integration (IE 6 works best). You can use web
services. Also, Visual Studio 2005 will have 2 controls, a winform and a
webform control. Note that these can work in local mode where no server is
required. There are some limitations (for instance you lose some exporting
formats, no scheduling etc) but in general pretty fully functional. You give
it a dataset and a report. Depending on what you want this might fulfill
your needs. In that case Express is just a datasource that you get your
dataset from. These controls will work in local mode with the release of VS
2005 (November).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mohan" <Mohan@.discussions.microsoft.com> wrote in message
news:100416CF-2203-4D42-A5D6-2D17328AE7D0@.microsoft.com...
> 1. We have Thin Client which is connecting to the Sql Express database. Is
> it
> possible to use MS Reporting Service in Sql Express database.
> 2. What are the pre requisites shoule be there in my thin client to see my
> reports in the thin client.
>|||Hi Bruce,
Thanks for you reply.
My Requrments is I want to view a report in my thin client(windows
applicaion). what the pre requisits need in the client applicaion.
Regards
Mohan
"Bruce L-C [MVP]" wrote:
> SQL Express is not supported for RS 2000. It will be supported for RS 2005
> with SQL Express but this will be a release after the release of SQL Server
> 2005. My understanding is sometime in the first half of next year.
> What is your thin client? You can integrate reporting services multiple
> ways. You can use URL integration (IE 6 works best). You can use web
> services. Also, Visual Studio 2005 will have 2 controls, a winform and a
> webform control. Note that these can work in local mode where no server is
> required. There are some limitations (for instance you lose some exporting
> formats, no scheduling etc) but in general pretty fully functional. You give
> it a dataset and a report. Depending on what you want this might fulfill
> your needs. In that case Express is just a datasource that you get your
> dataset from. These controls will work in local mode with the release of VS
> 2005 (November).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Mohan" <Mohan@.discussions.microsoft.com> wrote in message
> news:100416CF-2203-4D42-A5D6-2D17328AE7D0@.microsoft.com...
> > 1. We have Thin Client which is connecting to the Sql Express database. Is
> > it
> > possible to use MS Reporting Service in Sql Express database.
> >
> > 2. What are the pre requisites shoule be there in my thin client to see my
> > reports in the thin client.
> >
> >
>
>|||RS 2005 for Express is not available yet even in beta form. The controls are
available with the Visual Studio beta (which is currently release
candidate). The controls are free with VS. No licensing needed to create or
run the report. All is client side, you provide the report, you provide the
dataset. If you need server side and express then you will have to wait
until that combination is released next year. My understanding is that
Express has some other limitations (for instance, I think the data you are
going after has to be on the same box as the report, it doesn't support
cubes, etc).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mohan" <Mohan@.discussions.microsoft.com> wrote in message
news:422C3A50-41A2-4F0B-94DA-6BE627D0FBAC@.microsoft.com...
> Hi Bruce,
> Thanks for you reply.
> My Requrments is I want to view a report in my thin client(windows
> applicaion). what the pre requisits need in the client applicaion.
> Regards
> Mohan
> "Bruce L-C [MVP]" wrote:
>> SQL Express is not supported for RS 2000. It will be supported for RS
>> 2005
>> with SQL Express but this will be a release after the release of SQL
>> Server
>> 2005. My understanding is sometime in the first half of next year.
>> What is your thin client? You can integrate reporting services multiple
>> ways. You can use URL integration (IE 6 works best). You can use web
>> services. Also, Visual Studio 2005 will have 2 controls, a winform and a
>> webform control. Note that these can work in local mode where no server
>> is
>> required. There are some limitations (for instance you lose some
>> exporting
>> formats, no scheduling etc) but in general pretty fully functional. You
>> give
>> it a dataset and a report. Depending on what you want this might fulfill
>> your needs. In that case Express is just a datasource that you get your
>> dataset from. These controls will work in local mode with the release of
>> VS
>> 2005 (November).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Mohan" <Mohan@.discussions.microsoft.com> wrote in message
>> news:100416CF-2203-4D42-A5D6-2D17328AE7D0@.microsoft.com...
>> > 1. We have Thin Client which is connecting to the Sql Express database.
>> > Is
>> > it
>> > possible to use MS Reporting Service in Sql Express database.
>> >
>> > 2. What are the pre requisites shoule be there in my thin client to see
>> > my
>> > reports in the thin client.
>> >
>> >
>>

No comments:

Post a Comment