I believe whatever fields are set in your sort are considered the groupby
fields
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of vk
Sent: 30 March 2006 15:02
To: development-axapta@yahoogroups.com
Subject: [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
* Visit your group development-axapta
http://groups.yahoo.com/group/development-axapta on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
http://docs.yahoo.com/info/terms/ .
_
[Non-text portions of this message have been removed]
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.