Codejock Developer Community : Problem Sorting Column in Virtual Mode http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 04:28:01 +0000 Tue, 27 Apr 2010 12:29:24 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=16630 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Problem Sorting Column in Virtual Mode : Thanks fo your response. I will...]]> http://forum.codejock.com/forum_posts.asp?TID=16630&PID=58235&title=problem-sorting-column-in-virtual-mode#58235 Author: Setiawan
Subject: 16630
Posted: 27 April 2010 at 12:29pm

Thanks fo your response. I will try ...]]> Tue, 27 Apr 2010 12:29:24 +0000 http://forum.codejock.com/forum_posts.asp?TID=16630&PID=58235&title=problem-sorting-column-in-virtual-mode#58235 <![CDATA[Problem Sorting Column in Virtual Mode : Hi, Your &#034;trouble&#034;...]]> http://forum.codejock.com/forum_posts.asp?TID=16630&PID=58208&title=problem-sorting-column-in-virtual-mode#58208 Author: Aaron
Subject: 16630
Posted: 26 April 2010 at 12:19pm

Hi,
 
Your "trouble" is what we all wish to have with virtual report...  
 
The case is that you can't have:
  1. Sorting
  2. Grouping

in virtual mode. The only thing you do have is: SPEED and some nice options to change contents of ReportItem in BeforeDrawRow event.

If you want sorting you have to do it yourself... You could sort your array (clicking column and BeforeDrawRow event will take care of the rest) or load array into a recordset and create SQL string to sort recordset. There are lot of options but not with ReportControl itself.
 
Try to search forum with virtualmode, there are a lot of samples and discussions
See also Samples subforum
 
 
 
]]> Mon, 26 Apr 2010 12:19:27 +0000 http://forum.codejock.com/forum_posts.asp?TID=16630&PID=58208&title=problem-sorting-column-in-virtual-mode#58208 <![CDATA[Problem Sorting Column in Virtual Mode : I&#039;m having trouble using...]]> http://forum.codejock.com/forum_posts.asp?TID=16630&PID=58197&title=problem-sorting-column-in-virtual-mode#58197 Author: Setiawan
Subject: 16630
Posted: 25 April 2010 at 12:49pm

I'm having trouble using CJ ReportControl with Virtual Mode. I have 15.000 records stored internally in multidimensional Array. I'm using VirtualMode to display all record ( amazing speed).  But when I click on a column the sorting didn't work. Anyone can help me?
 
I'm using VB 6.0 and CJ ActiveX 13.3.1 Thanks before ...
 
Illustration
 
Form Load :
 
Dim Column As ReportColumn
 
Set Column = wndReportControl.Columns.Add(0, "Column 1", 50, True) ' Number
Set Column = wndReportControl.Columns.Add(1, "Column 2", 100, True) ' String
Set Column = wndReportControl.Columns.Add(2, "Column 3", 100, True) ' Date
Set Column = wndReportControl.Columns.Add(3, "Column 4", 100, True) ' String
Set Column = wndReportControl.Columns.Add(4, "Column 5", 200, True) ' String
 
Command Bar (Load Data)  :
 
ReDim dimension(0 To TotalRecord, 4)
...
....
 
wndReportControl.SetVirtualMode TotalRecord, 5
wndReportControl.Populate
wndReportControl.SetCustomDraw xtpCustomBeforeDrawRow
 
wndReportControl_BeforeDrawRow
 
Dim RowIndex As Long
RowIndex = row.Index
Metrics.Text = dimensi(RowIndex, Item.Index)
 
 
]]> Sun, 25 Apr 2010 12:49:10 +0000 http://forum.codejock.com/forum_posts.asp?TID=16630&PID=58197&title=problem-sorting-column-in-virtual-mode#58197