Hi,
I'm using CR 8.0, database sql server 2000. I'm trying to concatinate all the FromDateSVC of a claim and display it at the group footer (group on ClaimNo).
These are my calculated fields
ResetDate:
whileprintingrecords;
StringVar FromDate := "";
GetDate:
whileprintingrecords;
stringvar FromDate ;
if (FromDate = "") then
FromDate := totext({RV_CLAIM_DETAILS.FROMDATESVC})
else
FromDate := FromDate + '; ' + totext({RV_CLAIM_DETAILS.FROMDATESVC})
DisplayDate:
whileprintingrecords;
stringvar FromDate;
I placed the ResetDate at the group header, the GetDate at the details level and the DisplayDate at the group footer.
My report is running base on a claimNo parameter, which means only one claim number input to run at the time. The DisplayDate field returns dups.
Example: ClaimNo 20041028034 have only 1 FromDateSVC (06/30/2004)
the formula returns 06/30/2004;06/30/2004
Thank you so much for all of your help!
dnamm
I'm using CR 8.0, database sql server 2000. I'm trying to concatinate all the FromDateSVC of a claim and display it at the group footer (group on ClaimNo).
These are my calculated fields
ResetDate:
whileprintingrecords;
StringVar FromDate := "";
GetDate:
whileprintingrecords;
stringvar FromDate ;
if (FromDate = "") then
FromDate := totext({RV_CLAIM_DETAILS.FROMDATESVC})
else
FromDate := FromDate + '; ' + totext({RV_CLAIM_DETAILS.FROMDATESVC})
DisplayDate:
whileprintingrecords;
stringvar FromDate;
I placed the ResetDate at the group header, the GetDate at the details level and the DisplayDate at the group footer.
My report is running base on a claimNo parameter, which means only one claim number input to run at the time. The DisplayDate field returns dups.
Example: ClaimNo 20041028034 have only 1 FromDateSVC (06/30/2004)
the formula returns 06/30/2004;06/30/2004
Thank you so much for all of your help!
dnamm