How to suppress all records but the last detail line???

[irenavassilia]

Hi,

I have a detail section which prints many duplicate records.
I have a running total on the detail section to show how many duplicate records are printing.

ie:
linecount#:
1 IC Item Code 00112X25000023
2 IC Item Code 00112X25000023
3 IC Item Code 00112X25000023
4 IC Item Code 00112X25000023
5 IC Item Code 00112X25000023
6 IC Item Code 00112X25000023
7 IC Item Code 00112X25000023
8 IC Item Code 00112X25000023
9 IC Item Code 00112X25000023
10 IC Item Code 00112X25000023

Now i know how to suppress everything BUT the first linecount but what i need to know is how to suppress everything BUT the last linecount.
Is that possible? Seems possible im just iffy if i should even use linecount here....

Thanks alot.

 

[dgillz]

Assuming you are not grouping, format the detail section, and click the suppress checkbox and the button X-2 button to the right of it and enter a formula:

Not OnLastRecord



Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[irenavassilia]

Hi dgillz,

It's suppressing everything in the detail line.
It's an interesting concept though, thanks.

 

[irenavassilia]

I need a Crystal Reports 10 formula on my Detail section suppress similar to this:

(This formula is for ASP.NET)

Formula = ({UXDETAIL.ItemDesc} = PreviousValue({UXDETAIL.ItemDesc}))

I need the same concept just different sytax i guess cause this doesnt work in Crystal Reports 10.

Thanks.

 

[irenavassilia]

Incase anyone wants to know how to suppress duplicated record values in the detail line here is the formula you can put in the Detail Section Expert -> Suppress -> x-2 ->

Formula = ({TABLE.FieldName} = Next({TABLE.FieldName}))

 

[Madawc]

The other method in Crystal is to group, suppress the detail line and show the last detail line in the group footer.

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