Express Reporting Services

I've installed SQLEXPR_ADV.EXE and SQLEXPR_TOOLKIT.EXE. Was able to reattached my own DB's and everything seems to be working fine, but....

I used reporting services extensively in SQL 2000 and would love to play with the express version. My problem is, I don't know how to access. I tried opening ReportBuilder.exe but get an error indicating "Report Builder and Report Models are not supported in this version of Reporting Services"...

I have XP Pro and there is a Reports and ReportServer under the default web sites. Do you have to have Visual Studio to utilize?

Any help would be appreciated...

Thank you...

Danno

You need to use the Business Intellegence Developer's Studio, which is installed with the SQL Express Toolkit to design your reports. It should be listed on the Start menu with the other SQL tools.

Mike

|||

Thanks Mike, there is a line item called "SQL Server Business Intelligence Development Studio". When I try to access (double-click) I get the message "Windows is searching for devenv.ext. To locate the file yourself, click browse". I did a search on my entire hard drive for devenv.exe, but it is no where to be found. I tried reinstalling the Toolkit, but get a message that I didn't change anything so nothing was installed. I made sure the BI option was chosen.

I'm assuming that the BI Deve Studio is part of SQLEXPR_TOOLKIT.EXE, is this correct. Any ideas on what I can do to get the BI Dev Studio installed?

Thank you,

Dan

|||

We are facing exactly same problem as Dan has mensioned above. We have tried installing SQLexpress with advanced feature and the tool kit on three different machines and behaviour is same. We are not been able to use Reporting services with SQL2005express. Please help.

Prashant