http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 02 May 2026 00:12:17 +0000 Tue, 01 Sep 2015 04:10:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=22701 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73841&title=moving-columns#73841 Author: skiman
Subject: 22701
Posted: 01 September 2015 at 4:10am

Hi,

Thanks, I missed this ItemIndex property.

So no need anymore to keep the original index in the KEY property.
]]> Tue, 01 Sep 2015 04:10:49 +0000 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73841&title=moving-columns#73841 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73840&title=moving-columns#73840 Author: olebed
Subject: 22701
Posted: 31 August 2015 at 11:08am

Sorry, I meant  ItemIndex Property of ReportColumn Object.
From documentation

Remarks This is the index of the column given when added to the ReportControl's collection of columns. The ItemIndex starts at 0 and increments by 1 for each column in the ReportControl. The ItemIndex will not change when the columns are moved (dragged and dropped to another location). The ItemIndex is used to find and return a reference to a column. Since the Index of the column might change frequently, the ItemIndex is used when the column needs to be accessed.

]]> Mon, 31 Aug 2015 11:08:21 +0000 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73840&title=moving-columns#73840 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73838&title=moving-columns#73838 Author: skiman
Subject: 22701
Posted: 31 August 2015 at 3:48am

You wrote:When you move columns their indexes are not changed, just their order. So C5 - always points to the column with index 5.

I'm using the active-x evaluation version  16.4.0, and the index IS CHANGING when moving columns. I tested as follows:
When creating the columns:
oColumn := oReport:Columns:add(0, "Category", 12, .t.)
oColumn:key := str(oColumn:index,2)
...

So I put the index for each column in the KEY property.

When the report is created, I do the following:
nCols := oReport:Columns:Count -1
for x = 0 to nCols
    show oReport:columns(x):index
    show oReport:columns(x):key
next
For each column, the index is equal to the key.

When I move a column, and checks it again, the INDEX is changed. The index isn't corresponding anymore to the KEY which obviously isn't changed.

This behaviour poses a lot of problems when columns with subtotals are moved. This is why I need to change the formula. I'm using the value in the KEY property to define which column must have subtotals.

Since the data shown is still correct, there must be a property that knows which item of the record must be shown. After moving a column for 4 to column 2, the index is changed. However it is still oRecord:item(4) which is shown.







]]> Mon, 31 Aug 2015 03:48:09 +0000 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73838&title=moving-columns#73838 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73821&title=moving-columns#73821 Author: olebed
Subject: 22701
Posted: 28 August 2015 at 11:33am

When you move columns their indexes are not changed, just their order. So C5 - always points to the column with index 5.]]> Fri, 28 Aug 2015 11:33:10 +0000 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73821&title=moving-columns#73821 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73820&title=moving-columns#73820 Author: skiman
Subject: 22701
Posted: 28 August 2015 at 8:24am

Hi,

I'm using the active-x version.

I tried to change the groupformula of the grouprow dynamically when a column is moved.
Sample:
formula SUMSUB(C5:C6) is changed to SUMSUB(C3:C4) when the column is moved. The subtotals are moving, but strangely they remains now zero. I have no clue what the cause of this behaviour could be.

]]> Fri, 28 Aug 2015 08:24:05 +0000 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73820&title=moving-columns#73820 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73816&title=moving-columns#73816 Author: olebed
Subject: 22701
Posted: 28 August 2015 at 6:26am

Hello Chris,

Subtotals are linked to appropriate columns.

If you have access to C++ project  then you can change this behaviour in CXTPReportPaintManager::DrawGroupRow method (toolkitpro\Source\ReportControl\XTPReportPaintManager.cpp). Index of appropriate column is in iCol variable.

Regards,
Oleksandr Lebed]]> Fri, 28 Aug 2015 06:26:59 +0000 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73816&title=moving-columns#73816 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73807&title=moving-columns#73807 Author: skiman
Subject: 22701
Posted: 26 August 2015 at 9:30am

Hi,

I have a report control with the same columns as in the following sample screenshot.


If I move the column Sales and put it between 'Product' and 'State' the grouptotal remains in the same column, which is state at that moment.

How can I be sure that my subtotals remains in the same column as originally at startup?


]]> Wed, 26 Aug 2015 09:30:58 +0000 http://forum.codejock.com/forum_posts.asp?TID=22701&PID=73807&title=moving-columns#73807