Home > Ask the SQL Server Experts > Eric Johnson - SQL Server 2005 and Reporting Services Questions & Answers > Run SSRS with SQL Server Business Intelligence Development Studio
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

Run SSRS with SQL Server Business Intelligence Development Studio

Eric Johnson EXPERT RESPONSE FROM: Eric Johnson

Pose a Question
Other SQL Server Categories
Meet all SQL Server Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 17 October 2007
Assuming I have SQL Server, what else do I need to run the report designer for Reporting Services and the Business Intelligence Analyzer? It sounds like the Visual Studio environment hosts these tools, but what version of Visual Studio is required: Express, Standard or Professional? In other words, what do I need to buy after SQL Server to design reports for SQL Server Reporting Services?

>
EXPERT RESPONSE
All you need to create reports for SSRS is the SQL Server Business Intelligence Development Studio (BIDS), which is basically Visual Studio with only the SQL Server components installed. The good news is that BIDS comes with most versions of SQL Server. If you have the client tools installed you will have BIDS.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
SQL Server data warehousing/business intelligence
Manage traces in SQL Server 2005 Analysis Services with XMLA commands
Tutorial: SQL Server 2005 Analysis Services
Top 10 SQL Server Integration Services (SSIS) and DTS tips
Open SSIS packages without validation using these SQL properties
How to process SQL Server 2005 Analysis Services for data availability
Export SQL Server data to an Excel file using SSIS and Visual Studio
Five steps to event handlers in SQL Server Integration Services (SSIS)
Workaround to Reporting Services error in SQL Server Express
Optimize SAN setup for improved SQL Server performance
Table partitioning with SQL Server 2005

Eric Johnson - SQL Server 2005 and Reporting Services
How to insert into SQL Server system tables
Set up a SQL Server disaster recovery site
Installing SQL Server native client
Deploy reports from Reporting Services on webpage
Connect to SQL Server database with Visual Basics
Just installed SQL Server 2005 Express can't find database
Migrating SQL Server applications after upgrade

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
data aggregation  (SearchSQLServer.com)
data preprocessing  (SearchSQLServer.com)
data warehouse  (SearchSQLServer.com)
FileMaker  (SearchSQLServer.com)
GIS  (SearchSQLServer.com)
MOLAP  (SearchSQLServer.com)
pivot table  (SearchSQLServer.com)
Quiz: SQL Server 2000  (SearchSQLServer.com)
SQL  (SearchSQLServer.com)
T-SQL  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts