Display distinct column values (string) in report header section 1

[zzz6]

Hello:

I would like to display the distinct values within a field of all the selected records within the report header section. The column is in string format and I am thinking of using loop in the formula. Since I haven't used loop for a long time, so I have trouble in getting it right. Any help will be very much appreciated!

For example:
When user selected 100 records, then crystal report will loop through the 100 records and check for a field called "Chemistry" and returns the unique value as below in the report header section:

Chloride
Zinc
PH

 

[lbass]

One way of getting column values in a header (if they aren't instances of a parameter) is to insert a crosstab using the field as a row and with any summary, and then suppressing the summary and removing the grid.

Another is to insert a subreport that uses the same selection formula, with a group on the field and details suppressed.

-LB

 

[zzz6]

I tried the crosstab solution and it works out perfectly. Thanks!!!