Am doing grouping  in my report...i want to print one specific record  from group in the group footer based on some condition ...how to do this?

 

 

Ex:

     group_name   col1   col2   col3

         abc              4       6       8

         abc              4       7       3

         abc              4       0       3

here the col2 having the 7 as hieghest number that i want to prin in group footer...

 

 

        

Try this:

 

1.  Sort on column 2 inside your group.

 

2.  Put a suppression formual on the details section where the rest of your data displays.  It will look something like this:

 

NextIsNull({table.group_name}) or {table.group_name} <> next({table.group_name})

 

This will keep the last record in the group from showing up in the details so that you can put it in the group footer.

 

-Dell