RE : [development-axapta] How to get distinct records in report?

[Steeve Gilbert]

In the field nod, set the property Dynamic to No and then delete the fields you don't want to group by.  Don't forget to reset the report's user setting before running it.

Steeve... 


-----Message d'origine-----
De : development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de vk
Envoyé : 30 mars 2006 01:02
À : development-axapta@yahoogroups.com
Objet : [development-axapta] How to get distinct records in report?

hi,
  Thanks for ur favourable response. i have tried, but i get redendent data.for example  , the report display like this.
   
  EquipmentClass  Description
   
  BDR180HA         BullTozer 180Hp
  BDR180HA         BullTozer 180Hp
  BDR180HA         BullTozer 180Hp
  BHL007TA          Back hoe loader 7 hp
  BHL007TA          Back hoe loader 7 hp
   
  but i want
   
  BDR180HA        BullTozer 180Hp
  BHL007TA         Back hoe loader 7 hp
  
I have set group by in report Datasource's orderby mode. which field default taken for group by. i want to group by as equipment class.how to do?
   
  regards,
  vijay
  
Steeve Gilbert <[EMAIL PROTECTED]> wrote:
  Hi Vijay,

To do a group by, take a look at the property OrderMode of your report's dataSource.

Regards,

Steeve... 


-----Message d'origine-----
De : development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de vk
Envoyé : 28 mars 2006 23:39
À : development-axapta@yahoogroups.com; Axapta-Knowledge-Village@yahoogroups.com
Objet : [development-axapta] 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 entry like this
  Equipmentcode     EquipmentClass       Description
  BDR001                BDR180HA             Bull tozer180HP
  BDR002                BDR180HA             Bull tozer180HP
  BDR003                BDR180HA             Bull tozer180HP
  BHL001                 BHL007TA              Backhoe loader 7 ton
  BHL002                 BHL007TA              Backhoe loader 7 ton
   
  In my report i  have display only,
  EquipmentClas             Description                     TotalNoOf_Equipment       
  BDR180HA                   Bull tozer180HP              3
  BHL007TA                    Backhoe loader 7 ton       2
   
  How to get the unique Equipment class in my report.I have tried using Groupby query in jobs.i got the answer.but how to use this query in report?
   
  i used the query is,
  select EquipmentTable group by equipmentclass;
   
  help me
   
  yours,
  vijay

Send instant messages to your online friends http://uk.messenger.yahoo.com 

[Non-text portions of this message have been removed]






Yahoo! Groups Links










    
---------------------------------
  YAHOO! GROUPS LINKS 

    
    Visit your group "development-axapta" on the web.
    
    To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
    
    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 

    
---------------------------------
  



Send instant messages to your online friends http://uk.messenger.yahoo.com 

[Non-text portions of this message have been removed]





 
Yahoo! Groups Links



 






    


  
  
    SPONSORED LINKS
  
          
                  
            
        Computer part
      
                      
        Programming languages
      
                      
        Microsoft axapta
      
              
                        
            
        Support exchange
      
                    
           
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.