http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 05 Jun 2026 04:53:40 +0000 Wed, 29 Apr 2009 13:42:06 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=14160 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=14160&PID=48476&title=grouped-records#48476 Author: Algae
Subject: 14160
Posted: 29 April 2009 at 1:42pm

Ok.. I'll simplify my question:

Is there a method to get the grouped rows (or records) under a group row? The group row being the one with the +/- box. ]]> Wed, 29 Apr 2009 13:42:06 +0000 http://forum.codejock.com/forum_posts.asp?TID=14160&PID=48476&title=grouped-records#48476 http://forum.codejock.com/forum_posts.asp?TID=14160&PID=48413&title=grouped-records#48413 Author: Algae
Subject: 14160
Posted: 27 April 2009 at 4:32pm

Does anyone know of a good method to create a combined record based on grouped columns?

For instance, records (rows) are grouped on column 1 and 2:

Col 1
______
         | Col 2
         |______


         Col 1 | Col 2 | Col 3 | Col 4
         -------------------------------
Row 1|   A    |   B    |    C   |   D
--------------------------------------
Row 2|   A    |   B    |    E    |   F


a) I want to create a new record when any Rows are grouped.
Example when: (Row 1, Col 1) == (Row 2, Col 1) && (Row 1, Col 2) == (Row 2, Col 2).
My method of finding the first grouped row is pretty convoluted where I have to test all the columns against the ordered column list and so on. Making a new record based on the found row is a simple process of copying the found row record to a new record.

The result should be: New Record (A, B, C, D)

b) Now I want to append whatever doesn't match from Record 2 to this new record!

The result should be New Record (A, B, C, D, E, F)

It seems like it should be simple, but I've really ended up with quite a mess trying to get the collection of rows under the same "grouped by" column(s). Is there an easy method to grab all the rows under a Grouping? Digging through the code I've found the CXTPReportColumnOrder which gives me the ordered column list, but nothing to indicate which rows or records are indeed Grouped.

Thanks in advance for any tips on how to accomplish this.


]]> Mon, 27 Apr 2009 16:32:48 +0000 http://forum.codejock.com/forum_posts.asp?TID=14160&PID=48413&title=grouped-records#48413