Build a String With Distinct Records of Result Set

[dv10lv]

For example I have 187 records returned and 2 distinct departments for deparment name. I want to display the Distinct Department names concatenated to one string on the Report Header. When I use browse data on the department_name field I get the distinct department names this is what I want the formula to do.

(Something Like)

StringVar DepName;

if not allready in then
DepName := DepName + {Command.department_name} + ChrW (13)

 

[synapsevampire]

You purdy much have it, but since youwant it in the front of the report it's trickier, check out my FAQ:

faq767-6528

-k

 

[synapsevampire]

Since you only have 2 you might use:

minimum({table.dept})+", "+maximum({table.dept})

-k