SQL Server Reporting Services

[Guest]

We use SQL Server 2000
We user VS 2005

How can we use SQL Server reporting Services?

Thanks,

 

[Norman Yuan]

For SQL Server2000 Reporting Services, you need a version of VS2003, so you
can installed report desiner ( VS2003 add-on, coming from SQL Server2000 RS)
to design report (unless you can manually write the XML style report RDL
file (theoretically, you can, but you wouldn't want to). VS2005 does not
help at all in this case.

 

[Guest]

VS2005 does not help at all in this case.
Ouch. Don't have 2003.

Hmm. If I downloaded VB Express and SQL Server 2005 Express Edition to my
laptop, could I use Reporting Services there?

Then, could I use the reports I design in VS 2005?

Jon

 

[Norman Yuan]

No, SQL Server2000 reporting services is built on .NET1.1 and its report can
ONLY be desined with VS2003. because VS2003 uses .NET1.1, while VS2005 uses
..NET2.0. You may have to go do eBay do find a version of cheap VS2003.

VS2005 itself comes with report designer, that allows you to design report,
which could be used with or without SQL Server2005 reporting services. If
you have SQL Server2005, it comes its on report designer, which is better
than VS2005 built-in one. However, if you have VS2005 installed, when
installing SQL Server2005 Reporting services' report designer, it will be
merged into VS2005.

if you need to learn SQL reporting services, but can only work with VS2005,
then you can download SQL Server Express Advanced edition, which has
reporting services.