.NET 2.0, SQL 2005, and REPORTS

[Yin99]

I'm seeking some advice/suggestions on ways to implement reports. I'm
using
..NET 2.0, SQL 2005 as Database, and Visual Studio 2005 as IDE tool.
I've got
a classic Website application that presents users with forms and
stores data
in database. However, What I would like to implement is *exactly*
the kind of feature
Access has with its "Report Wizard". In other words, with the tools
I'm using stated
above, can I easily make some kind of wizard where the user see's all
the fields in the
database (like Access has), selects columns they want, arrange
formats, etc and generate
a report (Just like Access)? I really would like to use built in
Controls, DLL, (e.g. not re-invent
the wheel by writing an advanced .NET C# Class from scratch to do
this).

Any suggestions, ideas, etc? A buddy at work suggested I check into
something called
"Crystal Reports" that it does exactly this. However, I'm already
using .NET 2.0, SQL 2005, VS2005
(latest greatest tools) so ideally O hope these things I'm already
using can do this, but if not I'm open
to suggestions. Thanks a ton for any help!

Yin99

 

[Yin99]

I'm seeking some advice/suggestions on ways to implement reports. I'm
using
.NET 2.0, SQL 2005 as Database, and Visual Studio 2005 as IDE tool.
I've got
a classic Website application that presents users with forms and
stores data
in database. However, What I would like to implement is *exactly*
the kind of feature
Access has with its "Report Wizard". In other words, with the tools
I'm using stated
above, can I easily make some kind of wizard where the user see's all
the fields in the
database (like Access has), selects columns they want, arrange
formats, etc and generate
a report (Just like Access)? I really would like to use built in
Controls, DLL, (e.g. not re-invent
the wheel by writing an advanced .NET C# Class from scratch to do
this).

Any suggestions, ideas, etc? A buddy at work suggested I check into
something called
"Crystal Reports" that it does exactly this. However, I'm already
using .NET 2.0, SQL 2005, VS2005
(latest greatest tools) so ideally O hope these things I'm already
using can do this, but if not I'm open
to suggestions. Thanks a ton for any help!

Yin99

Found Answer - SQL 2005 has Reporting Services

There's even a How-To video here:
http://www.asp.net/learn/videos/view.aspx?tabid=63&id=112