What happened to my dataset view (SSRS & MS VS 2008)?

Posted on 2010-04-07
Medium Priority
Last Modified: 2013-11-26
I opened up some reports I was working on for use in SQL Server Reporting Services and I can't figure out how to access the datasets I'm using in the reports.

I can see them in the properties box for the tablix and they run properly but the datasets themselves are no longer visible in Server Explorer so I can't change the SQL.

This is driving me crazy and for the life of me I can't figure out what I'm doing wrong.

It's probably something very simple, I'm sure.

Sreenshot attached.
Question by:HarpuaFSB
  • 2
LVL 16

Accepted Solution

Megan Brooks earned 2000 total points
ID: 30066756
Are you new to SSRS 2008? Make sure the report designer has the focus and select View-->Report Data from the menus. The Dataset View tab is gone.

Author Comment

ID: 30110621
I just started using it this week =)

Thanks for the help, that did it.
LVL 16

Expert Comment

by:Megan Brooks
ID: 30116966
You're welcome. I remember what it was like the first time I used the new designer too. :-)

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question