Team Foundation Server - Reporting & Warehouse,18 - Visual Studio Team System,
Recent update: 2008-3-21

Report View in TSWA Displays HTML Tags

1018 byte By Trevor at 2008-3-11
Using Visual Studio Team System Web Access we create a bug or an issue.I then click on this issue/bug (which opens in a new window - call this Window #1) and select "Tools" - "Report View" (which opens another new window - call this window #2) and rather then displaying the forma...

Reports using customized Workitems

504 byte By jalekz at 2008-3-7
Hello TFS users.I′m tring to custimize the MSF Agile Process Template.I′ve added fields to the WorkItemDefinitions (like Role) and also added new WorkItemDefinitions with new fields.My problem is this:Now i want to generate Reports for the WorkItems, using the new fields in the query.for ...

Bug Rates Report - Getting very weird report

917 byte By rternier at 2008-3-6
The report "Bug Rates" used to work great. It shows us how many Work Items were in the System, how many were resolved, new active etc. (the way it should). I exported 250 Work Items from one of our products as a trial for TFS, threw them into Excel, and published. This worked great. The Report ...

Using Excel pivot charts, can I filter on creation dates within the Work item history cube.

795 byte By B.Huard at 2008-3-5
Hello, I am using the cumulative count in Work item history cube using the Pivotchart within Excel (a great way to get quick graphs for management). The problem I am having is that I want to see the progression of states between specific dates. As it stands now I can choose specific weeks to ...

How the change in the data of Cube will be reflected?

512 byte By vinodsingh at 2008-3-3
Hi, All I have created one Cube and generated reports in SQL SERVER 2005. Now I have done sone changes in the the tables of Data source view of the cube. But it is not reflecting in the data of Cube. I have used proccessing the cube but its showing error while running. Please any body help me ...

Report not showing in Team Explorer

846 byte By kevinj at 2008-3-1
If I log in as TFSSetup I can create a report and deploy it. That report shows up on the report site and in Team Explorer. However I have another account which is simply a domain member. This account is in the Content Manager role and has access to TfsWarehouse. I've given the account ...

Date validation

187 byte By BrianPatrick at 2008-2-28
How would you go about adding date validation in TFS reports? For instance, I'd like to ensure the "start date" parameter is an earlier date than the "end date" one.

Restoring reports for a team project

245 byte By PawanSingh at 2008-2-27
Hi We have a team project which was created using Beta 1 or 2 or TFS. We have now upgraded to RTM and none of the reporting links for this team project's web site work. Is there a way to restore these reporting links? Thanks Pawan

Reports not accessible through project portal by remote user

898 byte By wmdpt at 2008-2-26
I have installed VSTS - Application Tier and Data Tier on seperate machines.The Application Tier has been connected to LIVE IP. I am trying to access the reports via the project portal.( http://(liveip)/sites/teamproject/) Everything else is accessible, except the reports section. It shows ...

Missing TfsReportDS and TfsOlapReportDS

5316 byte By EdJarrett at 2008-2-25
Some time ago I noticed that the Reports folder in Team Explorer had a red x in the lower right hand corner and would not expand to show reports. Since I was not really using them yet I just ignored this error. Today I tried to create a new project and received this error. Error TF30004: ...

How to connect to Database?

223 byte By ShimonSim at 2008-2-24
How do I get connection to the databases that Team System are using? I went to Report Server and copied settings from shared connection but still can't connect. Any ideas? Thanks Shimon

rsRenderingExtensionNotFound

159 byte By EPUser at 2008-2-23
Marino recomended that i delete the value "format='Default'" on tag cc1where can i find this, i am sorry i am just a beginner Thanks

The synchronization issue of the reporting

288 byte By LeonZhu at 2008-2-22
Hi all, I just add a bug in my project. But when I launch the "Bug Rate" report, I cannot see this happening. Is there any synchronization design in the reporting feature? Or, how can I see the data in the report in a synchronized way? Thanks, Leon

Error in Reporting

6972 byte By chittark at 2008-2-22
Hi TFS Users, I am working on TFS with the following versions installed.. TFS -- RTM Version SQL -- SQL Server 2005 Evaluation Version Team System -- RTM Version When i try to executes Reports (TeamProject -->Reports-->Builds) from Team Explorer i am getting the following message..[There ...

Improper Display in ReportViewer

495 byte By unninxt1 at 2008-2-21
hi , I created many reports in sql reporting and i found out that when i display these reports in reportviewer some of them is not in a proper format. But when i export it i get properly in pdf. so is there any work around or ways to display the reports properly similar to the reports i view ...

Churn report

309 byte By ShimonSim at 2008-2-20
I heard that it is posible to do a churn report in Team Systems from build to build. I started looking on the web and saw some nice charts that demonstate that. I didn't find that report in list of reports. Is there a predefined one? If not how can I make one? Thank you, Shimon ...

rsRenderingExtensionNotFound

159 byte By EPUser at 2008-2-20
Marino recomended that i delete the value "format='Default'" on tag cc1where can i find this, i am sorry i am just a beginner Thanks

How to connect to Database?

223 byte By ShimonSim at 2008-2-19
How do I get connection to the databases that Team System are using? I went to Report Server and copied settings from shared connection but still can't connect. Any ideas? Thanks Shimon

Churn report

309 byte By ShimonSim at 2008-2-18
I heard that it is posible to do a churn report in Team Systems from build to build. I started looking on the web and saw some nice charts that demonstate that. I didn't find that report in list of reports. Is there a predefined one? If not how can I make one? Thank you, Shimon ...

Filter using parameter for dates

3100 byte By DougInGeorgia at 2008-2-17
========================================== Update: Please see the post dated 9/28/2006 for a new request for help. ========================================= I have a need to report developer hours by work item by week. I am attempting to use the warehouse filed "Current Work Item ...

How to accss Symptom and StepsToReproduce fields in Report Builder

638 byte By JamesVSTS at 2008-2-16
I am using the SQL Server Business Intelligence Development Studio tools to generat a new RDL report that I can upload to the server but I cannot access the Microsoft.VSTS.CMMI.Symptom or Microsoft.VSTS.CMMI.StepsToReproduce fields. I noticed that these fields are of type "Html" where ...

How to force Repository Refresh?

167 byte By LucasC at 2008-2-15
Hi, is there any way to refresh the repository on demmand or the only way to do something like that is to set a small refresh time? Thanks a lot

Failed to load adapter

3451 byte By janko at 2008-2-15
Hi, please help me, I permanently got the following message: TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date ...

reports not showing up on home page

301 byte By RomanT at 2008-2-15
Hi, Am trying to understand why Remaining Work stays empty on the home page of the team portal. If I go to modify the web part - and hit 'test link', the report loads up flawlessly, although it doesn't show up by itself WITHIN the webpart. any ideas? thanks ...

Improved - added ID and filter out Work Completed = 0

3100 byte By DougInGeorgia at 2008-2-15
========================================== Update: Please see the post dated 9/28/2006 for a new request for help. ========================================= I have a need to report developer hours by work item by week. I am attempting to use the warehouse filed "Current Work Item ...

TFS Analysys Services service stops all the time

2367 byte By matiaswoloski at 2008-2-15
The Event log is logging this error; The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the ...

SubReport ReportItems

203 byte By unninxt1 at 2008-2-14
hi all, i ve created a report in which i call a subreport now my issue is i want to access the reportitems of the subreport. is there any way to do it? please help me out of this situation

Thanks!

3100 byte By DougInGeorgia at 2008-2-14
========================================== Update: Please see the post dated 9/28/2006 for a new request for help. ========================================= I have a need to report developer hours by work item by week. I am attempting to use the warehouse filed "Current Work Item ...

The synchronization issue of the reporting

288 byte By LeonZhu at 2008-2-13
Hi all, I just add a bug in my project. But when I launch the "Bug Rate" report, I cannot see this happening. Is there any synchronization design in the reporting feature? Or, how can I see the data in the report in a synchronized way? Thanks, Leon

What is the formal definition of Priority and Severity in VSTS

486 byte By LeonZhu at 2008-2-13
Hi all, As the subject, what is the definition and their respective usage/focus, from VSTS's view? Any formal document? Also, in the report service, I only see "Bugs by Priority", not "Bugs by Severity". Does MS VSTS think that priority is more important than severity ...

Can I customize the VSTS bug report?

276 byte By LeonZhu at 2008-2-12
Hi all, I want to customize the VSTS bug report: Bug Rate, and Bugs by Priority. Currently, these two reports are based on daily data. And I want to create the corresponding reports by weekly data. Any approach to realize it? Thanks, Leon

Why there is a fork icon in my report folder?

286 byte By LeonZhu at 2008-2-11
Hi all, I have a test project and I am the one to create the team project and the test project. In the Team Explorer, I find that there is a fork icon on the Report folder, and I cannot use the Report functions. What's wrong? How to solve it? Thanks, Leon

Error in Reporting

6972 byte By chittark at 2008-2-10
Hi TFS Users, I am working on TFS with the following versions installed.. TFS -- RTM Version SQL -- SQL Server 2005 Evaluation Version Team System -- RTM Version When i try to executes Reports (TeamProject -->Reports-->Builds) from Team Explorer i am getting the following message..[There ...

Error when trying to display a report

316 byte By MichaelSabbag at 2008-2-10
Hi, I'm trying to create a new custom report in studio 2005 (Report server project). When the wizard in finished, I'm trying to run the report and get the following error: An error .. during local report processing 'system.outofmemoryException'.. Thanks, Michael ...

Error executing reports in RTM Trial

577 byte By GilesNutkins at 2008-2-8
I have been evaluating the Team Foundation Server Beta Refresh 3 without any problems, but have recently installed on a new server the RTM Trial Version, but the reports don't work, so this is not an upgrade. For report Bug Rates: An error has occurred during report processing. ...

Error Executing reports

549 byte By GilesNutkins at 2008-2-8
I have been evaluating the Team Foundation Server Beta Refresh 3 without any problems, but have recently installed on a new server the RTM Trial Version, but the reports don't work. For report Bug Rates: An error has occurred during report processing. (rsProcessingAborted)Query execution ...

Report Checked Out Items and Changed Items

198 byte By SimonGorski at 2008-2-7
Hi, Where can I find a list of all Source Control checked out items? Where can I find a list of all Source Control changed items between two dates? Regards Simon

Creating an OLTP datasource for writing reports

1384 byte By BerndWechner at 2008-2-7
As suggested on: http://msdn2.microsoft.com/en-US/library/ms159161(SQL.90).aspx I created a new data source which I have called TfsOltpReportDS and which uses the Microsoft SQL Server connection type and the following connection string: data source="(local)";initial catalog=MyProject However I ...

Unable to generate a model from the OLAP datasource

1385 byte By BerndWechner at 2008-2-7
I have generated a model from the TfsReportDS datasource and I can write reports with that. If however I try to generate a model from the TfsOlapReportDS I get the following error: SQL Server Reporting ServicesError An error occurred while generating model. (rsModelGenerationError) Get Online ...

Permissions Question with Reporting Site

619 byte By EdAbshire at 2008-2-7
I have a question concerning the setup of permissions on my SQL Reporting. In order for someone to create a project in TFS, they must have Content Manager access, understand this, not a problem. The problem is that I have to add individual users to security settings, a group of users won't ...

Issues List is not working

732 byte By compilator at 2008-2-6
My Issues List is not working :( So I tried to make a new one. I opened the "Work Items" report from the SQL Server Reporting Services page. Clicked "Create Linked Report" and called it Issues List. I then opened the Issues List report and clicked "Parameters". I ...

Edit reports from Agile process template?

528 byte By ThomasAndersson at 2008-2-6
Hi,We are running our project based on a custom process template and evertything works fine except one thing. I am not able to edit existing reports - and with existing reports I mean reports that came with the Agile process originally. I can run them and use them perfectly but when I try to ...

Need Change in CompletedWork

3100 byte By DougInGeorgia at 2008-2-5
========================================== Update: Please see the post dated 9/28/2006 for a new request for help. ========================================= I have a need to report developer hours by work item by week. I am attempting to use the warehouse filed "Current Work Item ...

New Project -- Reports Not Working Immediately

445 byte By Exempo at 2008-2-5
I am using TFS Beta 3 and I want to make sure that the behavior I am expeiencing is normal. After I create a new project, the reports do not pull any data until the warehouse goes through a processing cycle. I know that I can manually run the warehouse processing cycle, but is there a way to ...

How to debug the subscription function

515 byte By LeonZhu at 2008-2-4
Hi all, I make a subsription about reporting from report portal. But I cannot receive the email as I subscribed. How could I debug the problem? I ensure there is no problem when I new a subscription. Where can I see my SMTP server configuration? Any other possible error configurations? I ...

How to Remove the row which doesn't have data?

523 byte By vijaytooly at 2008-2-4
Hello to all, I am new to rdlc reports. I am using WebFrom Report Viewer, My Quesiton is that i've some fileds in my database that do not have data, and i want if there is no data in the field then the row will not be display and the the lower row shifted to the blank row, Or i want to remove ...

Error Generating model for Olap Data Source

2192 byte By BryanNate at 2008-2-4
When I try to generate a data source for the TfsOlapReportDS in Report Manager I get the following error: An error occurred while generating model. (rsModelGenerationError) Get Online Help An error occurred during the generation of semantic model : [Create mapping between ...

Printing Reports from within Team Explorer

514 byte By Gerdes at 2008-2-4
We are trying to print reports from within Team Explorer and get the following error: Print Error: "An error occured trying to get the current window." After clicking ok on that error, we get an Internet Explorer Script Error that says: "Could not complete the operation due to ...

Nearly a complete solution

3100 byte By DougInGeorgia at 2008-2-3
========================================== Update: Please see the post dated 9/28/2006 for a new request for help. ========================================= I have a need to report developer hours by work item by week. I am attempting to use the warehouse filed "Current Work Item ...

Does Business Intelligence Development Studio install when using SQL Server 2005 shipped with TF

240 byte By DougInGeorgia at 2008-2-3
Did your install of TFS ver 1.0 also install Business Intelligence Development Studio (BIDS)? We have done 2 installs and neither install enabled BIDS, even though we selected it from the Client Components. Any ideas?

Visual Studio Team System

Site Classified