Re: [Axapta-Knowledge-Village] How to get distinct records in report?

Hi vijay, Use Fetch() { QueryQ = New Query(this.Query); QueryRun QR; EquipmentTableEquipmentTableTmp; ; this.query().datasourcetable(tablenum(EquipmentTable)).OrderMode(OrderMode::Groupby);

[Axapta-Knowledge-Village] How to get distinct records in report?

hi, I have an EquipmentTable.In my EquipmentTable having Equipmentcode,EquipmentClass,Declaration(3 fields).The Equipment code is a primary key.Same EquipmentClass having Different equipment code. my query is, how to get the unique equipmentclass in my report? equipmentTable having the

Re: [Axapta-Knowledge-Village] How to get distinct records in report?

Hi vijay, use programming section and display methods to display to display your records. Mukesh On 3/29/06, vk [EMAIL PROTECTED] wrote: hi, I have an EquipmentTable.In my EquipmentTable having Equipmentcode,EquipmentClass,Declaration(3 fields).The Equipment code is a primary