index > Team Foundation Server - Reporting > Standard team project reports have empty parameter combos

Standard team project reports have empty parameter combos

Hi,
I created a new team project last week, but noticed that when I went to (for example) the "Remaining Work" report, the Iteration combo was blank, and when dropped down didn't contain any entries. I tried forcing a process of the data warehouse, but that didn't help. Also, parameter in other reports displayed the same issue (eg, Work Item Type, Area, etc)

Today I tried deleting the project and creating it again, but it's made no difference.

All the other projects that already existed on the server behave without a problem. It may be relevant that this is almost certainly the first project created since we moved from the RC to the release version. This project is going live tomorrow, so I could really do with making sure I iron out any problems before it gathers momentum.

-----

Just done a bit more investigation, and there appear to be significant differences between the RDL files between a project that works and the new project. I'm wondering if something has gone wrong with the "Upload Default Reports for All Projects" step of the upgrade from RC to RTM? I've uploaded two fragments of RDL below, both from the Remaining Work report - I wonder if someone could look at them and work out what is up with our server? I've included the ReportParameters section, and the section for the iteration parameter in each case.

1) Broken project:
<ReportParameters>
<ReportParameter Name="Project">
<DataType>String</DataType>
<Prompt>Project</Prompt>
</ReportParameter>
<ReportParameter Name="Iteration">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>dsIterationDefault</DataSetName>
<ValueField>ParameterValue</ValueField>
</DataSetReference>
</DefaultValue>
<Prompt>Iteration</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>dsIterationParam</DataSetName>
<ValueField>ParameterValue</ValueField>
<LabelField>ParameterCaption</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>

2) Working project:
<ReportParameters>
<ReportParameter Name="ExplicitProject">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Agile 009</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>ExplicitProject</Prompt>
</ReportParameter>
<ReportParameter Name="Project">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=IIF(LEN(Parameters!ExplicitProject.Value) > 0,
Parameters!ExplicitProject.Value,
SPLIT(Globals!ReportFolder, "/").GetValue(IIF(split(Globals!ReportFolder, "/").Length > 1, 1, 0))
)</Value>
</Values>
</DefaultValue>
<Prompt>Project</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="IterationParam">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>DefaultIterationParam</DataSetName>
<ValueField>ParameterValue</ValueField>
</DataSetReference>
</DefaultValue>
<Prompt>Iteration</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>IterationParam</DataSetName>
<ValueField>ParameterValue</ValueField>
<LabelField>ParameterCaption</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>

I suspect at this point I could get things working for this project by simply updating the problem reports with the sources from the other projects, but obviously we'd end up having to do this for all new projects. Fixing it properly would be far preferable

Thanks,
Kevin

Kev160967

Anybody got any ideas?

Kev

Kev160967

Hi Kevin,

Can you please take a look at the Warehouse Troubleshooting Guide http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=154526&SiteID=1 and see if that helps you solve your problem.

Thanks.

Federico

Federico Kolliker Frers - MSFT

Also Kevin, tomorrow I'll take a look at the RDL code you included but as part of the RC to RTM upgrade the Warehouse was supposed to be rebuilt and all the reports in all the existing projects were supposed to be replaced with the RTM ones. If you have an RTM version installed you can find the RDL code for the Agile or CMMI methodologies in your Application Tier. You can look for a zip file (I don't remember the exact name right now) that is named MSF Agile.zip and inside that file you will see a reports folders with all the RDLs for the reports.

The reason I asked to also take a look at the troubleshoot guide is because maybe as a consequence of the upgrade your Warehouse is not being updated anymore.

Thanks.

Federico

Federico Kolliker Frers - MSFT

reply 4