Column Sharing in Report

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

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!

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]

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

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

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.

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.]

If you have to insert columns, you can “break” the sharing by removing the sharecol=true, which will visually display your columns again side-by-side. You can then insert your column and, if done properly, let the GUI handle the renumbering for you.

I should add, I'm very new to text mode (and Workfront) so I'm very good at copying and pasting code but not as good at understanding it. I really like how you've laid yours out with colors and style etc. Very nice - I want that!

Hi, I’ve since fixed the requestor name issue (not sure how though). The code is in a bit of a mess I’ve just discovered as it’s missing some columns and it hasn't shared some. Very annoying because I have to go back through and change all the column numbers after I insert some of the missing columns. I tried just adding some spaces but it didn’t work. I’ve attached the code here in the word doc - thanks!