Skip to Content
0
Jan 26, 2023 at 10:16 PM

Crystal Report show value in Group footer

42 Views

Hi there,

i have the following problem:

Example of my detail section (which is grouped by item number). The item is stored in different units and units contain different Batch numbers. Goal is to see the smallest /oldest Batch# and the correct unit to it.

Unit: Batch#

1000004840 2022256

1000004837 2022257

1000004837 2022180

1000004839 2022203

1000004839 2022256

_______________________

The smallest batch# here is 20222180 (i pulled the smallest value in the group section). But how am I able to get the correct unit to the smallest batch# - which should be 1000004837.

If I just put the field on the group footer it doesnt show the right unit (of course) but I am lost on how to set this up.

Any Ideas ?

Thank you

Jacqueline