Column Sharing in Report

Hello Laura, The problem is that there is a missing bold tag in the back end code or something that when you add the project name to the report and share columns it makes everything bold. The hack to get around this is to add the extra column in the beginning with the open bold tag that I mentioned before. Add a new column to your report and move it to the first column. Switch it to text mode and copy the following code in there: sharecol=true textmode=true value= valueformat=HTML This will combine the column with the rest of your code, but it adds the new open bold tag. You already have the close bold tag on the Date field so you don't need to add that. I've added the code to this as well so you can see the code but wanted to explain what I did and how to update your existing one. Scott In Reply to Laura Ray:

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

Scott, apologies, I forgot it was you who’d suggested adding the bold tag. You’ll be happy to hear it’s all looking great, thanks so much for helping. It’s taken me about 12 hours effort to complete this. It’s a frustrating report with all those columns! 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@01D23508.F89D8910]

no worries! the reports can take a long time, especially when they have many columns and something goes wrong and then you have to troubleshoot. I know that scenario all to well!

Hi Scott, Hoping you can help! I've put together the attached report code and it's working well overall. There's two issues I would like to fix though: The sort order of the report. Currently it seems to be sorting in a completely random order. I would like it sorted aphabetically by the project name. The width of the Percent Complete box. At the moment it is spanning the width of the page, which doesn't look good. I would like to limit its width if possible (I have tried adding a width=50 line). If not possible, I would be happy just to show the percentage in numerical form without the graphical bar (I've tried setting the valueformat=HTML and removing the 'tile' references but this didn't work). Any ideas? Thanks in advance. Regards, David

Hi David, To control the report sorting, add these lines to the column in question: sortOrder=1 sortType=asc As for forcing a column to be wider, an oldie but goodie trick is to use underscores to force the width of the column, like this: displayname=My_Column_Header______ Regards, Doug

Looks like Doug answered before I could. Thanks Doug!. Good luck with it! In Reply to ....Doug.... Den Hoed:

Hi David, To control the report sorting, add these lines to the column in question: sortOrder=1 sortType=asc As for forcing a column to be wider, an oldie but goodie trick is to use underscores to force the width of the column, like this: displayname=My_Column_Header______ Regards, Doug

Thanks Doug and Scott. The sort order worked great! However, I wasn't trying to make the percent complete column wider. I actually want the percent complete bar to be narrower, because it is filling the width of the single shared column (see attached screenshot). Not sure if it is going to be possible to do this? That's why I was thinking maybe I can just get the numerical percent value instead of the bar. Any ideas? Cheers, David

interesting..i thought that bar was affected by the width of the columns..that it filled up whatever the size of the column.......have you tried to change the width of that column to see if it affects it? In Reply to David Cornwell:

Thanks Doug and Scott. The sort order worked great! However, I wasn't trying to make the percent complete column wider. I actually want the percent complete bar to be narrower, because it is filling the width of the single shared column (see attached screenshot). Not sure if it is going to be possible to do this? That's why I was thinking maybe I can just get the numerical percent value instead of the bar. Any ideas? Cheers, David

Hi Scott, Column 19 in my code is the percentage complete column. I have the following: column.19.width=50 I then looked through the rest of the code and saw that column 0 has the a "usewidths=true" entry, so I added the following: column.19.usewidths=true Unfortunately, neither are working for me still. Have you ever tried adding percent complete to a shared column and not had it cover the whole width? Regards, David

Quick update for those who are interested in how how display percentage complete as text rather than a graphical bar. Use the following text mode: displayname=percent complete textmode=true valueexpression=CONCAT({percentComplete},"%") valueformat=HTML Thanks go to Anna Khachatryan from Workfront Support for providing this solution.