Report Control - [BUG] GROUPING DOES NOT WORK

Print Page | Close Window

[BUG] GROUPING DOES NOT WORK

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=17965
Printed Date: 20 January 2025 at 8:43pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: [BUG] GROUPING DOES NOT WORK

Posted By: reims_rep
Subject: [BUG] GROUPING DOES NOT WORK
Date 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.

Replies:

Posted By: reims_rep
Date 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.

Posted By: Oleg
Date 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&FID=113&PR=3&title=notice-codejock-support-policy - http://forum.codejock.com/forum_posts.asp?TID=14125

Please use http://support.codejock.com - http://support.codejock.com or http://codejock.com/support/ - http://codejock.com/support/ for Codejock support.

-------------
Oleg, Support Team
CODEJOCK SOFTWARE SOLUTIONS

Posted By: SuperMario
Date 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

Posted By: reims_rep
Date 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.

Posted By: Alex G.
Date 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...