Codejock Developer Community : Sorting in ReportControl

Sorting in ReportControl : Hi Zitz, I just read your answer,...

Wed, 13 May 2009 09:29:30 +0000

Author: Sergio
Subject: 8741
Posted: 13 May 2009 at 9:29am

Hi Zitz,

I just read your answer, sorry for the long delay.

Yes, I confirm that ReSortRows() works and fix the problem. (We did the same.)

Thank you for your answer.

Regards,

Sorting in ReportControl : Hi, Serqio.I solve this problem...

Sun, 05 Oct 2008 07:24:25 +0000

Author: zitz
Subject: 8741
Posted: 05 October 2008 at 7:24am

Hi, Serqio.
I solve this problem by calling ReSortRows() after Populate()
(Xtreme ToolkitPro v11.2.0)

void CReportControlEx::Populate()
{
CXTPReportControl::Populate();
ReSortRows();
}

Sorting in ReportControl : Hi, Now, I know more about this...

Wed, 09 Jul 2008 04:16:09 +0000

Author: Sergio
Subject: 8741
Posted: 09 July 2008 at 4:16am

Hi,

Now, I know more about this issue.

This problem doesn't occur if you clear the sort before modifying records.

Here is my code :

============

////////////////////////////////////////////////////
// Clear sort
////////////////////////////////////////////////////
int nTopRow = m_pRP->GetTopRowIndex(); // store the first displayed row index
CXTPReportColumnOrder* pSortOrder = m_pRP->GetColumns()->GetSortOrder();

CArray aReportColumns;
CArray aSortAscending;
for (int i=0; iGetCount(); i++)
{
aReportColumns.Add(pSortOrder->GetAt(i));
aSortAscending.Add(pSortOrder->GetAt(i)->IsSortedIncreasing());
}

m_pRP->FClearSort();

////////////////////////////////////////////////////
// ...
// Modify records and child records
// ...
////////////////////////////////////////////////////

////////////////////////////////////////////////////
// Restore sort
////////////////////////////////////////////////////
for (int i=0; i{
m_pRP->GetColumns()->InsertSortColumn(aReportColumns.GetAt(i));
aReportColumns.GetAt(i)->SetSortIncreasing(aSortAscending.GetAt(i));
}

m_pRP->FRefreshSort();
m_pRP->SetTopRow(nTopRow); // Restore the index of the first displayed row of the report

Sorting in ReportControl : Hi, I have just downloaded...

Wed, 02 Jul 2008 12:10:34 +0000

Author: Sergio
Subject: 8741
Posted: 02 July 2008 at 12:10pm

Hi,

I have just downloaded and checked this issue with the MFC Codejock Release 12.0.0.

There is still the same problem.

Have you been able to reproduce this problem ?

Sorting in ReportControl : Hi, Any news ?

Mon, 16 Jun 2008 10:10:22 +0000

Author: Sergio
Subject: 8741
Posted: 16 June 2008 at 10:10am

Hi,

Any news ?

Sorting in ReportControl : While looking inside using the...

Wed, 16 Apr 2008 08:14:07 +0000

Author: Sergio
Subject: 8741
Posted: 16 April 2008 at 8:14am

While looking inside using the debugger, it seems that there's a confusion between these Rows arrays :

- CXTPReportRows* m_pPlainTree

- CXTPReportRows* m_pRows

They both hold pointers to the same object, but the CXTPReportRow class can hold only one parent Rows.

I have tried to force the refresh of indexes, using a class overriden from the CXTPReportControl one :

void CMyXTPReportControl::RefreshDisplay()
{
m_bRefreshIndexes = TRUE;

Populate();

     m_pHeaderRows->RefreshChildIndices(TRUE);
     m_pRows->RefreshChildIndices(TRUE);
     m_pFooterRows->RefreshChildIndices(TRUE);

m_pPlainTree->RefreshChildIndices(TRUE);

m_arrScreenRows.RefreshChildIndices(TRUE);
}

void CMyXTPReportControl::RefreshSort()
{
m_bRefreshIndexes = TRUE;

ReSortRows();

     m_pHeaderRows->RefreshChildIndices(TRUE);
     m_pRows->RefreshChildIndices(TRUE);
     m_pFooterRows->RefreshChildIndices(TRUE);

m_pPlainTree->RefreshChildIndices(TRUE);

m_arrScreenRows.RefreshChildIndices(TRUE);
}

But it just moved the problem...

H E L P !

Sorting in ReportControl : Hi, In fact, there's really...

Tue, 11 Mar 2008 07:07:17 +0000

Author: Sergio
Subject: 8741
Posted: 11 March 2008 at 7:07am

Hi,

In fact, there's really a bug in Release mode :

Hope to get an answer now...

Sorting in ReportControl : Hi, We have the same problem. It...

Wed, 13 Feb 2008 06:07:42 +0000

Author: Sergio
Subject: 8741
Posted: 13 February 2008 at 6:07am

Hi,

We have the same problem.

It seems to be linked to the sorted column.

This error comes when you add a child record, with the SetSortRecordChilds(TRUE) activated, and with one or more columns sorted.

If no column is sorted, the problem doesn't occur.

We think that's a bug of the Report Control.

Regards,

Sorting in ReportControl : I recently turned on sort for...

Fri, 09 Nov 2007 17:23:03 +0000

Author: myddyn
Subject: 8741
Posted: 09 November 2007 at 5:23pm

I recently turned on sort for child by using SetSortRecordChilds(TRUE);

and now get an ASSERT in the follow function.

CXTPReportRow* CXTPReportRow::GetNextSiblingRow() const

{

if (!m_pParentRows)

return 0;

if (m_nChildIndex == -1)

return 0;

ASSERT(m_pParentRows->GetAt(m_nChildIndex) == this);

if (m_nChildIndex < m_pParentRows->GetCount() - 1)

return m_pParentRows->GetAt(m_nChildIndex + 1);

return 0;

}

After doing a little debug, it seem that the record it is getting the

itself because the record has moved but the index is the same. If I ignore all the ASSERT the program and sort execute correctly. If I take out the code that moves the children around it works correctly.