Sum a String or Text to one Row

[idehen]

Hi,

I am using crystal version 10 and have data displaying as:

Plan Name Surname Flex1 Flex2 Flex3
ABC Smith GBP
----------------------------------------------------------
ABC Smith SP
-----------------------------------------------------------
ABC Smith 8567

This is just an example for one person (Smith), i want to be able to show the information inform of a total Group by the Participant Name to look like

Plan Name Surname Flex1 Flex2 Flex3
ABC Smith SP 8567 GBP

If all the Flexi fields were numbers, i'll simply do a sum and show the total at the participant group level. But you can't sum strings and just wondering if anyone has a work around this.

Many thanks

 

[lbass]

If there is only one instance per group for each field Flex1, Flex2, Flex3, you can insert a maximum on each field, and then suppress the detail section. Drag the summaries into the group header.

-LB

 

[idehen]

Ibass, Thanks for your reply.

That's right. There is only one instance per group for each Flex1, Flex2, Flex3.

Just tried what you advised and it works perfect.

Many thanks.

ID