How do I suppress a header based on a value in details? 1

[StephHansen]

I need to show one of two headers on the page.

I have a CR that has a grouping by Order ID, and detail rows of Item ID, Item Desc (among others).

The Page Header would be based on the Item ID equaling 745. But there will be multiple Items in that same order and only one of them (if any) will be 745.

I want the page header to read Order_Desc + "Special" if a "special" item is one of the items or just Order Desc if it is not.

I created two page headers and used the suppress option based on the below formula:

StrCmp ({Orders.Materials_T.COMPT_ITEM_ID}, "745&quot=1

for the Page Header that does not have a "special" item

and

StrCmp ({Orders.Materials_T.COMPT_ITEM_ID}, &quot;745&quot<>1

for the one that does have a Special Item in the order.

Unfortunately, it never displays the &quot;Special&quot; Header. Thanks in advance! Stephanie Nicholas
Software Engineer
i-Net Strategy

 

[IdoMillet]

Create a formula {@is_special}:
---------------------------------------------------------
IF {Orders.Materials_T.COMPT_ITEM_ID}= &quot;745&quot; THEN 1 ELSE 0
---------------------------------------------------------

The suppress expressions could then be:
----------------------------------
SUM({@is_special}, {order_id} > 0
----------------------------------

----------------------------------
SUM({@is_special}, {order_id} = 0
----------------------------------

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[StephHansen]

That worked great! Thanks! Stephanie Nicholas
Software Engineer
i-Net Strategy