String parsing error in Crystal Report

[NinaL]

Hi ,

We have recently installed a custom web application with some crystal reports that was developed for another site of our company. When we run some of the reports here, we get an error that does not occur at the other site. It looks like a string parsing function is not working properly. Does anyone have a general clue what could be going on:

-----------------
Environment info:
SQLServer 2000
Windows Server 2000

------------------------------------------------------------
Error info:

Error in File c:\inetpub\wwwroot\xxxx\reports\PipelineDocuments.rpt: Error in formula <Hyperlink Text>. '{?ParamH} + Replace (Left(CStr({rptNotApprovedParalyzedCanceled.ID}), InStr(CStr({rptNotApprovedParalyzedCanceled.ID}), ",") - 1), ".", "")' String length is less than 0 or not an integer.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecisions.CrystalReports.Engine.FormulaException: Error in File c:\inetpub\wwwroot\xxxx\reports\PipelineDocuments.rpt: Error in formula <Hyperlink Text>. '{?ParamH} + Replace (Left(CStr({rptNotApprovedParalyzedCanceled.ID}), InStr(CStr({rptNotApprovedParalyzedCanceled.ID}), ",") - 1), ".", "")' String length is less than 0 or not an integer.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[FormulaException: Error in File c:\inetpub\wwwroot\xxxx\reports\PipelineDocuments.rpt:
Error in formula <Hyperlink Text>.
'{?ParamH} + Replace (Left(CStr({rptNotApprovedParalyzedCanceled.ID}), InStr(CStr({rptNotApprovedParalyzedCanceled.ID}), ",") - 1), ".", "")'
String length is less than 0 or not an integer.]
.I(String , EngineExceptionErrorID ) +676
.D(Int16 , Int32 ) +537
CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext) +539
CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext) +189
CrystalDecisions.Web.ReportAgent.u(Boolean n) +164
CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e) +108
System.Web.UI.Control.PreRenderRecursiveInternal() +62
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Page.ProcessRequestMain() +1489