How to group in cside?

yukon

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

bbrown

Option 1:

Accumulate the totals into a temp table. Then print the results.

yukon

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

bbrown

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)

yukon

Hi bbrown,

Thx for your reply.
So poor CSide


Best Regards,
Yukon

DenSter

yukon wrote:

So poor CSide

Yep, you found one thing that it doesn't do, and the whole thing is poor