Search Wiki:
Article Translations
English, Français, Deutsch, Italiano, 한국어, 繁體中文, 简体中文, 日本語, Русский, Português (Brasil)

Description
A Hotfix is a product update package with one or more updated product files that fix a specific product problem.

IMPORTANT NOTE

Please be aware this Hotfix has not gone through full Microsoft product regression testing nor has it been tested in combination with other Hotfixes.

Please carefully review the associated Hotfix KB article to verify the fix is the one needed and there are no known compatibility or installation issues. You may also want to contact a Microsoft Support Professional at http://support.microsoft.com

Issue Description

KB947173 FIX: The DataSets panel is not available in the report designer when you open a SQL Server Reporting Services 2005 RDLC file in Visual Studio 2008


In Microsoft Visual Studio 2005, when you double-click a SQL Server Reporting Services 2005 RDLC file, or right-click the RDLC file and choose "Open with | Microsoft Visual Studio 2005", you see the RDLC design window and a DataSets panel that allows you to drag-and drop the fields onto the report design surface.
If the DataSets panel is closed, you can re-open it via one of three mechanisms:
ALT + SHIFT + D
The Show DataSources button on the Data Design toolbar
The Data | Show Data Sources menu

In Visual Studio 2008, the DataSets panel is not available and none of the methods described above allow you to open it:
The hot-key sequence does not work
There is no Show Data Sources item on the Data menu
The Show Data Sources toolbar button is greyed out
Note: You can still access the field names via the expression editor.

Additional Information about the issue resolved by this Hotfix can be found in its Knowledge Base article at http://support.microsoft.com/kb/947173

Additional Hotfixes
Search the list of all other publicly available Visual Studio and .NET Framework Hotfixes at http://archive.msdn.microsoft.com/Project/ProjectDirectory.aspx?TagName=Hotfix&ProjectSearchText=Hotfix*

Last edited Jun 23 2008 at 7:31 PM  by codegalleryadmin, version 9
Comments
vladimir_khazin wrote  Jun 25 2009 at 1:31 PM  
Left Ctrl-Alt-D (letter D not delete button) will open the DateSet panel when rdl is open in design view and it only works every other time or so :-)

MLorenat wrote  Jul 10 2010 at 6:06 PM  
This Symptom presents when Designing with RDLC. Hotfix applied to my VS 2008 did not repair the "intermittent" problem. After much experimentation, it appears that (1) When the "Website Data Sources" pane displays "Datasets", it also displays other details from DLLs located in the \website\bin\ folder; for example, AjaxControlToolkit and the dependent Project DLLs; (2) even when the Project DLLs have all been created (by rebuilding website) with their dependencies AND ALL WORK at runtime, apparently, the algorithm that populates the "Website Data Sources" pane cannot correctly determine dependencies at "design time" -- so

Symptoms are
(a) No content in "Website Data Sourcs"
(b) When Report | Data Sources... menu is clicked (in Report Designer), a message like "Could not load file or assembly 'SPDB ...' or one of its dependencies....
Where "SPDB" is name of one of the several Projects.

Workaround is to delete all Project-related DLLs from website/bin folder and create/design reports in that state.

IF THERE IS any more thorough documentation at Microsoft for how these features are supposed to work, I could probably have figured out the problem much sooner - rather than chewing up better part of 3 days.

NOTE also that (in experimenting with a new project), ALL RDLCs created in VS Studio 2008 are based on SQLServer 2005 as far as I can tell: xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"

Please advise if you would like to hire me for further consultations - or let me know if my diagnosis is Dead Wrong?

cheers,
ML

Updating...
Page view tracker