Failure to Open the Exisitng report (.rdl file)using Report Builder

I have installed TFS Beta 3 (Dual Server Mode)
Created New Process Template.
Creating Team project using the process template.

Open the report site from the Repots node in TFS Explorer in the Team project node.

Clicked Report Builder.

Trying to open existing .rdl file using "Open From File", i am getting following error.

Cannot Open this Item.
This report cannot be opened in the report builder

One or more unexpected Report Definition Language (RDL) elements of the following type have been removed: DataSet

One or more unexpected Report Definition Language (RDL) elements of the following type have been removed: DataSet

Thanks

V

[756 byte] By [VarunD] at [2007-12-17]
# 1
Hi,

All of the reports that are shipped with Team Foundation Server are built with Report Designer. The Report Builder application only works with reports that were built with Report Builder. For some background, here is a quick comparison of the two tools:

Report Designer: Gives you full control of every aspect of the report, and requires the Report Designer (hosted in Visual Studio) to be installed for editing reports.

Report Builder: A .net "click-once" appliation that can be used to create common classes of reports, but without detailed control over appearance, formatting, and calculations to the extent you get in report designer.

You can edit Report Builder reports in Report Designer, but not the other way around.

If you would like to open the TFS reports, install the SQL Client Tools, save the Report Files to your local disk, and add them to a "Report Server Project". Then you will be able to see and edit the report defintions.

Thanks,
tom

TomPatton at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...
# 2

Hi,

What is Report Designer and part of what product? Also, how do you create a Report Server Project?

Thanks,

rupakg at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...
# 3

Rupak,

The report designer is a component that can be installed with SQL server. It is build on the Visual Studio IDE and enables you to create projects relative to Analysis services, reporting services and integration services(just like you would create a C# project...).

Check out this link for more information: http://msdn2.microsoft.com/en-us/library/ms173767.aspx

Thanks,
Othmane

OthmaneRahmouni-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...
# 4

Sorry for the late response.

Thanks for the information.

Varun

VarunD at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...
# 5

Tom,

I have extracted the .rdl files from the MsfAgile_new.zip file to my local hard drive. When I try to Preview the Work Items.rdl report in Report Designer I get the following message:

An error occurred during local report processing. The item /TfsReportDS can not be found.

What other set up do I need to do to preview the report in Report Designer on my local box?

Thanks,

Erik

ErikReiter at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...
# 6

Erik,

Did you create a new report project and added the 2 datasources(TfsReportDS & TfsOlapReportDS) to the project as well as the reports?

Thanks,
Othmane

OthmaneRahmouni-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...
# 7

Othmane,

I want to make sure that when I am done editing the existing report I can replace the existing one and I wanted it to use the same shared datasource that is already on the server (i.e. the one that you find in http://MyTFServer/Reports/Pages/Folder.aspx).

Do you know how I configure my local machine so when I republish and overright the existing report it will used the datasources on the server and not create new ones?

Thanks,

Erik

ErikReiter at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...
# 8

Erik,

You will need to set the OverwriteDataSources property to false under the report project Deployment properties(you can access these by right clicking on the report project and selecting Properties)

Thanks,
Othmane

OthmaneRahmouni-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...

Visual Studio Team System

Site Classified