All values not being displayed

[tekniks]

I have the following formula in the sub-report which is linked to the Main Report by Batch_ID:
//@Country_Code_GH -- In Group Header - Suppressed
whileprintingrecords;
stringvar TheCountries:="";

//@Country_Code_DT -- In Detail - Suppressed
whileprintingrecords;
stringVar TheCountries;

If InStr (TheCountries, {CL_REQUEST_ST.COUNTRY_CODE} ) = 0 then
TheCountries := TheCountries + iif(TheCountries <> "", ", ", "") + {CL_REQUEST_ST.COUNTRY_CODE}
else
TheCountries := TheCountries;

//@Country_code_GF -- In Group Footer -- Showing
whileprintingrecords;
stringvar TheCountries;

The Data in the Country_Code for a given Batch_ID is -- AF,CA,MX,US

Instead of displaying all the above values the report is displaying only MX,US.

The code in the @Country_Code_DT is basically written to avoid the repitition of Country Codes while displaying.

Any ideas what's wrong in here...

Will appreciate all help.

Thanks

Teknik

 

[lbass]

Using your formulas, I can't recreate your problem, even with nulls in the accumulating field. Are you sure your data for the particular group contains all four countries? I would take a look at the detail level data to troubleshoot this.

-LB