Reporting Services General

Hi
There are some questions about the Microsoft Reporting Services:
1. We have a SQL Server 2000, but can I also run this reporting service on a
SQL 7 ?
2. Can I set the positions of the objects (eg. rectangle) dynmically? (in
asp)
greetz patrickYou can use SQL 7 as the place the data for the report resides but RS needs
SQL Server 2000 sp3a to run (you can hit many many different databases for
the source of the data: Sybase, DB2, Oracle, SQL Server etc).
As far as #2, you don't want to go down that path. Although technically it
is possible it would be a royal pain. You would have to generate the RDL
(report definition language, the report has an XML schema that defines it)
on the fly, deploy it. Have it be unique name because otherwise if multiple
users are trying to get to a report they could get the wrong one, etc.
RS has lots of things that occur dynamically (can grow etc) so it might be
that the reason you want to dynamically set the position of the object can
be done in some other way.
Bruce L-C
"Patrick" <horusspam@.yahoo.de> wrote in message
news:%23yxWk1xnEHA.592@.TK2MSFTNGP11.phx.gbl...
> Hi
> There are some questions about the Microsoft Reporting Services:
> 1. We have a SQL Server 2000, but can I also run this reporting service on
a
> SQL 7 ?
> 2. Can I set the positions of the objects (eg. rectangle) dynmically? (in
> asp)
> greetz patrick
>|||Ok, thank you for your answer.
Can you recommand me another (web-)reporting tool?
I'm looking forward to hearing from you
greetz
horus
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:OxMxC6xnEHA.3900@.TK2MSFTNGP10.phx.gbl...
> You can use SQL 7 as the place the data for the report resides but RS
needs
> SQL Server 2000 sp3a to run (you can hit many many different databases for
> the source of the data: Sybase, DB2, Oracle, SQL Server etc).
> As far as #2, you don't want to go down that path. Although technically it
> is possible it would be a royal pain. You would have to generate the RDL
> (report definition language, the report has an XML schema that defines it)
> on the fly, deploy it. Have it be unique name because otherwise if
multiple
> users are trying to get to a report they could get the wrong one, etc.
> RS has lots of things that occur dynamically (can grow etc) so it might be
> that the reason you want to dynamically set the position of the object can
> be done in some other way.
> Bruce L-C
> "Patrick" <horusspam@.yahoo.de> wrote in message
> news:%23yxWk1xnEHA.592@.TK2MSFTNGP11.phx.gbl...
> > Hi
> >
> > There are some questions about the Microsoft Reporting Services:
> >
> > 1. We have a SQL Server 2000, but can I also run this reporting service
on
> a
> > SQL 7 ?
> > 2. Can I set the positions of the objects (eg. rectangle) dynmically?
(in
> > asp)
> >
> > greetz patrick
> >
> >
>|||From your post it is not clear why you feel you need another tool. Is SQL 7
a deal buster? Is it the issue with positioning the objects?
Bruce L-C
"Patrick" <horusspam@.yahoo.de> wrote in message
news:ec$zT9xnEHA.3908@.TK2MSFTNGP09.phx.gbl...
> Ok, thank you for your answer.
> Can you recommand me another (web-)reporting tool?
> I'm looking forward to hearing from you
> greetz
> horus
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
> news:OxMxC6xnEHA.3900@.TK2MSFTNGP10.phx.gbl...
> > You can use SQL 7 as the place the data for the report resides but RS
> needs
> > SQL Server 2000 sp3a to run (you can hit many many different databases
for
> > the source of the data: Sybase, DB2, Oracle, SQL Server etc).
> >
> > As far as #2, you don't want to go down that path. Although technically
it
> > is possible it would be a royal pain. You would have to generate the RDL
> > (report definition language, the report has an XML schema that defines
it)
> > on the fly, deploy it. Have it be unique name because otherwise if
> multiple
> > users are trying to get to a report they could get the wrong one, etc.
> >
> > RS has lots of things that occur dynamically (can grow etc) so it might
be
> > that the reason you want to dynamically set the position of the object
can
> > be done in some other way.
> >
> > Bruce L-C
> >
> > "Patrick" <horusspam@.yahoo.de> wrote in message
> > news:%23yxWk1xnEHA.592@.TK2MSFTNGP11.phx.gbl...
> > > Hi
> > >
> > > There are some questions about the Microsoft Reporting Services:
> > >
> > > 1. We have a SQL Server 2000, but can I also run this reporting
service
> on
> > a
> > > SQL 7 ?
> > > 2. Can I set the positions of the objects (eg. rectangle) dynmically?
> (in
> > > asp)
> > >
> > > greetz patrick
> > >
> > >
> >
> >
>|||I need a reporting tool, where i can dynamically set the position of
objects.
To color them and export to PDF.
The reports have to be webbased.
Do you know any programm, accomplish these criteriums?
Thank you
Patrick
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:OPB8kPynEHA.4004@.TK2MSFTNGP10.phx.gbl...
> From your post it is not clear why you feel you need another tool. Is SQL
7
> a deal buster? Is it the issue with positioning the objects?
> Bruce L-C
> "Patrick" <horusspam@.yahoo.de> wrote in message
> news:ec$zT9xnEHA.3908@.TK2MSFTNGP09.phx.gbl...
> > Ok, thank you for your answer.
> >
> > Can you recommand me another (web-)reporting tool?
> > I'm looking forward to hearing from you
> >
> > greetz
> > horus
> > "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> schrieb im
Newsbeitrag
> > news:OxMxC6xnEHA.3900@.TK2MSFTNGP10.phx.gbl...
> > > You can use SQL 7 as the place the data for the report resides but RS
> > needs
> > > SQL Server 2000 sp3a to run (you can hit many many different databases
> for
> > > the source of the data: Sybase, DB2, Oracle, SQL Server etc).
> > >
> > > As far as #2, you don't want to go down that path. Although
technically
> it
> > > is possible it would be a royal pain. You would have to generate the
RDL
> > > (report definition language, the report has an XML schema that defines
> it)
> > > on the fly, deploy it. Have it be unique name because otherwise if
> > multiple
> > > users are trying to get to a report they could get the wrong one, etc.
> > >
> > > RS has lots of things that occur dynamically (can grow etc) so it
might
> be
> > > that the reason you want to dynamically set the position of the object
> can
> > > be done in some other way.
> > >
> > > Bruce L-C
> > >
> > > "Patrick" <horusspam@.yahoo.de> wrote in message
> > > news:%23yxWk1xnEHA.592@.TK2MSFTNGP11.phx.gbl...
> > > > Hi
> > > >
> > > > There are some questions about the Microsoft Reporting Services:
> > > >
> > > > 1. We have a SQL Server 2000, but can I also run this reporting
> service
> > on
> > > a
> > > > SQL 7 ?
> > > > 2. Can I set the positions of the objects (eg. rectangle)
dynmically?
> > (in
> > > > asp)
> > > >
> > > > greetz patrick
> > > >
> > > >
> > >
> > >
> >
> >
>