me the most troubles is not limiting the output to top 100,
but sorting the output descending by the recid-count.
Shruti schrieb:
> This could be done by writing this code in the fetch method of the report.
> 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
>
>
>
>
>
>
>
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.
