Report Control grouping problem

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

   Greetings everyone,
I am using the report control from Xtreme SuitePro v11.2.2 (XP SP2, VB6 SP6), and am stumped.
What I am trying to do is obtain the column values for a row that the user left clicks on.
Unless I am missing something, when I have rows grouped, trying to obtain the column values of a row that a user clicks on brings the wrong values.
Using the report sample example that came with the package as a base to work and learn with, I have added the following line of code at the very end of the wndReportControl_MouseDown event:
On Error Resume Next
MsgBox wndReportControl.Records(hitRow.Index).Item(COLUMN_SUBJECT).Value

Click on a row, and the messagebox gives me an off the wall value for subject.
http://www.mrden.com/Pix/RC1.jpg

Remove the grouping, and then click on a row, and the messagebox gives me the correct value for the subject.

http://www.mrden.com/Pix/RC2.jpg

Any thoughts on this? Am I not using the best way to obtain column values for specific rows? 

I also am not able to get the wndReportControl_ColumnClick event to fire, but I have not put a lot of time into that yet.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Mr.Den Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 26 August 2007 Status: Offline Points: 50	Post Options Post Reply Quote Mr.Den Report Post Thanks(0) Quote Reply Topic: Report Control grouping problem Posted: 15 February 2008 at 2:50pm
	Greetings everyone, I am using the report control from Xtreme SuitePro v11.2.2 (XP SP2, VB6 SP6), and am stumped. What I am trying to do is obtain the column values for a row that the user left clicks on. Unless I am missing something, when I have rows grouped, trying to obtain the column values of a row that a user clicks on brings the wrong values. Using the report sample example that came with the package as a base to work and learn with, I have added the following line of code at the very end of the wndReportControl_MouseDown event: On Error Resume Next MsgBox wndReportControl.Records(hitRow.Index).Item(COLUMN_SUBJECT).Value Click on a row, and the messagebox gives me an off the wall value for subject. http://www.mrden.com/Pix/RC1.jpg Remove the grouping, and then click on a row, and the messagebox gives me the correct value for the subject. http://www.mrden.com/Pix/RC2.jpg Any thoughts on this? Am I not using the best way to obtain column values for specific rows? I also am not able to get the wndReportControl_ColumnClick event to fire, but I have not put a lot of time into that yet.

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 15 February 2008 at 2:58pm
	wndReportControl.Rows(hitRow.Index).Record.Item(COLUMN_SUBJECT).Value column click is for clicking on column headers

Mr.Den Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 26 August 2007 Status: Offline Points: 50	Post Options Post Reply Quote Mr.Den Report Post Thanks(0) Quote Reply Posted: 15 February 2008 at 7:30pm
	That works great Thank you.