Please Help to write Formula

[happyIndian100]

Hi All,

i have a crystal report out put like this:

Code Total Rcvd Total Outstanding
-----------------------------------------
ADD 100 10
ADC 50 5
ADC_CD 12 10
ADC_AB 100 15
CSF 30 5


Now the requirement is to sum all the codes which start with "ADC"
The output should be like the following:

Code Total Rcvd Total Outstanding
-----------------------------------------
ADD 100 10
ADC 162 30
CSF 30 5

Please help me to write the Formula to acheive this.

Thank you in advance

 

[dgillz]

Right click on total received, select insert summary, and group by code. Do the same for Total Outstanding. Hide the details section and place the code field in the group footer.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[kutoose]

Hi HappyIndian100

Are the values displayed in the detail section ? In that case you can create formula and use that formula as a group.

The formula will be something like this

If {Table.field}[1 to 3] = "ADC" then "ADC"
else
{Table.field}

Now you can suppress the detail section and create a summary field for Total Rcvd and Total Outstanding

kutoose@yahoo.com