Author Topic: generating distinct and over() in report studio  (Read 450 times)

Offline lucky123

  • Associate
  • **
  • Posts: 1
  • Forum Citizenship: +0/-0
generating distinct and over() in report studio
« on: 01 Dec 2011 10:49:13 pm »
Hello All,
            I have a query item which is the sum of two other query items(eg: sales_amt+overhead_amt). When I use this query item in report studio it is generation a query with distinct and ove() by clause. It is killing the DB. I would appreciate your feedback on this issue.
Thanks