List Report links - how to change them?

[axelortiz]

I have a List report based on the Project Task Link table. In the results I am displaying the Top Project, the Project Task Link, and the Linked.Task (in this case it is Change Request). When the report produces the list of results, the link off the Change Request points to the Project Task Link. I would like to change this link to point to the actual Change Request. Is this possible? If so, how is this accomplished? Thanks.

[axelortiz]

Thanks everyone for your responses. Moving the Linked task.Number (change request number) to the first column is fine. However there is no apparent way to create a link that would point the change request number to its CHG record.

I would like to be able to have a link to the project task link (already there if I leave that column as the first column) and also have a link on the linked task.number (Change Request) column that points to the change request record.

If I try to build this list on the reverse (change request referencing the project task link) I get an error:

The element type "td" must be terminated by the matching end-tag

"</td>".

I'm not sure if I should pursue the error above and from there build the list so the first column would link to the change requests...

Hope this helps clarify what I'm looking for.

Thanks again all,

Axel

[andrew_venables]

Hi Axel, did you try my suggestion to remove the dot-walked field? I was able to recreate your issue and fix it.

[axelortiz]

Hi Andrew,

I just tried it but it does not address what I am looking for (I hope it's not because I misunderstood what you suggested).

Below is a list of the columns I need in my list. I am looking for having the Change Request number linking to the change request record regardless of in what position I place it in the list.

Number (project task links number)

Number (of the change request with a link to change request record)

Short Description (of the change request)

Assigned to (change request Assigned To field)

State (of the top project)

Planned start (of the change request)

Planned end (of the change request)

Actual start (of the change request)

Actual end (of the change request)

Right now, regardless of which number I place in the first column, because the list is generated off the Project Task Links table, the first column links to the Project Task Links record. I need it to go to the Change Requests record. This is why now I am thinking I should pursue the error I get when I try to build lists off the Change Request table...

Thanks again Andrew. I apologize for the lengthy response!

-Axel-

[andrew_venables · Accepted solution]

I think you may have misunderstood, screenshots with similar example in's below. What you need to do is replace the dot-walked fields for 'number' with the reference fields themselves, so you have:

and what you need to get to:

Notice how you have used the Change Request.Number and i have just used Change Request. I didn't press the green plus, i just chose the reference field and moved it right to the selected bucket.

Give that a go!

[axelortiz]

You are right Andrew! I misunderstood your suggestion (I blame it on my primary education). I greatly appreciate your help.

-Axel-