http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 18 Apr 2026 20:32:21 +0000 Mon, 07 Dec 2009 19:19:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=15797 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=15797&PID=55452&title=group-by-columns-where-column-has-content-only#55452 Author: docontrol
Subject: 15797
Posted: 07 December 2009 at 7:19pm

I planned to use group by for columns to create subgroups based on a document numbering system. This was working fine with a first level grouping approach, but now that I have added subgroups on multiple levels (up to 9 levels),

I can't get it to hide groups for records that have no content in the column to group by. On the attached image I have three hidden columns. The first represents the first digit of the document number (Chapter 1 - General), the second represents the second digit of the document number (e.g. Section 1.1 - Definitions), the third columns represents the third digit (Section 1.1.1) etc.

The idea is that Subgroups can be defined for some document numbers but not all. The blank group above 1.1.0 Introduction should go away and 1.1.0 be placed directly beneath "Section 1.1 - Definitions". In other words 1.1.0 should only be grouped by first and second level groups and not levels 3 to 9. The problem becomes very obvious when added all 9 levels (hidden group columns) but my example on has 3 levels defined.



The behaviour is exactly the same in the Toolkit Pro Report Sample when grouping by From and then CC (which is blank for all records).



It might be that there is a working solution at the moment but in that case is there a workaround?]]> Mon, 07 Dec 2009 19:19:49 +0000 http://forum.codejock.com/forum_posts.asp?TID=15797&PID=55452&title=group-by-columns-where-column-has-content-only#55452