You can try this query::
select sum(Qty),sum(costprice),sum(salesprice) from "TableName"
group by Description;
--- On Fri, 5/6/09, syed zaidi <bc105...@yahoo.com> wrote:
From: syed zaidi <bc105...@yahoo.com>
Subject: [Axapta-Knowledge-Village] HelP Required
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Friday, 5 June, 2009, 10:22 AM
.
Dear All,
I want to use group by techique in AX2009 Reports.
data save this way in table
Descripotion Qty
CostPrice SalesPrice
Television 1
5000 6000
Television 3 15000 18000
AC
3 150000 180000
Results i want to display data in Report body like this way from group by
technique
Descripotion Qty
CostPrice SalesPrice
Television 4 20000 24000
AC
3 150000 180000
Any body help me
Thanks in advanced.
Best regards,
Muzammil Hussain
Recent Activity
13
New MembersVisit Your Group
Yahoo! Finance
It's Now Personal
Guides, news,
advice & more.
New business?
Get new customers.
List your web site
in Yahoo! Search.
Get in Shape
on Yahoo! Groups
Find a buddy
and lose weight.
.
New Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
Own a website.Get an unlimited package.Pay next to nothing.*Go to
http://in.business.yahoo.com/
