472,950 Members | 2,279 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,950 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 1500

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Japcuh | last post by:
How do you write self modifying code in Java? Japcuh (Just Another Perl C Unix Hacker) http://www.catb.org/~esr/faq/hacker-howto.htm#what_is ..0. ...0 000
by: MikeY | last post by:
Hi everyone, Using C#, Windows forms. I am trying to learn how to modify existing data with in MSDE table/fields. If anyone could help me out with my code, I would appreciate it. My code is as...
by: Jason | last post by:
after user log out from my web site, I need to save what time they logged out to database. Here is my problem: if they click 'log out' button before they close web browser, it is works fine; but...
by: Adam | last post by:
I have a small application that uses oledb to connect to a database, set up through the GUI wizards in vis studio. I am wanting to have the database location kept in an .ini file along with the...
by: Anatoly Kurilin | last post by:
Hi, I normally use this code for modifying tables in backend files: Set dbsBackEnd = DBEngine.OpenDatabase(strBackEndFileSpecs) Set tdfIncome = dbsBackEnd!tblIncome and so on. This time I need...
by: spohle | last post by:
hi how can i modify multiple widgets with one scrollbar ? thanks in advance sven
by: David Hirschfield | last post by:
Anyone out there use simpleparse? If so, I have a problem that I can't seem to solve...I need to be able to parse this line: """Cen2 = Cen(OUT, "Cep", "ies", wh, 544, (wh/ht));""" with this...
by: TBraddy | last post by:
I am modifying a ms access database query and am running into some problems. When I run a search for dates... it works up until 2/12/2007, but after that it quits. I run another query that is...
by: jayantadutta | last post by:
hi i'm facing a problem while transferring date from csv to database. my quary as follows if (! firstdate.trim().equals("")) { System.out.println("insertInToDatabase startdate...
by: Salad | last post by:
I have access, for testing at my client's site, a Win2000 computer running A2003 retail. He recently upgraded all of his other machines to DualCore Pentiums with 2 gig ram and run A2003 runtime. ...
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

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.