Crystal report - printing conditional value in group header

See more:

CrystalReports

I have been looking for days for an answer, and i'm hoping someone will help me on this topic here. I have not been working with crystal reports for very long, so I am going to give as much detail as possible.

I have a group in my report and this group has a formula field. this formula field is expected to look for a column in the detail section and when it gets the very first value, it should print in the group header.

for example, my details section returns records as below

column1      column2    column3
--------------------------------
row1           row1
row2           row2
row3           row3       row3
row4           row4       row4

my formula should look for column3 values, and when found should display in the group header. In this case, it should print row3

Your help is much appreciated.

What I have tried:

I have tried 3 formula solution with WhilePrintingrecords; one at the page header to reset the value, second one at the detail section to get the value and third one at group header to display it. But this gives blank value to me