Why not use a SQL view? Depending on how many inventtrans records you have it might be possible without major impact on the resources
-----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Nihar Saraiya Sent: 18 November 2006 17:22 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Creating a Group Hierarchy for a report thru Auto Wizard or Coding Hi Group For one of the report, the output to be generated should be retrieved should be grouped. The grouping has 4 levels of Hierarchy. If any one would give a sample coding or give some pointers on how to deal with this will be greatly appreciated. The following is the requirement: 1. Item Group 2. Items 3. Supplier 4. Warehouse For a particular Item, transactions are picked up from data-source, Inventtrans. How can the transaction Grouped as per the above requirement? Regards Nihar Saraiya [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Visit www.axapta-knowledge-village.tk Yahoo! Groups Links
