How to group in cside?

yukon · 2009-06-15

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 · 2009-06-15

Option 1:

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

yukon · 2009-06-15

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 · 2009-06-15

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 · 2009-06-15

Hi bbrown,

Thx for your reply.
So poor CSide

Best Regards,
Yukon

DenSter · 2009-06-15

yukon wrote:

So poor CSide

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

How to group in cside?

Comments

Categories