471,066 Members | 1,517 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

Problem modifying out-of-the-box TFS Report

My office has adopted Team Foundation Server to track and manage the
development and deployment process at our site. I have been asked to
modify one of the standard work item reports, "Related Work Items,"
that ships with TFS. I've successfully done some of these, which
involved changing the MDX code for the datasets that generate default
parameter values, but I am running into problems modifying the main
dataset, dsRelatedWorkItems. I am using VS2005. When I look at the
components of this dataset on the tree diagram for all datasets, all
of the correct fields are present, I can Preview the report and it
works. When looking at the Data page, I see the MDX query on top and
a results pane on the bottom. The results pane correctly lists all of
the fields I saw in the tree diagram across the top. But the query
itself does not look like the query that would have generated these
columns. Rather, the columns in the result pane correspond to the
rows in the query, not the columns. When I execute the query on the
data page, all of those columns disappear in the result pane, and the
only column that shows up is the single field that precedes the ON
COLUMNS statement in the MDX. At this point, if I attempt to preview
the report, it fails because it doesn't have the expected fields in
the dataset. If I try to switch to the design mode to see whether
there is any alternate definition of the dataset lurking somewhere, it
looks like all dataset definitions are lost. The properties page for
the dataset shows the fields correctly if I haven't yet executed the
query. If I try to make any of the modifications that I need to make
(which are simple -- I just need to remove some of the slicer
conditions in the WHERE clause), I am again unable to preview the

It looks like the query that I see in the query pane is not what is
really being used for the dataset, and I'm stumped. I am not an
experienced MDX user, but I can do fairly basic modifications of the
type that are needed here. It seems like my problem isn't MDX syntax,
but rather how (or where) Reporting Services is keeping the query that
underlies this dataset.

Anybody out there have a clue that might get me back on track with
this? Thanks.

Mar 4 '07 #1
0 1439

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Japcuh | last post: by
2 posts views Thread by MikeY | last post: by
3 posts views Thread by Jason | last post: by
reply views Thread by Anatoly Kurilin | last post: by
1 post views Thread by David Hirschfield | last post: by
5 posts views Thread by TBraddy | last post: by
1 post views Thread by jayantadutta | last post: by
9 posts views Thread by Salad | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.