Help getting rid of unwanted group by
I'm working on Discoverer Desktop 10.1.2.1 with Oracle Database 10.2.0.4.0.
If I'm creating a summary type report and include items
item_number
onhand - sum
cost - detail
I'll get sql (Vew/Sql Inspector) like the following:
select item_number, cost, sum(onhand)
from <whatever>
group by item_number, cost
Now, I save my report and realize that I wanted to include cost - sum rather than cost - detail. So I remove cost - detail as a selected item and replace it with cost - sum. Now I check my sql (Vew/Sql Inspector) and it's still grouping by item_number, cost.
select item_number, cost, sum(onhand), sum(cost)
from <whatever>
group by item_number, cost
Any ideas what might be causing this behaviour?
-Tracy