Column Sharing in Report

Narayan, I would love to see your code for this example that includes HTML. Pretty slick! [Here's an example of how you can insert some html characters and colors as well. See the attachment.]

This is great and I've done some similar things like this. please note though, that when you export out the report in PDF format, it doens't translate the HTML into HTML. Instead you just have the code. I've put a ticket in regarding that and it seems like that there is nothing that can be done, its just the way it gets rendered. So instead of having text being italics for example, it comes back as Italics Text when exported.... In Reply to Narayan Raum:

Here's an example of how you can insert some html characters and colors as well. See the attachment.

Yes, that’s one of the drawbacks of fancy HTML code in dashboards and reports… they don’t export.

I'll paste the code for the first set of fields in the first and second columns below. I've also attached the image again. One thing to note, this is generic enough that you can add it to an Issue report and then link to that issue report from a custom tab in your Issue view. I forget the name of this feature, but it allows you to render data relevant to the object you're currently on, which is neato. This text only uses native Workfront fields, so it'll work for anyone. FIRST COLUMN ####################################### column.0.displayname=Request Summary column.0.sharecol=true column.0.shortview=true column.0.textmode=true column.0.value= Ref # column.0.valueformat=HTML column.0.width=250 column.1.descriptionkey=referencenumber column.1.isInlineEditable=false column.1.linkedname=direct column.1.listsort=intAsInt(referenceNumber) column.1.namekey=referencenumber.abbr column.1.querysort=referenceNumber column.1.sharecol=true column.1.textmode=true column.1.valuefield=referenceNumber column.1.valueformat=int column.2.sharecol=true column.2.textmode=true column.2.value= ‚Ä£ by column.2.valueformat=HTML column.3.displayname=Entered by column.3.linkedname=enteredBy column.3.namekey=view.relatedcolumn column.3.namekeyargkey.0=enteredBy column.3.namekeyargkey.1=name column.3.querysort=enteredBy:name column.3.sharecol=true column.3.textmode=true column.3.valuefield=enteredBy:name column.3.valueformat=HTML column.4.sharecol=true column.4.shortview=true column.4.textmode=true column.4.value= column.4.valueformat=HTML column.5.Shortview=true column.5.sharecol=true column.5.textmode=true column.5.value= ‚Ä£ from Group column.5.valueformat=HTML column.6.displayname=Group of Requestor column.6.linkedname=enteredBy column.6.namekey=view.relatedcolumn column.6.namekeyargkey.0=enteredBy column.6.namekeyargkey.1=homeGroupID column.6.querysort=enteredBy:homeGroup:name column.6.sharecol=true column.6.textmode=true column.6.valuefield=enteredBy:homeGroup:name column.6.valueformat=HTML column.7.sharecol=true column.7.textmode=true column.7.value= ‚Ä£ on date column.7.valueformat=HTML column.8.descriptionkey=entrydate column.8.displayname=Entry Date column.8.isInlineEditable=false column.8.linkedname=direct column.8.listsort=atDateAsAtDate(entryDate) column.8.namekey=entrydate.abbr column.8.querysort=entryDate column.8.sharecol=true column.8.textmode=true column.8.valuefield=entryDate column.8.valueformat=atDate column.9.Shortview=true column.9.sharecol=true column.9.textmode=true column.9.value= Latest Update: column.9.valueformat=HTML column.10.displayname=Latest Update column.10.namekey=latest update column.10.shortview=true column.10.textmode=true column.10.valueexpression=IF(LEN({lastNote}.{noteText})>1000, CONCAT(SUBSTR({lastNote}.{noteText},0,999),"...(open for more) -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), IF(LEN({lastNote}.{noteText})>0, CONCAT({lastNote}.{noteText}," -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}))) column.10.valueformat=HTML SECOND COLUMN ####################################### column.11.displayname=Resolving Project column.11.sharecol=true column.11.shortview=true column.11.textmode=true column.11.value= Name: column.11.valueformat=HTML column.12.linkedname=resolveProject column.12.namekey=view.relatedcolumn column.12.namekeyargkey.0=resolveProject column.12.namekeyargkey.1=name column.12.querysort=resolveProject:name column.12.sharecol=true column.12.shortview=true column.12.textmode=true column.12.valuefield=resolveProject:name column.12.valueformat=HTML column.13.Shortview=true column.13.sharecol=true column.13.textmode=true column.13.value= Owner: column.13.valueformat=HTML column.14.displayname= column.14.linkedname=resolveProject column.14.namekey=view.relatedcolumn column.14.namekeyargkey.0=resolveProject column.14.namekeyargkey.1=ownerID column.14.querysort=resolveProject:owner:name column.14.sharecol=true column.14.shortview=true column.14.textmode=true column.14.valuefield=resolveProject:owner:name column.14.valueformat=HTML column.15.Shortview=true column.15.sharecol=true column.15.textmode=true column.15.value= Status: column.15.valueformat=HTML column.16.displayname=Project Status column.16.enumclass=com.attask.common.constants.ProjectStatusEnum column.16.enumtype=PROJ column.16.linkedname=resolveProject column.16.namekey=view.relatedcolumn column.16.namekeyargkey.0=resolveProject column.16.namekeyargkey.1=status column.16.querysort=resolveProject:status column.16.shortview=true column.16.textmode=true column.16.type=enum column.16.valuefield=resolveProject:status column.16.valueformat=val

Oh good idea! Thanks, this will save no end of time! Laura Ray Project Support Analyst Bakkavor Information Systems Bakkavor Group West Marsh Road, Spalding, Lincolnshire, PE11 2BB, UK Direct: +44 (0)1775 763 010 www.Bakkavor.com // Laura.Ray@Bakkavor.com< [cid:image002.png@01D2334F.779FF3D0]

One more time please, Narayan. I've attached my code (which I've had to adjust many time) that is now correct and contains all the fields I want. I've tried to get it back to where the field titles are bold and the rest plain but I cannot figure it out. Also, the issue entry date won't show and not sure what I've done wrong there. The only other thing I'd like are some spaces between the field title and the text, sort of like an equal tab space if that's possible. Thanks!

Where does the bold begin? Can you provide a screenshot?

Hi there, screenshot attached. Thanks! :)

Hi Laura, since everything is in Bold, I’m not sure what the cause is here. I’ve seen this before and I think I was able to paste the text into a new blank report and it cleared up. Can you try this?

Tried that and it didn't make any difference. I've attached a screenshot and the code for one that DID format the bold text properly but it was the one with a lot of the columns missing. Can you see what's making the difference there? Thanks