COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: pradeepbi25 on 08 Oct 2014 02:37:02 PM

Title: Data jumbling issue
Post by: pradeepbi25 on 08 Oct 2014 02:37:02 PM
I have a crosstab report with two rows and 4 columns and a total column and subtotal column.

When I ran the report for the first time, data is good.
When I ran the report for second time(immediately or after few mins) data is not matching with the first report. Few rows are having jumbled data.
So, the issue is data is jumbled when report runs second time.

When I removed the totals and subtotals in the crosstab report I am not getting this issue.

Please help with this wierd issue.
Title: Re: Data jumbling issue
Post by: pradeepbi25 on 09 Oct 2014 09:27:44 AM
I fixed the issue by removing sort order on rows and applying pre-sort on data items.
Thanks