Codejock Developer Community : Grouping question.....

Grouping question..... : Ok Serge, Thanks for the suggestions....

Thu, 27 Apr 2006 09:19:19 +0000

Author: flauzer
Subject: 4071
Posted: 27 April 2006 at 9:19am

Ok Serge, Thanks for the suggestions.

I was thinking about writing some code that doesn't depend on the items, but really of the property of the column: in fact I could write a "filter-function" during the loading of the items to resolve the matter of the case-insensitive items....

for example (in vb) str = Ucase(str).

But if you have a grid that "binds" some generic-recordsets it's difficult to work with the items,..... it would be better a property that says "group items in case-insensitive mode...".

I hope to have been enough clear (excuse my English)

I think that this property could be useful....If you could add it to a 10.2.....it would be appreciated

Thanks

Grouping question..... : Try following example. Place wndReport...

Thu, 27 Apr 2006 05:56:15 +0000

Author: sserge
Subject: 4071
Posted: 27 April 2006 at 5:56am

Try following example. Place wndReport to clear Form1:


Private Sub Form_Load()
    wndReport.Columns.Add 0, "Items", 50, True
    wndReport.Columns.Add 1, "Proj", 100, True
    
    wndReport.ShowGroupBox = True
    
    Dim Record As ReportRecord
    Dim Item As ReportRecordItem
    Dim str As String
    
    For i = 1 To 16
        Set Record = wndReport.Records.Add
    
        str = "Item " & CStr(i)
        Set Item = Record.AddItem(str)
        
        str = "project 1"
        If i > 4 Then str = "Project 1"
        If i > 8 Then str = "Project 2"
        If i > 12 Then str = "project 2"
        Set Item = Record.AddItem(str)
        If i > 8 Then
              Item.GroupPriority = 2
              Item.GroupCaption = "Title for Project 2"
        Else
              Item.GroupPriority = 1
              Item.GroupCaption = "Title for Project 1"
        End If
    Next i

    wndReport.Populate
End Sub

--
WBR,
Serge

Grouping question..... : Sorry, Serge I don't understand.... suppose...

Thu, 27 Apr 2006 05:13:55 +0000

Author: flauzer
Subject: 4071
Posted: 27 April 2006 at 5:13am

Sorry, Serge I don't understand....

suppose you have 5 columns, and the user drag one column 'PROJ' for grouping....

We can see:

PROJ

PROJ: Project 1

item1
item2
...

PROJ: project 1

item3
item4
...

How to make 'PROJ' column case-insensitive, so that items for

Project1 and project1 belong to the same group????

Have you an example?

Thanks

Grouping question..... : Try using SortPriority + GroupPriority...

Thu, 27 Apr 2006 04:19:42 +0000

Author: sserge
Subject: 4071
Posted: 27 April 2006 at 4:19am

Try using SortPriority + GroupPriority properties, it seems to do what you want.

--
WBR,
Serge

Grouping question..... : Is there a way to have case-insensitive...

Thu, 27 Apr 2006 03:52:01 +0000

Author: flauzer
Subject: 4071
Posted: 27 April 2006 at 3:52am

Is there a way to have case-insensitive groups?

In other words, its possible to have a property ReportColumn.CompareMethod

in which I can set for example.....CompareMethod = optTextCompare

In 10.2 ???

Thanks