I considered CustTable for example.
QueryRun qr;
CustTable _custTable;
int i= 1;
;
qr = new QueryRun(this.query());
//ret = super();
if(qr.prompt())
{
while( i<= 100)
{
qr.next();
_custTable = qr.get(tablenum(CustTable));//CustTable hereby used signifies //the table name as in query of report
this.send(_custTable);
i++;
}
return true;
}
return false;
Regards::
Shruti Jain
Euroinfo Systems Pvt. Ltd.
C-126, Sector - 2
Noida - 201301 (U.P.)
Phone :- +91-120-2520414
----- Original Message -----
From: Stefan Osterburg
To: [email protected]
Sent: Monday, January 24, 2005 4:18 PM
Subject: [development-axapta] Grouping and sorting in a report
Hi,
I have a problem with creating a report I need.
I have a table with orders and an object id, and
want to get a list of "Top 100" orders. In standard
SQL I would do something like this
select ObjectId,count(Recid) as number
from orders
group by ObjectId
order by number
However I cannot find way to build a report query
to do this, as the "Ordermode" is per table and not
per field.
Is there a way to do this in Axapta without doing
lengthy coding?
Stefan
------------------------------------------------------------------------------
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
