Note that there are some explanatory texts on larger screens.

plurals
  1. POSuppress line object in details section based on conditions
    primarykey
    data
    text
    <p>I'm using Crystal Report 2008. I've a report result which is included more then 1 page and 1 group. Sample result as below:</p> <p><p>Page 1: <br>&lt;&lt; Group Header >> # Item No. Price <br>&lt;&lt; Group Header >> <strong><em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__</strong> <br>&lt;&lt; Details a >> 1 ItemA001 $1,000 <br>&lt;&lt; Details a >> 2 ItemA002 $1,000 <br>&lt;&lt; Details a >> 3 ItemA003 $2,000 <br>&lt;&lt; Group Footer >> <strong><em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>_</strong> <br>&lt;&lt; Group Footer >> Total: $4,000</p> <p><p>Page 2: <br>&lt;&lt; Group Header >> # Item No. Price <br>&lt;&lt; Group Header >> <strong><em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__</strong> <br>&lt;&lt; Details a >> 1 ItemB001 $2,000 <br>&lt;&lt; Details a >> 2 ItemB002 $1,500 <br>&lt;&lt; Details a >> 3 ItemB003 $2,000 <br>&lt;&lt; Group Footer >> <strong><em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__</strong> <br>&lt;&lt; Group Footer >> Total: $5,500</p> <p><p>Now I want to insert a line between every row as below: <br>(As I know user can't set conditions for line object to suppress, so I add the line in details b) <p>Page 1: <br>&lt;&lt; Group Header >> # Item No. a Price <br>&lt;&lt; Group Header >> <strong><em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__</strong> <br>&lt;&lt; Details a >> 1 ItemA001 $1,000 <br>&lt;&lt; Details b >> ----------------- <br>&lt;&lt; Details a >> 2 ItemA002 $1,000 <br>&lt;&lt; Details b >> ----------------- <br>&lt;&lt; Details a >> 3 ItemA003 $2,000 <br>&lt;&lt; Details b >> <strong>----------------- How to suppress?</strong> <br>&lt;&lt; Group Footer >> <strong><em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__</strong> <br>&lt;&lt; Group Footer >> Total: $4,000</p> <p><p>Page 2: <br>&lt;&lt; Group Header >> # Item No. Price <br>&lt;&lt; Group Header >> <strong><em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__</strong> <br>&lt;&lt; Details a >> 1 ItemA001 $1,000 <br>&lt;&lt; Details b >> ----------------- <br>&lt;&lt; Details a >> 2 ItemA002 $1,000 <br>&lt;&lt; Details b >> ----------------- <br>&lt;&lt; Details a >> 3 ItemA003 $2,000 <br>&lt;&lt; Details b >><strong>----------------- How to suppress?</strong> <br>&lt;&lt; Group Footer >> <strong><em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__<em>_</em>__</strong> <br>&lt;&lt; Group Footer >> Total: $5,500</p> <p>I've tried suppress if "RecordNumber >= Count({ItemNo.})" but RecordNumber didn't reset for second page so all details b will be suppress in page 2. <br>How can I set conditions to suppress details b for last record in each group?</p>
    singulars
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload