Hi folks.. I'm an classic ASP dinosaur trying to get started with ASP.net and the following problem has me stumped.

I've got a very basic crystal report bound to an s_proc that takes 5 parameters.. I keep getting "input string was not in correct format" when I try to pass the parametervalues to the report document.

Thanks in advance!!!


Dim oRpt As New ReportDocument
Dim conn As New SqlClient.SqlConnection

oRpt.Load("c:\dev\dotnet\" & aReport)

Dim param_values as New ParameterValues

Dim param_prot as New ParameterDiscreteValue
Dim param_rpn as New ParameterDiscreteValue
Dim param_cra as New ParameterDiscreteValue
Dim param_startdate as New ParameterDiscreteValue
Dim param_enddate as New ParameterDiscreteValue
Dim param_option as New ParameterDiscreteValue


param_prot.value = fldparam3.text
param_rpn.value = fldparam2.text
param_cra.value = fldparam4.text
param_startdate.value = fldparam5.text
param_enddate.value = fldparam6.text
param_option.value = Int32.Parse(fldparam1.text)


param_values.Add(param_option)
param_values.Add(param_rpn)
param_values.Add(param_prot)
param_values.Add(param_cra)
param_values.Add(param_startdate)
param_values.Add(param_enddate)

oRpt.DataDefinition.ParameterFields("@Option").ApplyCurrentValues(param_values)
oRpt.DataDefinition.ParameterFields("@RPN").ApplyCurrentValues(param_values)
oRpt.DataDefinition.ParameterFields("@ProtNo").ApplyCurrentValues(param_values)
oRpt.DataDefinition.ParameterFields("@CRA").ApplyCurrentValues(param_values)
oRpt.DataDefinition.ParameterFields("@StartDate").ApplyCurrentValues(param_values)
oRpt.DataDefinition.ParameterFields("@EndDate").ApplyCurrentValues(param_values)


it dies on
oRpt.DataDefinition.ParameterFields("@Option").ApplyCurrentValues(param_values)

when I'm trying to pass my first parameter.. @Option is defined in my sproc as an int.



output from the dot.net debugger is as follows


Input string was not in a correct format.
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: System.FormatException: Input string was not in a correct format.

Source Error:


Line 50:
Line 51: 'param_values.Add(param_discrete)
Line 52: oRpt.DataDefinition.ParameterFields("@Option").ApplyCurrentValues(param_values)
Line 53: oRpt.DataDefinition.ParameterFields("@RPN").ApplyCurrentValues(param_values)
Line 54: oRpt.DataDefinition.ParameterFields("@ProtNo").ApplyCurrentValues(param_values)


Source File: c:\dev\dotnet\report.aspx Line: 52

Stack Trace:


[FormatException: Input string was not in a correct format.]
System.Number.ParseDecimal(String s, NumberStyles style, NumberFormatInfo info) +0
System.Decimal.Parse(String s, NumberStyles style, IFormatProvider provider) +30
System.Convert.ToDecimal(String value, IFormatProvider provider) +63
System.String.System.IConvertible.ToDecimal(IFormatProvider provider) +11
System.Convert.ToDecimal(Object value) +43
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.b(Object t, _* u) +885
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.AddCurrentValue(Object value) +209
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.ApplyCurrentValues(ParameterValues currentValue) +489
ASP.report_aspx.getReport(String aReport) in c:\dev\dotnet\report.aspx:52
ASP.report_aspx.SubmitBtn_Click(Object Sender, EventArgs E) in c:\dev\dotnet\report.aspx:106
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573