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

Offline lucky123

  • Associate
  • **
  • Join Date: Dec 2011
  • Posts: 2
  • Forum Citizenship: +0/-0
generating distinct and over() in report studio
« on: 01 Dec 2011 11: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

 


       
Twittear