Hi all

This is a typicaly requirement that I have. I have a table having values as below:

HB         Haematology
TC         Haematology
URM        UrineAnalysis
DC         Haematology

I can group the above like follows:

SELECT * FROM ... GROUP BY 2

but I want the following result in the result:

HB TC DC     Haematology
URM          UrineAnalysis

Is this possible to display in a view. This view will then be used externally by Report Manager for printing purposes. Thus I have to already have formatted the data beforehand as Report Manager won't be able to call VFP UDFs.

Please help.