Hi everyone,
I'm trying to migrate a report from an existing solution to Cognos. Lucky for me, the existing solution provides us with the SQL used to generate the report, so for those reports we just have to copy paste the SQL into Cognos, and voilà. The report is a simple list regarding billing, nothing fancy.
For this specific case we are having a problem, as the Cognos report has less lines than the original one. I have pinpointed the problem to duplicated lines that Cognos aggregates, even when I specify that there should be no aggregation for every column of the report. I went through the properties of each column and selected "None" for both the aggregation options.
I have attached a picture of the problem. On top is the 2 lines generated in Cognos, on the bottom is the 4 lines I get if I execute the SQL directly on the database.
Any idea on what I could do to fix this ?
Try turning off the auto group and summarise property in the query properties.
I found the solution.
In the properties of all the data items, I had to select Detail > No.