New to SSRS - Where is the Report Designer

Question

I just watched a video regarding the Report Designer. It said to go to Start, Programs, Microsoft SQL Server 2008, Reporting Services, and then select the Report Designer. I'm certain I installed everything, but I do not have this program.

I have VS2008 Professional Version installed and SQL Server 2008.

I can open a Report Project and build a report in VS2008, but the IDE does not look the same. She built a simple report using the designer, pointed it at AdventureWorks2008, and published it.

Is there a difference? Is it a seperate download?

Any suggestions or help is greatly appreciated.

Thanks,

Randy

Answer 1

Report Designer is hosted in the Business Intelligence Development Studio, which is fully integrated with the Microsoft Visual Studio 2008 development environment. If you do not have Visual Studio 2008 installed, SQL Server Setup installs the shell so that you can run Report Designer. For more information, see Reporting Services in Business Intelligence Development Studio.

To use Report Designer, open the Start menu, point to Programs, point to Microsoft SQL Server 2008, and select Business Intelligence Development Studio. After you open Business Intelligence Development Studio, you can open or create a new project template. When you select a Report Server Project, the Report Designer opens. The design surface tabbed windows, and graphical tools appear when you add a report to the project. For more information, see Working with Report Designer in Business Intelligence Development Studio.

http://msdn.microsoft.com/en-us/library/ms157166.aspx

Answer 2

If you installed VS2008 then SQL Server 2008, then you should have some new projects in VS2008 so you can build a Reporting Service.

Otherwise you can go to the Start -> ... -> SQL Server -> Business Intelligence Studio, to design the report.