Complicated joining of 3 DB fields 1

[neo86]

Hi all,

I need some help with CR 2011 formula

Need to do something like this




DBfield1 DBFieldTest1 DBFieldTest2


flight null null


cycle 2 null


boat null 3


train 1 2


car,car,car abc;def;hijk null


bike, bike, car 1;2;3 abc;def;hijk


null null null






In Report Display one field combining the data from those three DB fields as




1) flight


2) cycle Test1:2


3) boat Test2:3


4) train Test1:1 Test2:2


5) car Test1:abc, car Test1:def, car Test1:hijk


6) bike Test1:1 Test2:abc, bike Test1:2 Test2:def, car Test1:3 Test2:hijk


7) null


Thank you.

 

[CoSpringsGuy]

you are welcome ..
once you have submitted yourpost, I dont believe there is a way to edit ...

_____________________________________
Crystal Reports 2008 and XI
Intersystems Cache 2012 ODBC connection