Suppress based on date only

[griffter]

Hi All

I have a problem whereby I need to display all the packs contained in an order for a site. The order number is unique but contains multiple packs. I am using suppression formulas in the detail section to display as the customr requires below:-

Site Order No Date Raised Packs
Site 01 100010 16/01/2006 abc
def
16/01/2006 ghi
My problem is that as the system allocates the packs to the order number the date raised generated has the potential to be different by seconds or minutes generating a date that is different so the supression does not work, however I only want to display the date once.

I am thinking I need a suppression formula that suppresses only on the date element of the date time being the same, any ideas how I write such a formula?

Thanks in advance for any help.

Di

 

[lbass]

Try a field suppression formula like:

date({table.dateraised}) = date(previous({table.dateraised})) and
{table.orderno} = previous({table.orderno})

-LB

 

[griffter]

Thanks LB for this help. I have tried to use your formula but it is still not quite right. I am losing my first date which I want to retain. I should mention that the data is grouped by the order no.

I have tried using groupnumber>1 with your formula to get around this but it still won't show the first date.

Any more ideas???

 

[griffter]

Hi LB

I think I am trying to crack a nut with a hammer here. I have created a formula field that returns only the date and used that in the report, the client is not interested in the time element. Just need to make the field read, dd,mmm,yy now!!

 

[lbass]

When you enter the conditional field suppression formula, do NOT add a check mark to the suppress box.
What happens is that if the formula doesn't apply, in this case, because there IS no previous, it defaults to the check box status, so if you have it checked, it will suppress. If you don't have it checked, it will not suppress the first record. The conditional formula overrides the checkbox, EXCEPT in conditions where it cannot be applied.

To format your date, right click on it->format field->
date->customize->Datetime tab->Order: Date->Date Tab->Month: Mar->Day:01->year:99.

-LB

 

[griffter]

Many thanks for all your help