AnsweredAssumed Answered

How to draw a line after multiple field control breaks

Question asked by RonaldLow on Mar 10, 2013
Latest reply on Mar 11, 2013 by RonaldLow

Title

How to draw a line after multiple field control breaks

Post

      

     I have frequently made long list type reports easier to read by drawing a line when a particular field changes.  Say you have a  a list of transactions sorted by date.  You add a subsummary containing only a horizontal line that triggers on a change in date.  When the report is run, the transactions are visually grouped by date:
      
     3/09/2013  xxxxxxx
     3/09/2013  xxxxxxx
     ---------------------------------
     3/11/2013  xxxxxxx
     3/11/2013  xxxxxxx
     ---------------------------------
      
     Now I would like to do something more complex:  I would like to draw two different lengths of line, each line breaking on a different field.  The major break is on date, with a minor break on product ID.  The report would look like this:
      
     3/09/2013  123  xxxxxxx
     3/09/2013  123  xxxxxxx
                          -----------------
     3/09/2013  130  xxxxxxx
     3/09/2013  130  xxxxxxx
     ---------------------------------
     3/11/2013  123  xxxxxxx
     3/11/2013  123  xxxxxxx
                          -----------------
     3/11/2013  127  xxxxxxx
     3/11/2013  127  xxxxxxx
     ---------------------------------
      
     My problem is that when the major field breaks, I also get a break on the minor field, which draws a double line:
      
     3/09/2013  127  xxxxxxx
                          -----------------
     ---------------------------------
     3/11/2013  123  xxxxxxx
      
     I created a stored calculated work field as a proxy for the product ID that changes when there is a change in the product ID, but not if there is also a change in the date. So the change in the minor field is suppressed if there is also a change in the major field.  Unfortunately, this did not work.  A break in the major field implies a break in the minor field, so I still get a double line.
      
     Is there any way around this?

Outcomes