Where do I start with reporting services in SQL Server 2008 R2

Question

Hi All,

I have installed Visual Web Developer Express 2010, and SQL Server 2008 R2 Express with advanced services.

How can I write reports to use with reporting services?

Do I need to install Visual Studio C# Express 2010 for instance?

Thanks.

Answer 1

There is a step for configuring reporting services first. Such as permissions etc.

http://www.mssqltips.com/tip.asp?tip=1453

This will get your reporting services working so then you can begin to create/upload reports.

Answer 2

Report builder is generally a power end-user application. When you installed SQLServer 2008 R2 there should have been an option to also install the Business Intelligence Development Studio (BIDS). BIDS is essentially a very light-weight installation of Visual Studio.

Once that suite is installed you can navigate through your start menu to BIDS and create a new reporting services project.

As mentioned by Russell if you're developing against a locally running instance of SSRS, additional configuration might be necessary.