HB Haematology TC Haematology URM UrineAnalysis DC HaematologyI can group the above like follows:
SELECT * FROM ... GROUP BY 2but I want the following result in the result:
HB TC DC Haematology URM UrineAnalysisIs 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.