Is there a way to know a value from the NEXT record? 2

[mpdinosaur]

When a group footer is being printed, is ther a way to "know" a value in the next record that's going to print?

I need to increment a value and conditionally turn off a group header based on a value in the next record.

Using CR 8.5 and MS-SQL.

Thanks in advance.



MikeTheDinosaur

 

[vidru]

[tt]Next({Table.Field})
[/tt]
That'll give you the value of {Table.Field} for the next row in the data set.

-dave

 

[synapsevampire]

Yep, use the NEXT function:

If next({table.field}) = "Some data" then
"It's Some data"
else
"Not Some Data"

To suppress a section based on this, right click the section and select format section->X 2 next to Suppress

Place something like:

next({table.field}) = "Some data"

-k