How to group in cside?

yukonyukon Member Posts: 361
Hi Expert,

I want to get group by item. But i don't see group function in cside help. So How can i get group by ite.


Table Sales Line

Key.
Document No.
Document Type.
Location Code
No.

Eg. I want to get like that ...
Document No .= xxxxx
Document Type = Order

Item Location
0001 AU
0001 SG
0002 UK
0002 US

Remarks : Ans for nav. Not sql.

Best Regards,
Yukon
Make Simple & Easy

Comments

  • bbrownbbrown Member Posts: 3,268
    Option 1:

    Accumulate the totals into a temp table. Then print the results.
    There are no bugs - only undocumented features.
  • yukonyukon Member Posts: 361
    Hi bbrown,

    Thx for your reply. That way need to loop and insert into temp table. So i don't want to loop. Do you have any idea?


    Best Regards,
    Yukon
    Make Simple & Easy
  • bbrownbbrown Member Posts: 3,268
    C/Side does not have a "Group By" function. You need to loop thru the records or use SumIndexes (in which you still need to sort of loop thru)
    There are no bugs - only undocumented features.
  • yukonyukon Member Posts: 361
    Hi bbrown,

    Thx for your reply.
    So poor CSide :(


    Best Regards,
    Yukon
    Make Simple & Easy
  • DenSterDenSter Member Posts: 8,305
    yukon wrote:
    So poor CSide :(
    Yep, you found one thing that it doesn't do, and the whole thing is poor :mrgreen:
Sign In or Register to comment.