compare current record with next record

Curtis2009

Hi all, im running a report where i need to compare one field of the current record with the same field in the next record.

The data is like this:

rec 1 type A
rec 2 type A
rec 3 Type B

When the type changes to B i need to show subtotals section in the report, and after that reset them. Any help will be aprecciated. :-k

Savatage

Sounds like this is more of a Grouping question then comparing

Curtis2009

Thanks for the reply. Yes i could solve my problem with grouping, but i need to reset the subtotals and have no idea how to do that :-k .

sunnyk

See Total fields property of Dataitems.

vijay_g

hi,
Here you have to set key with grouping field and then total field write in total field property of same dataitem this will automatically set and reset the value of total field.

in case of multiple grouping you have to use TOTALCAUSEDBY function on trigger.

Vijay Gupta