Having Clause in Report Studio

[ari_meta]

HI


In my SQL Query, I have having clause. When I put it in report studio filter. It appears as a where clause in Native SQL . Even, I have tried to put both  in summary or in detail filters .
Any help to resolve this will be highly appreciated.

Thanks


Gary 

[addpremkumar]

Can you please give me an example for what exactly you are looking for. So I can help you.

In Report Studio we dont have an option called "Having", by using an option "for" we will calculate the totals or counts.

Ex: Count( [Emp] for [Dept] )

[blom0344]

Cognos allows you to define post-aggregation filters where the server can filter AFTER the SQL is executed. These filters do not show up in native SQL.
Use straightly injected SQL is not the way to go. Use Cognos modelling and benefit from the tool like you would want to  !!