New to M'soft - doing feasibility study of migrating from Brio to

I was really impressed with the ease MSRS reports can be created, but at the
end of it I have come to a roadblock with MSRS not supporting Multi select in
Parameters and also no graphical handle to place the parameters where I want.
So I am concluding that MSRS is not a go forward reporting tool for us.
Do any of you guys think there is a way around'
Also there is no way of jazzing up the reports menu on the Reportserver.
Is there an option of using ASP.net to build the parameters there and then
pass on to the report server' can somebody put down an example.
We have 100 reports to migrate. And I'm running out of time to decide to go
or not to go wit MSRS.. please put in your thoughts/ solutions if any
Thanks
GNUToday you can easily integrate with ASP.Net. You can use either URL
integration or web services. Very strong support for this.
With service pack 2 there will be support for client side printing (SP2 will
be out within the next month or two). The next version of RS will be out
with the next version of SQL Server (Yukon). I am hoping Yukon RS will have
multi-select but I don't know.
I suggest looking at the books on line (you can get to it on the msdn
website I believe). Also, check out all the material available here:
http://www.microsoft.com/sql/reporting/productinfo/default.asp
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"GNU" <GNU@.discussions.microsoft.com> wrote in message
news:A7CF6172-BB99-40D5-8573-9C71B3208B22@.microsoft.com...
> I was really impressed with the ease MSRS reports can be created, but at
the
> end of it I have come to a roadblock with MSRS not supporting Multi select
in
> Parameters and also no graphical handle to place the parameters where I
want.
> So I am concluding that MSRS is not a go forward reporting tool for us.
> Do any of you guys think there is a way around'
> Also there is no way of jazzing up the reports menu on the Reportserver.
> Is there an option of using ASP.net to build the parameters there and then
> pass on to the report server' can somebody put down an example.
> We have 100 reports to migrate. And I'm running out of time to decide to
go
> or not to go wit MSRS.. please put in your thoughts/ solutions if any
> Thanks
> GNU
>|||For multi-select parameters, we will have native support for multi-select in
SQL 2005 Reporting Services. You can handle this today by providing your own
parameter UI and dynamically constructing the SQL statement. As for moving
the parameters around, you would have to do this with your own UI.
It is fairly easy to build your own UI in the SQL 2000 version of Reporting
Services using either the Web Services interfaces or URL access. We will
make it even easier in the SQL 2005 version of Reporting Services by using
the new Report Veiwer controls that you can host in your WinForms or ASP.NET
application.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"GNU" <GNU@.discussions.microsoft.com> wrote in message
news:A7CF6172-BB99-40D5-8573-9C71B3208B22@.microsoft.com...
>I was really impressed with the ease MSRS reports can be created, but at
>the
> end of it I have come to a roadblock with MSRS not supporting Multi select
> in
> Parameters and also no graphical handle to place the parameters where I
> want.
> So I am concluding that MSRS is not a go forward reporting tool for us.
> Do any of you guys think there is a way around'
> Also there is no way of jazzing up the reports menu on the Reportserver.
> Is there an option of using ASP.net to build the parameters there and then
> pass on to the report server' can somebody put down an example.
> We have 100 reports to migrate. And I'm running out of time to decide to
> go
> or not to go wit MSRS.. please put in your thoughts/ solutions if any
> Thanks
> GNU
>|||thanks for ur reply.. some more questions..
1) when is SQL 2005 scheduled for release?
2) If I can use ASP.NET will I have to write a lot of code to incorporate
the report in a frame below the asp page so that i can keep changing my
parameters n look up the report data.
3) will it allow export data into Excel/CSV ? as it does when viewed from
report server or will I have to write code for it?
4) where can I find some sample code, I'm new to .Net.
Thanks,
GNU
"Brian Welcker [MSFT]" wrote:
> For multi-select parameters, we will have native support for multi-select in
> SQL 2005 Reporting Services. You can handle this today by providing your own
> parameter UI and dynamically constructing the SQL statement. As for moving
> the parameters around, you would have to do this with your own UI.
> It is fairly easy to build your own UI in the SQL 2000 version of Reporting
> Services using either the Web Services interfaces or URL access. We will
> make it even easier in the SQL 2005 version of Reporting Services by using
> the new Report Veiwer controls that you can host in your WinForms or ASP.NET
> application.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "GNU" <GNU@.discussions.microsoft.com> wrote in message
> news:A7CF6172-BB99-40D5-8573-9C71B3208B22@.microsoft.com...
> >I was really impressed with the ease MSRS reports can be created, but at
> >the
> > end of it I have come to a roadblock with MSRS not supporting Multi select
> > in
> > Parameters and also no graphical handle to place the parameters where I
> > want.
> > So I am concluding that MSRS is not a go forward reporting tool for us.
> > Do any of you guys think there is a way around'
> > Also there is no way of jazzing up the reports menu on the Reportserver.
> > Is there an option of using ASP.net to build the parameters there and then
> > pass on to the report server' can somebody put down an example.
> > We have 100 reports to migrate. And I'm running out of time to decide to
> > go
> > or not to go wit MSRS.. please put in your thoughts/ solutions if any
> > Thanks
> > GNU
> >
> >
>
>|||Answers inline.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"GNU" <GNU@.discussions.microsoft.com> wrote in message
news:2D6F7754-3832-4F25-AAAE-B1F74C4867EA@.microsoft.com...
> thanks for ur reply.. some more questions..
> 1) when is SQL 2005 scheduled for release?
Late summer of 2005.
> 2) If I can use ASP.NET will I have to write a lot of code to incorporate
> the report in a frame below the asp page so that i can keep changing my
> parameters n look up the report data.
Not if you use the Report Viewer controls. You just bind parmeter values in
the control.
> 3) will it allow export data into Excel/CSV ? as it does when viewed from
> report server or will I have to write code for it?
The viewer supports export.
> 4) where can I find some sample code, I'm new to .Net.
There are samples in the product already as well as there will be more
samples in the 2005 release.
> Thanks,
> GNU
>
> "Brian Welcker [MSFT]" wrote:
>> For multi-select parameters, we will have native support for multi-select
>> in
>> SQL 2005 Reporting Services. You can handle this today by providing your
>> own
>> parameter UI and dynamically constructing the SQL statement. As for
>> moving
>> the parameters around, you would have to do this with your own UI.
>> It is fairly easy to build your own UI in the SQL 2000 version of
>> Reporting
>> Services using either the Web Services interfaces or URL access. We will
>> make it even easier in the SQL 2005 version of Reporting Services by
>> using
>> the new Report Veiwer controls that you can host in your WinForms or
>> ASP.NET
>> application.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "GNU" <GNU@.discussions.microsoft.com> wrote in message
>> news:A7CF6172-BB99-40D5-8573-9C71B3208B22@.microsoft.com...
>> >I was really impressed with the ease MSRS reports can be created, but at
>> >the
>> > end of it I have come to a roadblock with MSRS not supporting Multi
>> > select
>> > in
>> > Parameters and also no graphical handle to place the parameters where I
>> > want.
>> > So I am concluding that MSRS is not a go forward reporting tool for us.
>> > Do any of you guys think there is a way around'
>> > Also there is no way of jazzing up the reports menu on the
>> > Reportserver.
>> > Is there an option of using ASP.net to build the parameters there and
>> > then
>> > pass on to the report server' can somebody put down an example.
>> > We have 100 reports to migrate. And I'm running out of time to decide
>> > to
>> > go
>> > or not to go wit MSRS.. please put in your thoughts/ solutions if any
>> > Thanks
>> > GNU
>> >
>> >
>>