[BUG] GROUPING DOES NOT WORK

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

CUSTOMER USERNAME: FRANK32
ORDER #83380

WE CANNOT GROUP ON DATE FIELDS AS IN OUTLOOK (I.E. YESTERDAY, LAST WEEK, LAST MONTH, ETC.)  EXCEPT BY ADDING RECORDS MANUALLY TO RC WHICH IS NOT AN OPTION FOR US BECAUSE WE HAVE A LARGE NUMBER OF RECORDS TO DISPLAY.

PLEASE HAVE THIS BUG FIXED ASAP!

RC has three modes to populate with records:

1. Virtual Mode

1.1 Virtual Mode is Fast.
1.2 BUT IT ISN'T POSSIBLE TO GROUP IN VIRTUAL MODE. SO THIS CAN't BE AN OPTION FOR US.

2. Adding Records and Items Manually
2.1 This is the only mode when the grouping on date fields as described above works. 
2.2 HOWEVER THIS IS ALSO NOT AN OPTION BECAUSE IT SIMPLY TAKES TOO LONG TO LOAD THE RECORDS ( > 120,000 RECORDS).

3. Binding RC with a recordset
3.1. THIS MODE IS SLOW FOR LARGE NUMBERS OF RECORDS.
3.2. [B U G] THE GROUPIING ON DATE FIELDS DOES NOT WORK AS WELL AS DESCRIBED ABOVE. TRY GROUPING ON THE DATE FIELD OF YOUR DATABINDING EXAMPLE USING THE DATE GROUPING IN YOUR OUTLOOK 2003 EXAMPLE.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
reims_rep Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15 February 2011 Status: Offline Points: 7	Post Options Post Reply Quote reims_rep Report Post Thanks(0) Quote Reply Topic: [BUG] GROUPING DOES NOT WORK Posted: 27 February 2011 at 2:43pm
	CUSTOMER USERNAME: FRANK32 ORDER #83380 WE CANNOT GROUP ON DATE FIELDS AS IN OUTLOOK (I.E. YESTERDAY, LAST WEEK, LAST MONTH, ETC.) EXCEPT BY ADDING RECORDS MANUALLY TO RC WHICH IS NOT AN OPTION FOR US BECAUSE WE HAVE A LARGE NUMBER OF RECORDS TO DISPLAY. PLEASE HAVE THIS BUG FIXED ASAP! RC has three modes to populate with records: 1. Virtual Mode 1.1 Virtual Mode is Fast. 1.2 BUT IT ISN'T POSSIBLE TO GROUP IN VIRTUAL MODE. SO THIS CAN't BE AN OPTION FOR US. 2. Adding Records and Items Manually 2.1 This is the only mode when the grouping on date fields as described above works. 2.2 HOWEVER THIS IS ALSO NOT AN OPTION BECAUSE IT SIMPLY TAKES TOO LONG TO LOAD THE RECORDS ( > 120,000 RECORDS). 3. Binding RC with a recordset 3.1. THIS MODE IS SLOW FOR LARGE NUMBERS OF RECORDS. 3.2. [B U G] THE GROUPIING ON DATE FIELDS DOES NOT WORK AS WELL AS DESCRIBED ABOVE. TRY GROUPING ON THE DATE FIELD OF YOUR DATABINDING EXAMPLE USING THE DATE GROUPING IN YOUR OUTLOOK 2003 EXAMPLE.

reims_rep Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15 February 2011 Status: Offline Points: 7	Post Options Post Reply Quote reims_rep Report Post Thanks(0) Quote Reply Posted: 27 February 2011 at 2:47pm
	I have already posted a couple of items in your forums BUT: 1. I never got any reply or whatsoever that they are being queued for action or what. 2. I didn't even get an automatic email indicating that you received, rejected, discarded, or ignored them. I am expecting someone from your side to notify me what your intended action on the issue I posted above and when you intend to take action on it. This is especially important because the feature cannot be excluded in our software release.

Oleg Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 21 May 2003 Location: United States Status: Offline Points: 11234	Post Options Post Reply Quote Oleg Report Post Thanks(0) Quote Reply Posted: 28 February 2011 at 3:32am
	Hello, Forum is primary place where developers exchange knowledge. http://forum.codejock.com/forum_posts.asp?TID=14125 Please use http://support.codejock.com or http://codejock.com/support/ for Codejock support.
	Oleg, Support Team CODEJOCK SOFTWARE SOLUTIONS

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 03 March 2011 at 8:51am
	As I think you seen in the Report Sample, to get this type of sub grouping you have to set some properties of that ReportRecordItem. I think your best option would be to use BeforeDrawRow. Below is a quick sample you can try, it sets based on Row index, but you would instead check the date and set the correct priority. Private Sub wndReportControl_BeforeDrawRow(ByVal Row As XtremeReportControl.IReportRow, ByVal Item As XtremeReportControl.IReportRecordItem, ByVal Metrics As XtremeReportControl.IReportRecordItemMetrics) If Not Item Is Nothing Then If Item.Index = COLUMN_RECEIVED Then If Row.Index Mod 2 Then Item.GroupCaption = "Date: Today" Item.GroupPriority = 0 ElseIf Row.Index Mod 3 Then Item.GroupCaption = "Date: This Month" Item.GroupPriority = 1 Else Item.GroupCaption = "Date: Older" Item.GroupPriority = 3 End If End If End If End Sub

reims_rep Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15 February 2011 Status: Offline Points: 7	Post Options Post Reply Quote reims_rep Report Post Thanks(0) Quote Reply Posted: 04 March 2011 at 3:30am
	Hi SuperMario, You may have not really investigated what I meant. Your reply is just lifted from the CJ samples which of course I Have tried already before posting my problem here. I'll attach samples for each of the scenarios I refer to above so that it would be easier for everyone to verify my claims.

Alex G. Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 22 December 2004 Location: Germany Status: Offline Points: 74	Post Options Post Reply Quote Alex G. Report Post Thanks(0) Quote Reply Posted: 09 March 2011 at 2:35pm
	The question is why it's not possible ? I would like to use grouping as well, my datasets are even bigger, > 2,000,000 records...