Modification of default TFS Reports

Question

Trying to add a couple of additional fields to the remaining work report, but keep getting the following error:

------------------------------------

An error occurred during client rendering.
An error has occurred during report processing.Query execution failed for dataset 'dsWorkItemHistory'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors

-------------------------------------

Not sure what all needs to be modified with the new fields. It seems to do that only when I add the information to the 'query' section. The other place I made a change ws to the 'fields' section. When ever I added it to the 'parameters' section two new text fields show up on the report website.

Using report builder 2.0; TFS 2010

Answer 1

Hi Boss,

Try run your source stored procedure or Query in SSMS to verify the query.

---

------------------ Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Maqbool.

Answer 2

Hello,

I think there some issue with your datasource query. Try running it on the ssms and let us know.

Answer 3

Run it on the SSMS under which server type? Reporting Services?

Answer 4

Below is the query w/o the modifications; aside from 'active', 'close', and 'resolved' was trying to add 'review' and 'shelved'

WITH
MEMBER [Measures].[Date Value] AS
    [Date].[Date].CurrentMember.Member_Value

MEMBER [Measures].[Active Cumulative Count] AS
    Sum(
        (StrToMember("[Work Item].[System_State].[System_State].[" + @Active + "]")),
        [Measures].[Work Item Count]
       )

MEMBER [Measures].[Closed Cumulative Count] AS
    Sum(
        (StrToMember("[Work Item].[System_State].[System_State].[" + @Closed + "]")),
        [Measures].[Work Item Count]
       )

MEMBER [Measures].[Resolved Cumulative Count] AS
    Sum(
        (StrToMember("[Work Item].[System_State].[System_State].[" + @Resolved + "]")),
        [Measures].[Work Item Count]
       )
SELECT
{
    [Measures].[Date Value],
    [Measures].[Active Cumulative Count],
    [Measures].[Closed Cumulative Count],
    [Measures].[Resolved Cumulative Count]
} ON COLUMNS,
(
    Filter(
        [Date].[Date].[Date],
        [Date].[Date].CurrentMember.Member_Value >= CDate(@StartDateParam) AND
        [Date].[Date].CurrentMember.Member_Value <= CDate(@EndDateParam)
    )
) ON ROWS
FROM
(
    SELECT
    (
      STRTOMEMBER("[Team Project].[Project Node GUID].&[{" + @ProjectGuid + "}]"),
      STRTOSET(@IterationParam),
      STRTOSET(@AreaParam),
      STRTOSET(@WorkItemTypeParam)
    ) ON 0
    FROM [Team System]
)

Answer 5

Also, I am getting errors about those parameters that are being declared. How do i know which parameters are needed? The query above is from the default 'Remaining Work' template.

Answer 6

Looks like I don't have all the options unders the 'measures' metadata section. Not sure how to fix that.