November 5, 2009 at 10:25 pm
Hello Everybody...
I have designed a query which contains groupings,aggregates and Joins.
Now When I execute this query a value from a joined table comes repeatedly because of other groups.
Now I want to get this value as a single.
Example:
A.Code B.Name C.Production D.Issued X.Opening Qty
------------------------------------------------------------------------------
AAA BBB 10000 5200 5000
AAA BBA 7800 3000 5000
AAA CCC 4500 1250 5000
===> X.Opening Qty table contains only single entry per month
===> Table A,B,C and D contains contains entry per day.
===> How can we get that x.OpeningQty of 5000 As a Single, It should not display more than once.
Because of I want to use this query in Report.
Thanks In Advance.
ßhavin.
November 5, 2009 at 11:23 pm
It would be impossible to do what you ask while still returning B.Name and without performing aggregation on C.Production & D.Issued.
Assuming I understand that you would like one row returned to use in a report, would you mind posting an example of the format you would like this row to take?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply