Reporting services in 2005

Hi,

How do i get the "Data" "Layout" and "Preview" tabs in the report designer like displayed in Brian Welckers video "Report Authoring Tips and Tricks"

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml

When I add a report to my project, all I get is the layout view.

When I click the menu Reports -> Data Dources, all I get is a list of my DataSources from my main project, I have no ability to Add a SQL server source, or OLEDB source, or even write a SQL statement like in the video.

Did I miss something I need when installing?

:-)It sounds like you need to install the "Workstation Components" from the SQL Server 2005 disk on the dev machine you're working on. A quick way to check is to look for the Business Intelligence Projects in the Add New Project dialogue, if it's not there, you need to install them.|||

When you use Visual Studio 2005 and SQL Server 2005 Reporting Services together, you have 2 options for desiging reports:
1) Using the WinForms or WebForms ReportViewer control in you application.
2) Using the Report Designer that installs with the workstation components of SQL Server 2005.

For #1 - you're actually adding an embedded report to your application. You need to provide data to the report that you author. This is the cause you're running into.

For #2 - if you want to publish a report to the report server, Peter is right, you'll need to install the Report Designer. The report designer includes the 3 panes for data, layout, and preview that you are accustomed to see in SQL Server 2000 Reporting Services.

Hope that helps,
-Lukasz

|||hello,
I have VS2005 installed along with RS 2000. I have developed reports using the report wizard. I have also uploaded the reports to the report server which is in a different location.
Now, my problem is when i use report viewer control to access the reports in the report server, I get this error message.

The

attempt to connect to the report server failed. Check your connection

information and that the report server is a compatible version.

The

request failed with HTTP status 404: Not Found.|||

Hello,

I do have designer installed, but still it's abig difference between Woelcker's Training Designer Screen and mine.

For example, I don't see the image of the tables and joins.

Thanks,

Seva Akkerman

|||I just watched (a lot of) this video. When he set his list to be multi-value, his preview rendered with the select all.

In mine, I can set a multi-value parameter; but it won't show up until I deploy to the server.

Does anyone know what causes that?