Codejock Developer Community : How to read userselected constraints http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 27 Apr 2026 14:26:16 +0000 Thu, 27 Apr 2006 02:57:13 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=4044 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[How to read userselected constraints : Hi, It works!! i am working with...]]> http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12449&title=how-to-read-userselected-constraints#12449 Author: cmaxmedia
Subject: 4044
Posted: 27 April 2006 at 2:57am

Hi, It works!!

i am working with adodb.7 recordsets to fill the user data into the report as follows:



Set Record = .Records.Add
Set Item = Record.AddItem("")
              
Set Item = Record.AddItem(CStr(MyRS("strCommunicationType")))
Item.Caption = CStr(MyRS("strCommunicationType"))
Set Item = Record.AddItem(MyRS("strValue"))
Item.Caption = MyRS("strValue")
Set Item = Record.AddItem("")
Item.Caption = NZ("")
Set Item = Record.AddItem(MyRS("ysnMain"))
Item.HasCheckbox = True
Item.Checked = MyRS("ysnMain")

Record.AddItem ""
Record.PreviewText = MyRS("ID")
Record.Tag = MyRS("ID")

take a look at the code line 3 and 4. now i am using the cstr() vb-command AND => it works

Thank you for your support.
markus

]]> Thu, 27 Apr 2006 02:57:13 +0000 http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12449&title=how-to-read-userselected-constraints#12449 <![CDATA[How to read userselected constraints : in your sample code, it fires...]]> http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12407&title=how-to-read-userselected-constraints#12407 Author: sserge
Subject: 4044
Posted: 25 April 2006 at 2:13pm

in your sample code, it fires ValueChanged if you change any item, but you should iterate constraints for your "Typ" column item. So far, it should be working if you change it in a following way:

Set Column = Me.wndReportControl.Columns.Add(1, "Typ", 150, True)
Column.EditOptions.Constraints.Add "Phone", 1
Column.EditOptions.Constraints.Add "Email", 2
Column.EditOptions.Constraints.Add "Homepage", 3
Column.EditOptions.AddComboButton



Private SubReportControl_ValueChanged(ByVal Row As XtremeReportControl.IReportRow,ByVal Column As XtremeReportControl.IReportColumn, ByVal Item AsXtremeReportControl.IReportRecordItem)
 If Item.Index = 1 Then
  For Each c In wndReportControl.Columns(Item.Index).EditOptions.Constraints
      Debug.Print c.Caption 
  Next
 End If
End Sub


My previous piece of code works fine if you insert it into standard ReportSample, _ValueChanged handler.

If it still doesn't work for you, try attaching your sample and I'll check it up.

--
WBR,
Serge
]]> Tue, 25 Apr 2006 14:13:46 +0000 http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12407&title=how-to-read-userselected-constraints#12407 <![CDATA[How to read userselected constraints : oh sorry, i have currently checked,...]]> http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12397&title=how-to-read-userselected-constraints#12397 Author: cmaxmedia
Subject: 4044
Posted: 25 April 2006 at 3:53am

oh sorry, i have currently checked, that this is the wrong forum for activex com  .

i'd be very pleased, if you can send me a code sample

kind regards
Markus

]]> Tue, 25 Apr 2006 03:53:17 +0000 http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12397&title=how-to-read-userselected-constraints#12397 <![CDATA[How to read userselected constraints : hi,thank you for your reply, but...]]> http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12380&title=how-to-read-userselected-constraints#12380 Author: cmaxmedia
Subject: 4044
Posted: 24 April 2006 at 8:28am

hi,
thank you for your reply, but your the returned array is empty so the debug.print will not be fired.

I fill the column constraints as follows:

        Set Column = Me.wndReportControl.Columns.Add(1, "Typ", 150, True)
        Column.EditOptions.AddComboButton
        Column.EditOptions.Constraints.Add "Phone", 1
        Column.EditOptions.Constraints.Add "Email", 2
        Column.EditOptions.Constraints.Add "Homepage", 3

I have tried the following code:
Private Sub ReportControl_ValueChanged(ByVal Row As XtremeReportControl.IReportRow, ByVal Column As XtremeReportControl.IReportColumn, ByVal Item As XtremeReportControl.IReportRecordItem)

For Each c In wndReportControl.Columns(Item.Index).EditOptions.Constraints
    Debug.Print c.Caption  '<= there's no debugger output
Next

End Sub

i am working with Codejock XTreme Suite Pro ActiveX V9.81
thank you for your support
Kind regards
Markus

]]> Mon, 24 Apr 2006 08:28:08 +0000 http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12380&title=how-to-read-userselected-constraints#12380 <![CDATA[How to read userselected constraints : Just iterate constraints for an...]]> http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12377&title=how-to-read-userselected-constraints#12377 Author: sserge
Subject: 4044
Posted: 24 April 2006 at 7:51am

Just iterate constraints for an appropriate column, which index is an item index. See below:


For Each c In wndReportControl.Columns(Item.Index).EditOptions.Constraints
    Debug.Print c.Caption
Next


--
WBR,
Serge

]]> Mon, 24 Apr 2006 07:51:36 +0000 http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12377&title=how-to-read-userselected-constraints#12377 <![CDATA[How to read userselected constraints : Hi, thanx for your answer, the...]]> http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12376&title=how-to-read-userselected-constraints#12376 Author: cmaxmedia
Subject: 4044
Posted: 24 April 2006 at 7:37am

Hi,

thanx for your answer, the constaints are defined for each column. How can i get the currently selected Constaint of the item, the user is editing?

kind regards
Markus

]]> Mon, 24 Apr 2006 07:37:01 +0000 http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12376&title=how-to-read-userselected-constraints#12376 <![CDATA[How to read userselected constraints : Hi, Iterate editing constraints...]]> http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12375&title=how-to-read-userselected-constraints#12375 Author: sserge
Subject: 4044
Posted: 24 April 2006 at 7:16am

Hi,

Iterate editing constraints you can in a following way, depending whether you set them for a column or for an item:

Dim c As ReportRecordItemConstraint
For Each c In Item.EditOptions.Constraints ' or wndReport.Columns(column_index).EditOptions.Constraints
    Debug.Print c.Caption
Next


--
WBR,
Serge
]]> Mon, 24 Apr 2006 07:16:25 +0000 http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12375&title=how-to-read-userselected-constraints#12375 <![CDATA[How to read userselected constraints : If I have added a contstraint...]]> http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12362&title=how-to-read-userselected-constraints#12362 Author: cmaxmedia
Subject: 4044
Posted: 22 April 2006 at 6:49am

If I have added a contstraint to the first column of the reportcontrol like this:

    Column.EditOptions.AddComboButton
    Column.EditOptions.Constraints.Add "Phone", 1
    Column.EditOptions.Constraints.Add "Email", 2
    Column.EditOptions.Constraints.Add "Homepage", 3

now i want to get the user selection for an item in the reportcontrol-list with about 15 lines.

for reading the user value i am working like this

Private Sub ReportControl_ValueChanged(ByVal Row As XtremeReportControl.IReportRow, ByVal Column As XtremeReportControl.IReportColumn, ByVal Item As XtremeReportControl.IReportRecordItem)

   'this part works fine, if not constraints exists in column object
   Msgbox Item.Caption

   'now i'd like to read the user input, when a Constraints Dropdowncombo exists like
   Msgbox Item.SelectedConstraints.Value ?

End Sub

Kind regards

]]> Sat, 22 Apr 2006 06:49:08 +0000 http://forum.codejock.com/forum_posts.asp?TID=4044&PID=12362&title=how-to-read-userselected-constraints#12362