Ignoring first record in summary 1

[AyJayEL]

I have a report based on an oracle database. It has 3 groups. Group 1 Name. Group 2 Type. Group 3 Base. I am adding up time in the details. I have to suppress duplicate records using field = previous(field) in the section details and also in the summary fields on the data. My problem is that the summary is ignoring the data in the first record. (if I use next instead of previous it ignores the last record). I'm using Crystal 8.

Learn something new every day *:->*
AyJayEl

 

[AyJayEL]

I should have said running total rather than summary I think. I've just come back to Crystal after a two and a half year break and I think my brain's dead!

Learn something new every day *:->*
AyJayEl

 

[Madawc]

Do a running-total count, starting fresh for each group. For the first record in a group, add without looking at 'previous'.

This would work in 8.5, should be OK for you.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[AyJayEL]

Madawc

Thank you for your reply. I am doing fresh running-total for each group. I don't know what you mean by 'add without looking at previous' I'm afraid.

I'm probably being thick.

Learn something new every day *:->*
AyJayEl

 

[lbass]

What do you mean by ignore? If the first record is disappearing, in the section expert, uncheck "suppress" and leave the conditional formula in the x+2 formula area.

Or have you built the condition into the running total evaluation section? If so, change the evaluation section to something like:

onfirstrecord or
//to pick up the first record
{table.groupfield} <> previous({table.groupfield}) or
//to pick up only the first record in each group
{table.field} <> previous({table.field})
//to pick up only the first of repeating records

I think you should provide some sample data.

-LB

 

[AyJayEL]

Thank you lbass. That worked! Have a star.

Learn something new every day *:->*
AyJayEl