Hi, I'm using Crystal Reports 2008.
I have data that looks like the table below. What I'm trying to do: for every like 'Guarantor', I would like to create a formula field to tag each 'Source' = "PROFESSIONAL" account with the associated 'Source' = "HOSPITAL" account. I've tired using a "DO" loop as such... hoping that for each guarantor it would cycle backwards to the "HOSPITAL" account and bring in that value
if {Source} = "PROFESSIONAL" then
do previous ({Account}} while {Source} = "PROFESSIONAL"
I'm new to loops/programming in general, I would very much appreciate any ideas or guidance. Thank you!
Andrew
Account__ Source________ Guarantor
1234____ HOSPITAL_______ 1111111
888999__ PROFESSIONAL__ 1111111
777888__ PROFESSIONAL__ 1111111
3456____ HOSPITAL_______ 3333333
111222__ PROFESSIONAL__ 3333333
444555__ PROFESSIONAL__ 3333333
666777__ PROFESSIONAL__ 3333333
6789____ HOSPITAL_______ 5555555
999111__ PROFESSIONAL__ 5555555
777555__ PROFESSIONAL__ 5555555
I have data that looks like the table below. What I'm trying to do: for every like 'Guarantor', I would like to create a formula field to tag each 'Source' = "PROFESSIONAL" account with the associated 'Source' = "HOSPITAL" account. I've tired using a "DO" loop as such... hoping that for each guarantor it would cycle backwards to the "HOSPITAL" account and bring in that value
if {Source} = "PROFESSIONAL" then
do previous ({Account}} while {Source} = "PROFESSIONAL"
I'm new to loops/programming in general, I would very much appreciate any ideas or guidance. Thank you!
Andrew
Account__ Source________ Guarantor
1234____ HOSPITAL_______ 1111111
888999__ PROFESSIONAL__ 1111111
777888__ PROFESSIONAL__ 1111111
3456____ HOSPITAL_______ 3333333
111222__ PROFESSIONAL__ 3333333
444555__ PROFESSIONAL__ 3333333
666777__ PROFESSIONAL__ 3333333
6789____ HOSPITAL_______ 5555555
999111__ PROFESSIONAL__ 5555555
777555__ PROFESSIONAL__ 5555555