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.
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? ???
Hi Rajiv...Just change the "Auto Group & Summarize" property of a query to No. You should be able to see all the roow :)