Report Field Concatenation

Didn't seem to have any luck with the standard field concatenation techniques sometimes used for a datafield.

For example:

1. "=GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_length + GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_width + GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_depth"

2. = (GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_length==System.DBNull.Value?"":(GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_length + "").ToString().Trim()) + " " + (GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_width==System.DBNull.Value?"":(GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_width + "").ToString().Trim())  + " " + (GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_depth==System.DBNull.Value?"":(GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_depth + "").ToString().Trim())

Now I'm trying to use the scripting environment with the following example for Active Reports v3:

 

public void ActiveReport_DataInitialize()

 

{

 

//add concatenated Stone Orchard plot dimension fields

 

rpt.Fields.Add("mydimensionfields");

 

}

 

public bool ActiveReport_FetchData(bool eof)

 

{

 

   string str1 = ((DataDynamics.ActiveReports.DataSources.XMLDataSource)rpt).Field("GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_length",false).ToString();

 

   string str2 = ((DataDynamics.ActiveReports.DataSources.XMLDataSource)rpt).Field("GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_width",false).ToString();

 

   string str3 = ((DataDynamics.ActiveReports.DataSources.XMLDataSource)rpt).Field("GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_depth",false).ToString();

 

   

 

   rpt.Fields["mydimensionfields"].Value = str1 + str2 + str3;

 

    

 

  return eof;          

 

 }

 

Unfortunately, the script does not work.......something to do with "Cannot convert type"

Does anyone have a clue as to why this won't work?

Walter