Posted By: Lord Yorkshire — 29 Oct 2013 at 12:48am
I have a report where i wish to concatenate the answers i recevie.
These are all at Detail Level and the report looks like this
Header
Panel Num Score
Details
1 164
2 535
3 164
i want to end up with a string that says"164+535+164"
This could be upto a maximum of 10 scores but i only want to show the appropriate number, i dont want "164+535+164+0+0+0+0+0+0+0"
Posted By: kevlray — 29 Oct 2013 at 4:29am
I would create a formula to go in the details something like this.
shared stringvar somestring;
if onlastrecord then
somestring := somestring + {stringval}+"+"
else
somestring := somestring
Then have another formula in the report footer
shared stringvar somestring;
If you are grouping the data, you probably would put the second formula in the GF, but then you will need another formula to reset the string to nothing in the GH (example: shared stringvar somestring :="";)
