evaluating next and previous records in group

[Bunting]

Hi

I have a report with a group on 'Customer_ID', each customer can have any number of accounts that sit under their customer_id and will be displayed in the details section.

What I would like to do is create a string that shows the balaance of each account and display this in the group footer.

for example:
Group Header: (Customer_id) = 1
Detail: (account number) = a (balance = £100
(account number) = b (balance = £50
(account number) = c (balance = £80

Group Footer: (@NEW STRING) = "£100,£50,£80"

 

[IanWaterman]

Use a string var to build your grp footer string.

In grpheader place reset for var

@reset
whileprintingrecords;

global stringvar newstring:="";

In Detail

@eval
whileprintingrecords;

global stringvar newstring:=newstring &", "& totext(balance);

In grpFooter

@display

whileprintingrecords;

global stringvar newstring;

Ian