title: Can I Move fields in a Crystal Report to another position when run?
body: <p>I am generating an invoice for various clients.  Some clients have a sales allowance.  For those clients I want to display an extra sales allowance unit and total cost column.</p>
  
  <p>If any maximum sales cost total is = 0 I want to move the fields to the left and display the sales allowance on the right side</p>
  
  <p><strong>When the client has sales allowance</strong></p>
  
  <pre><code>------------------Headings extend all the way across the report-----------------------------
  
  Description   Qty    UOW      Client Unit Cost   Client Cost    Sales Unit Cost   Sales Cost
  ============================================================================================
  Something       5   Each                $11.00        $55.00              $5.00       $25.00
  More Stuff      2   Each                $20.00        $40.00              $5.00       $10.00
  ============================================================================================
  Totals                                                $55.00                          $35.00
  </code></pre>
  
  <p><strong>When the client does not have sales allowance</strong></p>
  
  <pre><code>------------------Headings extend all the way across the report-----------------------------
  
  Description                                   Qty    UOW      Client Unit Cost   Client Cost
  ============================================================================================
  Something                                       5   Each                $11.00        $55.00
  More Stuff                                      2   Each                $20.00        $40.00
  ============================================================================================
  Totals                                                                                $95.00
  </code></pre>
  
  <p>The goal is to put this functionality into a single report rather than having to know which report to run for which client if and when they get a sales allowance.</p>
  
  <p>I know we can supress fields and when I tried to incorporate that I got whitespace on either the right of middle depending on where I placed the fields and the result was not acceptable.  Is there a way to move a field to a different LEFT position when conditions are met?  This would be report wide, not evalutated on each detail record.</p>