Friday, March 30, 2012

New to Reporting Services

hi
I am new to reporting services of SQL Server. I just read an article about
it. In our organization, we are using Crystal Reports to develop reports for
our system. Backend is of course SQL Server 2000.
Can anyone please guide me that from where I should start to explore this
new technology?
Also is it necessary to use the reporting services of SQL Server 2000 via
VS.NET 2003 or can my VB 6 application develop the same kinds of reoprts?
Thanks in advance.
Syed Hussain Itiba NaqviI would purchase the book "Hitchiker's Guide to SQL Server 2000 Reporting
Services."
You can get a good deal at www.BookPool.com
David
"Syed Hussain Itiba Naqvi" <Syed Hussain Itiba
Naqvi@.discussions.microsoft.com> wrote in message
news:6E7B4BEB-9417-448F-B430-D29411BA114D@.microsoft.com...
> hi
> I am new to reporting services of SQL Server. I just read an article about
> it. In our organization, we are using Crystal Reports to develop reports
> for
> our system. Backend is of course SQL Server 2000.
> Can anyone please guide me that from where I should start to explore this
> new technology?
> Also is it necessary to use the reporting services of SQL Server 2000 via
> VS.NET 2003 or can my VB 6 application develop the same kinds of reoprts?
> Thanks in advance.
> Syed Hussain Itiba Naqvi|||Syed,
Reporting Services comes in two parts.
1. The Server
2. Development Tools.
Ideally The Server components need to be on the same box as a SQL instance
(if you want to run it under the same license - see licensing for further
details) and the same box should have Web Server on also. RS uses the SQL
instance to store it's two new DBs to run the service.
The Development tools can be loaded onto any development machine, but
require VS.NET 2003. Once installed it adds Business Intelligence Projects to
the available solutions, and the Report Designer runs inside of VS.NET IDE
(as does the Crystal designer).
The cool thing about the designer is that you can preview (in like
real-time) the report results from inside the IDE, and also, by deploying it
to your localhost, you can see how the Reporting Server will handle it also,
all prior to deploying it to the 'real' server.
two books to get: Professional SQL Server Reporting Services - WROX and
Step-by-Step SQL Server 2000 Reporting Services - Microsoft. These two books
hold so much instructional info for the beginner.
Also, contact your local Microsoft Area Rep, they will assist you greatly. I
did, and they web-demo'd the technology to myself and my Managers during a
conference call. They have been excellent and very supportive.
Hope this assists,
Tony
"Syed Hussain Itiba Naqvi" wrote:
> hi
> I am new to reporting services of SQL Server. I just read an article about
> it. In our organization, we are using Crystal Reports to develop reports for
> our system. Backend is of course SQL Server 2000.
> Can anyone please guide me that from where I should start to explore this
> new technology?
> Also is it necessary to use the reporting services of SQL Server 2000 via
> VS.NET 2003 or can my VB 6 application develop the same kinds of reoprts?
> Thanks in advance.
> Syed Hussain Itiba Naqvi

No comments:

Post a Comment