473,769 Members | 3,350 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Sql server report

Does SQL server have any build in generated report function ? or like
pivot tables for analysing data ? Pls advise.

Rgds
Daniel

Mar 28 '06 #1
4 1658
Daniel (Da*********@gm ail.com) writes:
Does SQL server have any build in generated report function ? or like
pivot tables for analysing data ? Pls advise.


SQL Server comes with a component called Reporting Services with which
you can create reports.

There is also Analysis Services where you can create cubes and all
that.

I've not used any of these components myself, so I can't give more details.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 28 '06 #2
I'm using sql server 2000 personal edition but not seeing this
component ? where is it?

Regards
Daniel

Erland Sommarskog wrote:
Daniel (Da*********@gm ail.com) writes:
Does SQL server have any build in generated report function ? or like
pivot tables for analysing data ? Pls advise.


SQL Server comes with a component called Reporting Services with which
you can create reports.

There is also Analysis Services where you can create cubes and all
that.

I've not used any of these components myself, so I can't give more details.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Mar 29 '06 #3
Daniel (Da*********@gm ail.com) writes:
I'm using sql server 2000 personal edition but not seeing this
component ? where is it?


Reporting Services does not come with SQL 2000, of the simple reason that
Reporting Services was not released until 2003.

You can download the Evaluation Edition here
http://www.microsoft.com/downloads/i...splayLang%3den

I don't know the exact procedures to get a copy of Reporting Services
for real, but I am fairly confident that it is include in the regular
license for SQL 2000. Whether it actually runs on Personal Edition, I
don't know.

I would suggest that you contact your local Microsoft representative
for the commercial details.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 29 '06 #4
Regular license means standard edition ? can get it to work in sql 2000
personal edition anyway ?

Rgds
Daniel

Erland Sommarskog wrote:
Daniel (Da*********@gm ail.com) writes:
I'm using sql server 2000 personal edition but not seeing this
component ? where is it?


Reporting Services does not come with SQL 2000, of the simple reason that
Reporting Services was not released until 2003.

You can download the Evaluation Edition here
http://www.microsoft.com/downloads/i...splayLang%3den

I don't know the exact procedures to get a copy of Reporting Services
for real, but I am fairly confident that it is include in the regular
license for SQL 2000. Whether it actually runs on Personal Edition, I
don't know.

I would suggest that you contact your local Microsoft representative
for the commercial details.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Mar 30 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1935
by: sztonix | last post by:
Hi all, I encountered a crystal report deployment problem. I make reports with Crystal Report for Visual Studio .NET 2003. It works fine in the development machine. And then make setup package. Installed on a windows server 2003 system (without visual studio .net 2003), the report gives error about "Logon Failed". The data source is specified to OLE DB SQL Server, and the LogOnInfo is specified by
4
8208
by: Sam Fisher | last post by:
Hi, I have a crystal reports hosted on the IIS as web service. Everything works fine except that I can not access the database other than the one on which the report originally created. I am using the LogOnInfo of the viewer to set the user name, password, database location and server names But the following kb article says 'When using the viewer's LogOnInfo collection, you are unable to change the database/table information for a report...
7
6422
by: rickcheney | last post by:
I just changed my Access 2002 database to a SQL Server ADP project. I had a form where the user entered a value into a text box and when a command button on the form was clicked a Report was opened. The reports record source is a query. The query uses the value from the form text box to restrict the query. Table name = EggsTable one of the columns in the table is named: EggColor Form name = EggColorForm Form text box name = ColorTextBox
1
2239
by: Krish | last post by:
Hi, I tried to Develop one Report in SQL Reporting Service. I have installed SQL Reporting Serivice in Windows 2003 machine. SQL Server Database is in another machine, running on Windows 2000. I developed and deployed the report and all went fine. When I tried to see the report through the Report Service Manager Web Page it is comming properly. But When I tried to See the report in another web page, I'm not able to see the images. But...
0
1478
by: Das | last post by:
Hi everyone, I have been using crystal report with visual basic 6. I know with crystal report & sql server, if there is a different server name than the one you created report. It prompts as Unable to Logon server. I used to use the following code in vb6 which worked perfectly fine with vb6 to connect to any server. Dim tlb As CRAXDDRT.DatabaseTable
8
3120
by: Brendan Reynolds | last post by:
I'm trying to integrate SQL Server Reporting Services reports into an ASP.NET app (SRS 2000, ASP.NET 1.1). I know how to do this using direct URL addressing, but this exposes in the query string parameters that should not be exposed. Each user is associated with a school, and should see only that school's data. When the user logs in, I retrieve the SchoolID associated with that user, and that SchoolID is used as a parameter in all stored...
8
2753
by: Woody Splawn | last post by:
I am asking this question here because I asked this question in the Reporting Services Newsgroup and did not get an answer. Does anyone know if Reporting Services is intended to work in a client/Server or Local machine environment? Based on what I have seen my guess is yes but that is a guess. In some materal it talks about it running on a web server but my supposition is that this does not necessarily mean that it would not make for a...
1
2939
by: pmkconsulting | last post by:
Hello, I am using an asp script that uses rptserver.asp to display some reports over http. It worked fine previously but now the webpages with the report display just hang. I tried switching from the activex viewer to java viewer and still the same. I don't know what changed, except I do the Windows updates. Can anyone tell me the best way to trouble ASP problems. The page just stays blank forever and that status bar slowly progresses. No...
1
2253
by: =?Utf-8?B?Y2hhaXJtYW4=?= | last post by:
I am trying to set up a Report Server to publish reports that I have created in Visual Studio 2005. I have been able to get it up and running and I am able to access reports via the web and set up another user. The other user can log on and see the reports available but when he runs then it begins to run the report then throws the error below. I have tried looking in the virus software logs to see if it is being blocked but that doesn't...
0
9590
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9424
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10223
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8879
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7413
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6675
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5448
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3968
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3571
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.