Disabling Link Within Report

Nevermind! As soon as I clicked "Post," I did one more search and found the information I was looking for.

It seems that "non-clickable" was the phrase I should have searched for.

Hi everyone,

What I have done is created a new view for export and use this code for the column. (Either a task or project name). Hope this helps

Eliminate Hyperlink on task name (provided by Workfront)

displayname=Task Name

querysort=name

textmode=true

valueexpression={name}

valueformat=HTML

Eliminate Hyperlink on Project name

displayname=Project Name

linkedname=project

namekey=view.relatedcolumn

namekeyargkey.0=project

namekeyargkey.1=name

querysort=project:name

textmode=true

valueexpression={project}.{name}

valueformat=HTML

Thank you Patricia!

I was able to use that code for Queue Topic Name:

displayname= linked

name=queueTopic

namekey=view.relatedcolumn

namekeyargkey.0=queueTopic

namekeyargkey.1=name

querysort=queueTopic:name

textmode=true

valueexpression={queueTopic}.{name}

valueformat=HTML

Here is what I figured out, after some experimenting. Here's the original text mode for the Task Name field, which was causing me the most grief in a Spreadsheet. We email spreadsheets out to non-Workfront users and so this was a problem if I forgot to remove the links before sending it.

valuefield=name

querysort=name

valueformat=HTML

displayname= Task Name

linkedname=direct

namekey=name

Here's what I changed it to:

displayname=Task Name

linkedname=direct

namekey=name

querysort=name

textmode=true

valueexpression={name}

valueformat=Compound

width=150

I would think that a similar approach would work for your situation.

There is another solution if you are scheduling the report for delivery. If you go to Report Actions > Send Reports and you change the format to MS Excel, a check box appears that you can elect to include hyperlinks in the report export. However, this only works if you use Report Actions.

Some other good work-arounds have been posted. I really like how everyone helps each other out in this community. :)

It's unfortunate that for some basic "report control features" that you have to go into text mode code to do something that used to be so simple back in the day. When we 1st started using Workfront in 2012, the UI and Report Builder were very different than they are now. I like the new report builder, but I miss some of the conveniences of the old version (2012). The following are a few of my favorites that went by the way side since 2012 that I'd really like to see brought back: Check box to include a hyperlink on a field, width field to easily enter how wide you wanted the column to be, and stretch field to indicate how much stretch you wanted to give a field if any. These are basic control features that I think are more confusing to novice report users; when I explain to them that they need to convert to text mode code you can almost hear a pin drop. :)

To answer your question, the suggestions had been submitted in the past, but in searching the new Idea Exchange, they are not there so I resubmitted them. Posted the following on the Idea Exchange under Reporting; make sure to vote for them.

Provide Check Box to Control if you want the description of a field to appear when you hover over it

https://support.workfront.com/hc/en-us/community/posts/115004303293-Provide-Check-Box-to-Control-if-you-want-the-description-of-a-field-to-appear-when-you-hover-over-it

https://support.workfront.com/hc/en-us/community/posts/115004303213-Bring-Back-Ability-to-Easily-Set-Widths-and-Stretch-in-Report-Builder-WITHOUT-Text-Mode-Code