Column Sharing in Report

[CORYSW]

Can you share more than two columns? I have been able to share two but three does not work.

[ScottSa1]

yes you can! i havent seen any limitations with sharing columns. I have a report that is like 22 columns all shared into one. http://loyola.attask-ondemand.com/report/public/view?publicToken=_dJqXcqOq8dvWGEuaOQZlv_ABxmNbj7w8lb... The code is attached to this as well so you can see how I did it.

[CORYSW]

Thanks Scott! Let me give it a try. Also thanks for presenting at Leap! You did a great job!

[EricLu2]

Scott - Amazing. Would you kindly cut and paste that Text Mode code into a reply or maybe upload a kickstart of this report? Thanks! Eric

[CORYSW]

In reviewing your code, I was able to see what I was missing and was able to get it to work. Thanks again!

[ScottSa1]

here is the word doc with the code so you can copy/paste.....let me know if you have any problems.

[ScottSa1]

Great! I found the easiest thing to do is go step by step. share columns 2 or 3 at a type and then combine everything. Also save and save often. I found that sometimes there would be glitches where when I combined certain fields, it would erase others when I tried to do too much at once so probably user errors...

[EricLu2]

It worked for me too. Oh this is nice. Good job, Scott! Bonus Karma Points for you today. Eric

[DavidCo3]

Thanks Scott! Very handy....

[PatriciaMo1]

WOW! I didn't even know that was a possibility. Thanks for sharing!

[PhilipSt]

Scott, Thank you for sharing this. I love it! I have one question, I think having a PM Partner identified is a great idea, is that field held on a custom form somewhere? Thanks, Phil

[NateBa]

Scott, I'd love to share this in the new Resources section for report text expressions I recently created. Would you be willing to drop your code into the attached template and shoot it over to me? I'll add it to the file base, then we can have it somewhere where it's easily accessible to future users! -Nate In Reply to Scott Sax:

yes you can! i havent seen any limitations with sharing columns. I have a report that is like 22 columns all shared into one. http://loyola.attask-ondemand.com/report/public/view?publicToken=_dJqXcqOq8dvWGEuaOQZlv_ABxmNbj7w8lb... The code is attached to this as well so you can see how I did it.

-Nate Bagley --- Workfront Community Manager - Work Smart, Work Happy Message me directly at:

[NateBa]

Also, Scott... I don't think I've seen Eric Lucas this excited about something on the forum in quite a while... so I gave you the first ever "Super Scout" badge. Congrats! ;) In Reply to Lucas Eric:

It worked for me too. Oh this is nice. Good job, Scott! Bonus Karma Points for you today. Eric

-Nate Bagley --- Workfront Community Manager - Work Smart, Work Happy Message me directly at:

[EricLu2]

Well earned, too! I’m crawling through his code this very minute and I think I know how he built it. I’m going to venture out and make my first shared column report. Woooo! Wish me well.

[ScottSa1]

Hey Nate, I’d be happy to help. I’ll see what I can do to put it into this format and send it back. I’ll probably be next week if that is ok. Thanks! Scott

[NateBa]

That would be amazing! No worries on timeframe. In Reply to Scott Sax:

Hey Nate, I’d be happy to help. I’ll see what I can do to put it into this format and send it back. I’ll probably be next week if that is ok. Thanks! Scott

[ScottSa1]

Hello Nate, Sorry for the delay. Attached is the template all filled out. Feel free to edit as needed or make it clearer if it sounds too confusing.

[DavidCo3]

Awesome....thanks Scott.

[PhilipSt]

Thanks, Scott.... Great stuff!

[benjaming980359]

This was EXACTLY what I was looking to do and it worked like a charm, very nice Scott. I've had a bear of a time calling specific custom form parameters, so this gave me some great perspective into what syntax I could use around the combo column I was building. Got it up and running this morning! Karma waves inbound...

[LauraRa1]

Hi Scott, I've created a report similar to yours but I cannot figure out how to make the names bold and the text next to them normal style. Mine is all bold!. I've attached a word doc with my text code and a screenshot of one of the results... it may be messy to be kind :)