Cannot create a report - VS 2005/SQL 2005

I cannot seem to create a Report based on an SQL Server 2005 database. The
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :

===================================

Exception of type 'System.Runtime.InteropServices.COMException' was thrown. (Microsoft Visual Studio)

------------------------------
Program Location:
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)

Is anyone else having the same problem
Any help will be appreciated.

Thanks
Sumeet

Answer this question

Cannot create a report - VS 2005/SQL 2005

yuvals
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed Do you work with VB projects and BI projects in the same instance of VS Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert
Drewid
same error here.... anyone got a work around or a fix
Steven Dixon
I downloaded the software. I tried to install it , but it could not be installed due to error:
"Error 1001: The SavedState Dictionary contains inconsistent data and might have corrupted."
I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason.
I removed DXcore , and every thing in reporting service in visual studio 2005 become working well !!!..
Is it a bug in DXcore
Thanks to you and all contributors in that post.
M. Hassan
Mary Koetting
Will do.
However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet

coolash

figuerres wrote:

Albert Yen - MS wrote:

We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed Do you work with VB projects and BI projects in the same instance of VS Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert

I will check this out as I also have Refactor! installed.

the behavior matches my problem, adding new files is the failure point.

what A pain!

I was thinking it was Team Related ( Version contol etc...) but I shall see.

in my case 2 pc's are now fixed!!! Great!!!!

Woody1287
A new version of Refactor! (1.0.30, 12/7/2005) is available which may fix the problem. Give it a try.

-Albert
Ankur Srivastava
Hi
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks
dammy
Updated to the new versions of Refactor and CodeRush - The problem is fixed !
Thanks Albert for pointing the conflict out.
Sumeet
Cano
Hi Albert,
I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet
adrian_sleigh
The latest version of Refactor and CodeRush both is 2.0.1

Both can be downloaded from www.devexpress.com

Sumeet

androidi

Albert Yen - MS wrote:

We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed Do you work with VB projects and BI projects in the same instance of VS Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert

I will check this out as I also have Refactor! installed.

the behavior matches my problem, adding new files is the failure point.

what A pain!

I was thinking it was Team Related ( Version contol etc...) but I shall see.

Cannot create a report - VS 2005/SQL 2005

Answer this question