Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - Grouping question.....
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Grouping question.....
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
flauzer View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 December 2003
Location: Italy
Status: Offline
Points: 108 		Post Options Post Options   Thanks (0) Thanks(0)   Quote flauzer Quote  Post ReplyReply Direct Link To This Post Topic: Grouping question.....
    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

 

 
Back to Top
sserge View Drop Down
Moderator Group
Moderator Group


Joined: 01 December 2004
Status: Offline
Points: 1297 		Post Options Post Options   Thanks (0) Thanks(0)   Quote sserge Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2006 at 4:19am
Try using SortPriority + GroupPriority properties, it seems to do what you want.

--
WBR,
Serge
Back to Top
flauzer View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 December 2003
Location: Italy
Status: Offline
Points: 108 		Post Options Post Options   Thanks (0) Thanks(0)   Quote flauzer Quote  Post ReplyReply Direct Link To This Post 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

 

 
Back to Top
sserge View Drop Down
Moderator Group
Moderator Group


Joined: 01 December 2004
Status: Offline
Points: 1297 		Post Options Post Options   Thanks (0) Thanks(0)   Quote sserge Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
flauzer View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 December 2003
Location: Italy
Status: Offline
Points: 108 		Post Options Post Options   Thanks (0) Thanks(0)   Quote flauzer Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.047 seconds.