"James_101" <James101@discussions.microsoft.com> wrote in message
news:93E0E222-0082-43E0-9418-B784FCFD0A36@microsoft.com...
>I develop intranet-based training that connects to a database. My training
> products are sold to customers. Because of a large customer, I am trying
> to
> replicate the Access database (used in the past) to SQL Server.
>
> I develop and test the training piece-database on my desktop running Win
> XP
> Pro. For testing, I put the training system in the wwwroot folder of IIS.
> All works well.
>
> I obtained the developer edition of SQL Server 2000 and installed it and
> service pack 4. I created a named instance, a new database and a table.
> I
> also modified the connection strings in several asp pages so the training
> piece can send SELECT, UPDATE and ADD SQL commands to the SQL Server
> database.
>
> I also need to print a report using data from the database. Since SQL
> Server
> seems to have limited printing capabilities, I think that I need to
> install
> Reporting
> Services. The Developer Edition came in a 3 CD pack: SQL Server 2000
> Dev
> Ed, Svc Pack 3a and SQL Server 2000 Reporting Services. In preparing to
> install Reporting Services, I learned that I will need Visual Studio.Net
> 2003
> in order to have Report Designer. My questions:
>
> 1. Do I need Report Designer to put together a printed report?
> 2. Although the developer edition costs only $50, it appears that Visual
> Studio.Net costs $800 or more. Is there a less expensive way to obtain
> the
> tools I need to develop a printed report for my SQL Server database?
> 3. Is there a primer on Reporting Services for new users?
>
> Thanks.
>
> Jim

"James_101" <James101@discussions.microsoft.com> wrote in message
news:2D61488E-D89E-4112-9D95-79F6EC68466A@microsoft.com...
> Thanks for the help Bruce. Based on other discussion threads that
> suggested
> that Visual Studio 2003 would work with SQL Server 2000 but not Visual
> Studio
> 2005, I ordered Visual Basic.Net 2003 Standard Edition rather thatn VB.Net
> 2005.
>
> You mentioned a fair number of books. I seek to learn only what's
> necessary
> to design a printed report using data from my SQL Server 2000 table. Do
> you
> recommend any specific learning resources?
>
> Jim
>
> "Bruce L-C [MVP]" wrote:
>
>> You need any version of VS 2003, the cheapest way to get it is to
>> purchase
>> VB.Net ($100). There are a fair number of books out there that are pretty
>> decent to get you started.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "James_101" <James101@discussions.microsoft.com> wrote in message
>> news:93E0E222-0082-43E0-9418-B784FCFD0A36@microsoft.com...
>> >I develop intranet-based training that connects to a database. My
>> >training
>> > products are sold to customers. Because of a large customer, I am
>> > trying
>> > to
>> > replicate the Access database (used in the past) to SQL Server.
>> >
>> > I develop and test the training piece-database on my desktop running
>> > Win
>> > XP
>> > Pro. For testing, I put the training system in the wwwroot folder of
>> > IIS.
>> > All works well.
>> >
>> > I obtained the developer edition of SQL Server 2000 and installed it
>> > and
>> > service pack 4. I created a named instance, a new database and a
>> > table.
>> > I
>> > also modified the connection strings in several asp pages so the
>> > training
>> > piece can send SELECT, UPDATE and ADD SQL commands to the SQL Server
>> > database.
>> >
>> > I also need to print a report using data from the database. Since SQL
>> > Server
>> > seems to have limited printing capabilities, I think that I need to
>> > install
>> > Reporting
>> > Services. The Developer Edition came in a 3 CD pack: SQL Server 2000
>> > Dev
>> > Ed, Svc Pack 3a and SQL Server 2000 Reporting Services. In preparing
>> > to
>> > install Reporting Services, I learned that I will need Visual
>> > Studio.Net
>> > 2003
>> > in order to have Report Designer. My questions:
>> >
>> > 1. Do I need Report Designer to put together a printed report?
>> > 2. Although the developer edition costs only $50, it appears that
>> > Visual
>> > Studio.Net costs $800 or more. Is there a less expensive way to obtain
>> > the
>> > tools I need to develop a printed report for my SQL Server database?
>> > 3. Is there a primer on Reporting Services for new users?
>> >
>> > Thanks.
>> >
>> > Jim
>>
>>
>>