SQL and Query objects

[rajivgupta1107]

Hi All

I am using SQL object in my report for some sql query. The SQL is automatically giving its output to query:

Query <- SQL

I i see the generated SQL for the query , its something like this:

Select distinct sql1.col from (select col from table) sql1

But i want to display all the records , not the distince. Pls tell me.

[blom0344]

If you only fetch one attribute, then Cognos is smart enough to understand that you do not want duplicates and adds a distinct to the SQL clause. Since you are just fetching one column value, why o why would you be interested in seeing duplicates? ???

[the_xxx]

Hi Rajiv...Just change the "Auto Group & Summarize" property of a query to No. You should be able to see all the roow :)