I would like to concatenate multiple fields, but I go in single file, the problem is that shows me everything in one column and many rows, I'll give an example:
i would like this record:
1-----P N P N N N P N
NOT THIS
1----P
2----N
3----P
4----N
...
I used this formula:
stringvar estado := trim({@AUD}) & {@AV} & {@ESP}+' ' +{@EKG}+' ' +{@BHC}+' ' +{@VDRL}+{@EGO}+' ' +{@EGH}+{@P.LIP}+ ' ' +{@CREAT}+' ' +{@TGP}+' ' +{@GLUC}+' ' +{@FR}+' ' +{@hm}+' ' +{@EXF}+' ' +{@COPRO}+' ' +{@RXT}+' ' +{@RX COL};
and i tr with this other formula
stringvar estado := trim({@AUD})& trim({@AV})+' ' +trim({@ESP})+' ' +trim({@EKG})+' '+trim({@BHC})+' ' +trim({@VDRL})
+trim({@EGO})+' ' +trim({@EGH})+trim({@P.LIP})+ ' ' +trim({@CREAT})+' ' +trim({@TGP})+' ' +trim({@GLUC})+' ' +trim({@FR})+' ' +trim({@hm})+' ' +trim({@EXF})
+' ' +trim({@COPRO})+' ' +trim({@RXT})+' ' +trim({@RX COL});
stringvar estado := rtrim({@AUD})+' ' + rtrim({@AV})+' ' +rtrim({@ESP})+' ' +rtrim({@EKG})+' '+rtrim({@BHC})+' ' +rtrim({@VDRL})
+rtrim({@EGO})+' ' +rtrim({@EGH})+rtrim({@P.LIP})+ ' ' +rtrim({@CREAT})+' ' +rtrim({@TGP})+' ' +rtrim({@GLUC})+' ' +rtrim({@FR})+' ' +rtrim({@hm})+' ' +rtrim({@EXF})
+' ' +rtrim({@COPRO})+' ' +rtrim({@RXT})& rtrim({@RX COL});
stringvar estado := rtrim({@AUD})& rtrim({@AV})& rtrim({@ESP})&rtrim({@EKG})& rtrim({@BHC})
& rtrim({@VDRL})
& rtrim({@EGO})
& rtrim({@EGH})
& rtrim({@P.LIP})
& rtrim({@CREAT})
& rtrim({@TGP}) & rtrim({@GLUC}) & rtrim({@FR}) & rtrim({@hm}) & rtrim({@EXF})
& rtrim({@COPRO})
& rtrim({@RXT})
& rtrim({@RX COL});
trim(estado);