It's all about the answers!

Ask a question

Consolidated, sorted Report Builder column


Sterling Ferguson-II (1.6k7259259) | asked Oct 08, 7:36 a.m.

v6.0.6.1


Is it possible to use Report Builder to move from the following:

Planned For, Summary
1.0.0, Summary example
1.0.0 Sprint 1, Summary example
1.0.0 Sprint 2, Summary example
1.0.1, Summary example
2.0.0, Summary example
2.0.0 Sprint 1, Summary example

to

Planned For, Summary
1.0.0, Summary example
1.0.0, Summary example
1.0.0, Summary example
1.0.1, Summary example
2.0.0, Summary example
2.0.0, Summary example

2 answers



permanent link
Daniel Moul (4.7k1118) | answered Oct 08, 7:44 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

I imagine you could create a calculated column; I think we added them as a feature in one of the V7 releases. 

Maybe someone else can suggest a way to do this in 6061


permanent link
Jackie Albert (1.6k14744) | answered Oct 08, 12:18 p.m.
A custom expression should do the trick.  I'm using DB2 so my calculation is based on the DB2 substr option which you may or may not have based on your DB type, but I was able to use this calculation to get the first part of the value before a space, which seems to be what you're looking for


SUBSTR($Work Item:Planned For$, 1,LOCATE_IN_STRING($Work Item:Planned For$,' '))

Your answer


Register or to post your answer.