Include Summary Column in select statement condition...

[bgreen]

Hi,

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?

 

[sem]

The syntax is

select <fields>, <agregate> from <table>
where <simple condition>
group by <fields>
having <agregate condition>

Regards, Dima

http://seminihin.narod.ru

 

[bgreen]

The summary column is not part of the select statement. It is a separate entity which has been created at a group level.

CS_COUNT...

would I use &CS_COUNT or :CS_COUNT or can I do it at all.

 

[sem]

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.

Regards, Dima

http://seminihin.narod.ru

 

[nagornyi]

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.