Hi;
Thanks siva kumar.It works fine.
Regards,
vijay
Message: 14
Date: Wed, 29 Mar 2006 19:29:45 -0800 (PST)
From: Siva kumar <[EMAIL PROTECTED]>
Subject: Re: How to get distinct records in report?
Hi vijay,
Use
Fetch()
{
Query Q = New Query(this.Query);
QueryRun QR;
EquipmentTable EquipmentTableTmp;
;
this.query().datasourcetable(tablenum(EquipmentTable)).OrderMode(OrderMode::Groupby);
this.query().datasourcetable(tablenum(EquipmentTable)).addsortField(FieldNum(EquipmentTable,QuipmentClass));
QR = New QueryRun(this.Query);
while (QR.next())
{
EquipmentTableTmp = QR.get(Tablenum( EquipmentTable));
}
super();
}
this will send the unique equipmentclass data to the body section of
the report.
I think this will help you....
Regards,
MGS
Mukesh mutreja <[EMAIL PROTECTED]> wrote:
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 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]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
