I want to include a summary column which is imbedded in the select statement included in the conditional statement (Where statement). How do I do this?
No, I think this is impossible; in this case the value is calculated on client side after your result set has been retreived.
But you may create report trigger to "hide" rows according to some condition based on that aggregate field.
Though you are getting the summaryi in the report, you can get the same in the SQL also and then do what Dima advised. Another option would be to create a second query in the report (ref cursor query), and link it to the first query using summaty collumn as parameter.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.