Concatenate in datagrid
Posted on 2004-08-31
I have a table which has the following fields
If I have two records which both have the same prefix and sheet number but have different WhatFor I only want to display 1 of the records.
Prefix SheetNumber WhatFor Approval Date Fabrication Date
Ar 100 Approval 01/01/01 01/02/01
AR 100 Fabrication 01/01/01 01/02/01
Prefix SheetNumber Approval Date Fabrication Date
AR 100 01/01/01 01/02/01
Both records represent the same sheet which will have two records one for approval and one for fabrication, however for this particular datagrid I only need to display the record one time because they have the same dates and whatfor is irrelavent.