Reporting Services

I've been reading through the tech installation information on the above, bu
t
one thing I don't see is where you get the installation code, i.e. do you
have to download it or is it on a certain CD in the MSDN? If anybody knows
this, I'd appreciate some quick info...CLM,
See:
http://www.microsoft.com/sql/report...ds/default.mspx
for trial, SPs and packs.
HTH
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:9860A025-D1FC-4DC6-89F0-6D1991EC666F@.microsoft.com...
> I've been reading through the tech installation information on the above,
> but
> one thing I don't see is where you get the installation code, i.e. do you
> have to download it or is it on a certain CD in the MSDN? If anybody
> knows
> this, I'd appreciate some quick info...|||http://www.microsoft.com/sql/report...uy/default.mspx
http://sqlservercode.blogspot.com/
"CLM" wrote:

> I've been reading through the tech installation information on the above,
but
> one thing I don't see is where you get the installation code, i.e. do you
> have to download it or is it on a certain CD in the MSDN? If anybody know
s
> this, I'd appreciate some quick info...

Reporting Services

I've been reading through the tech installation information on the above, but
one thing I don't see is where you get the installation code, i.e. do you
have to download it or is it on a certain CD in the MSDN? If anybody knows
this, I'd appreciate some quick info...CLM,
See:
http://www.microsoft.com/sql/reporting/downloads/default.mspx
for trial, SPs and packs.
HTH
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:9860A025-D1FC-4DC6-89F0-6D1991EC666F@.microsoft.com...
> I've been reading through the tech installation information on the above,
> but
> one thing I don't see is where you get the installation code, i.e. do you
> have to download it or is it on a certain CD in the MSDN? If anybody
> knows
> this, I'd appreciate some quick info...|||http://www.microsoft.com/sql/reporting/howtobuy/default.mspx
http://sqlservercode.blogspot.com/
"CLM" wrote:
> I've been reading through the tech installation information on the above, but
> one thing I don't see is where you get the installation code, i.e. do you
> have to download it or is it on a certain CD in the MSDN? If anybody knows
> this, I'd appreciate some quick info...

Reporting Services

I've been reading through the tech installation information on the above, but
one thing I don't see is where you get the installation code, i.e. do you
have to download it or is it on a certain CD in the MSDN? If anybody knows
this, I'd appreciate some quick info...
CLM,
See:
http://www.microsoft.com/sql/reporti...s/default.mspx
for trial, SPs and packs.
HTH
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:9860A025-D1FC-4DC6-89F0-6D1991EC666F@.microsoft.com...
> I've been reading through the tech installation information on the above,
> but
> one thing I don't see is where you get the installation code, i.e. do you
> have to download it or is it on a certain CD in the MSDN? If anybody
> knows
> this, I'd appreciate some quick info...
|||http://www.microsoft.com/sql/reporti...y/default.mspx
http://sqlservercode.blogspot.com/
"CLM" wrote:

> I've been reading through the tech installation information on the above, but
> one thing I don't see is where you get the installation code, i.e. do you
> have to download it or is it on a certain CD in the MSDN? If anybody knows
> this, I'd appreciate some quick info...

Reporting Service vs UDM

I am new to both technologies and would has been reading UDM on how to create a cube. My orginal intention is to create cubes for efficient retrieval of data which ends up in reports managment in an application. Can anyone elaborates on how the reporting service differs from UDM? ( or what reporting services are?)I thought they are mutually exclusive?Thanks.

Regards

Alu

Does it mean that the report service generates reports from OLTP database if the UDM is not created? Does it mean UDM can work with reporting serivce which theortically speaking making the best of both if implemented?Thanks.

Regards

Alu

|||

UDM is actually the cube. You can design MDX/Cube-queries in Reporting Services and Report Builder. There is a graphical design tool in RS 2005.

It also possible to query a data warehouse, data mart or OLTP-system with TSQL queries. Reporting Services is not limited to SQL Server for SQL-queries. It will also work with Oracle and DB2.

The only OLAP-engine that is supported is Analysis Services.

HTH

Thomas Ivarsson

|||

I know that alot time decision to use SSRS with or without SSAS(UDM) and vice -versa depends on customer requirements. But generally speaking is there a general guidline on when to favour SSRS without/with SSAS and vice-versa?

Thanks.

Regards

Alu.

|||or rather which is the most common practice among the two combinations? ( with /without)|||

I think both approaches work. Cube-queries is normally about top level, aggregated information.

Relational queries(SQL) are normally leaf level.

OLAP cubes are less efficient with leaf level queries(long responstime) and relational queries(SQL) are less capable with top level queries(also long responstime)

In SSAS you can also relate these two worlds by using actions. An action in SSAS can point to a detailed report in Reporting Services.

It is also easier to create time caculations, like rolling 12 months, Year To Date and so on, in SSAS. You can write these calculation with less code in MDX than SQL will require.

HTH

Thomas Ivarsson

|||

Can i say that whether to use UDM or not depends on the type of reports customer would want?

Regards

Alu

|||

Yes. Thats my opinion. Most customers like both types of reports, leaf level and top level.

Regards

Thomas Ivarsson

|||

But even if thats does, to implement UDM ( if in the initial phase we dont even know if aggreate information is required in future)as well in the application does not harm right? :)

Regards

Alu

|||

UDM/the cube is a separate engine so it will not harm to build cubes.

Regards

Thomas Ivarsson

|||

Thanks alot!.

Regards

Alu

Reporting Server vs. Database Server

Hi everyone,
After reading through countless Microsoft pages I'm still very
confused about how to setup a correct datasource connection. I have a
database server where all the data is kept, and a reports server that
I would like to use only to generate and deploy reports to. I have
Visual Studio 2005 installed on my client computer, and I DO NOT want
to create a data source that connects directly to the database
server.
Theoretically, there is a way to load VS and connect to the database
server through the reports server. I don't want any of my client
computers directly touching the database server, but they have to be
able to generate reports from that data. How can I accomplish this?
Anyone who can solve this conundrum gets a batch of my wife's home-
made cookies!Not possible. The computer that is running VS 2005 has to have a datasource
to the data being reported off of. All the users do not need to connect to
the database server but any developer using the report designer has to have
a data source created to hit the server.
I use mixed mode on the database server, create a readonly login that I use
for reporting.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<nlandis22@.gmail.com> wrote in message
news:1177429176.362218.226390@.t38g2000prd.googlegroups.com...
> Hi everyone,
> After reading through countless Microsoft pages I'm still very
> confused about how to setup a correct datasource connection. I have a
> database server where all the data is kept, and a reports server that
> I would like to use only to generate and deploy reports to. I have
> Visual Studio 2005 installed on my client computer, and I DO NOT want
> to create a data source that connects directly to the database
> server.
> Theoretically, there is a way to load VS and connect to the database
> server through the reports server. I don't want any of my client
> computers directly touching the database server, but they have to be
> able to generate reports from that data. How can I accomplish this?
> Anyone who can solve this conundrum gets a batch of my wife's home-
> made cookies!
>|||On Apr 24, 12:38 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Not possible. The computer that is running VS 2005 has to have a datasource
> to the data being reported off of. All the users do not need to connect to
> the database server but any developer using the report designer has to have
> a data source created to hit the server.
> I use mixed mode on the database server, create a readonly login that I use
> for reporting.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <nlandi...@.gmail.com> wrote in message
> news:1177429176.362218.226390@.t38g2000prd.googlegroups.com...
>
> > Hi everyone,
> > After reading through countless Microsoft pages I'm still very
> > confused about how to setup a correct datasource connection. I have a
> > database server where all the data is kept, and a reports server that
> > I would like to use only to generate and deploy reports to. I have
> > Visual Studio 2005 installed on my client computer, and I DO NOT want
> > to create a data source that connects directly to the database
> > server.
> > Theoretically, there is a way to load VS and connect to the database
> > server through the reports server. I don't want any of my client
> > computers directly touching the database server, but they have to be
> > able to generate reports from that data. How can I accomplish this?
> > Anyone who can solve this conundrum gets a batch of my wife's home-
> > made cookies!- Hide quoted text -
> - Show quoted text -
That's for the help. I think having a read-only login is probably a
safe way to go. The only reason I asked was because of this article
that I found earlier. I don't quite understand Report Server Model's
yet... but I get the feeling it's something for Report Builder, and
not for Report Designer (VS).
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/2aef6082da0ab4a4/8db0b06920500fc2?lnk=gst&q=data+source&rnum=6#8db0b06920500fc2