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

:-)

Answer this question

Reporting services in 2005

dimkaz
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.
Pls help. Pls advice how to view the reports through a web application like report viewer control.

Thanks,
fblair

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
Peter Högström
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
bubbly

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
Rodger Reed
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.
Reporting services in 2005

Answer this question