Creating reports and dashboards | Stimulsoft community forum

HI
Well i have encountered an other strange error and as far as i know i am not doing anything wrong well the error is that when i am passing values to a stored procedure its giving the following error "Parser error: The name 'c' does not exist in the current context" i am giving this input to it and also have testing the stored procedure it returns values ie its working but i do not know why i am getting this error when i am passing all the parameters correctly please help asap of my boss will kill me

here is the .net code

Rep.DataSources("DataSource1").Parameters("@FromDate").Value = Date.Parse(_fromDate)
Rep.DataSources("DataSource1").Parameters("@ToDate").Value = Date.Parse(_fromDate)
Rep.DataSources("DataSource1").Parameters("@RespCenterType").Value = _respCenter.ToLowerInvariant
Rep.DataSources("DataSource1").Parameters("@MRN").Value = Int32.Parse(_mrn)
Rep.DataSources("DataSource1").Parameters("@Lang").Value = Int32.Parse(_lang)

Rep.Compile()

Me.StiWebViewer1.Report = Rep

and here is the Sp declaration in the report

execute "sp_CustomForms_DoctorDesktop" @FromDate,@ToDate,@RespCenterType,@MRN,@Lang
@FromDate as Small date time
@ToDate as Small date time
@RespCenterType VarChar(1)
@MRN Int
@Lang int

and the vars in the stored procedure are
@FromDate smalldatetime ,
@ToDate smalldatetime ,
@RespCenterType varchar(1),
@MRN int,
@Lang int

and here is the stack state of the error

Stack Trace:


[Exception: Parser error: The name 'c' does not exist in the current context]
Stimulsoft.Report.Engine.StiParser.ParseTextValue(String inputExpression, StiComponent component, Boolean& storeToPrint, Boolean executeIfStoreToPrint, Boolean returnAsmList) +1798
Stimulsoft.Report.Engine.StiParser.ParseTextValue(String inputExpression, StiComponent component, Boolean& storeToPrint, Boolean executeIfStoreToPrint) +47
Stimulsoft.Report.Engine.StiParser.ParseTextValue(String inputExpression, StiComponent component) +53
Stimulsoft.Report.Dictionary.StiDataSource.InvokeConnecting() +819
Stimulsoft.Report.Dictionary.StiDataSource.Connect(StiDataCollection datas, Boolean loadData) +184
Stimulsoft.Report.Dictionary.StiDataSourcesCollection.Connect(StiDataCollection datas, Boolean loadData) +257
Stimulsoft.Report.Dictionary.StiDataSourcesCollection.Connect(Boolean loadData) +41
Stimulsoft.Report.Dictionary.StiDictionary.Connect(Boolean loadData) +207
Stimulsoft.Report.Dictionary.StiDictionary.Connect() +34
Stimulsoft.Report.Engine.StiRenderProviderV2.ConnectToData(StiReport report) +179
Stimulsoft.Report.Engine.StiRenderProviderV2.Render(StiReport report, StiRenderState state) +6309
Stimulsoft.Report.Engine.StiReportV2Builder.RenderSingleReport(StiReport masterReport, StiRenderState renderState) +1206
Stimulsoft.Report.StiReport.RenderReport(StiRenderState renderState) +2738
Stimulsoft.Report.StiReport.Render(StiRenderState renderState, StiGuiMode guiMode) +1260
Stimulsoft.Report.StiReport.Render(StiRenderState renderState) +38
Stimulsoft.Report.StiReport.Render(Boolean showProgress, Int32 fromPage, Int32 toPage) +69
Stimulsoft.Report.StiReport.Render(Boolean showProgress) +41
Stimulsoft.Report.Web.StiWebViewer.RenderReport(StiReport report) +201
Stimulsoft.Report.Web.StiWebViewer.ProcessReport() +2170
Stimulsoft.Report.Web.StiWebViewer.set_Report(StiReport value) +4025
Printing2.Page_Load(Object sender, EventArgs e) +1770
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

Please Help Asap
shakeeb ahmed

Posts: 5
Joined: Tue Aug 28, 2012 4:28 pm

Hello.

Please, specify what value of the Calculation Mode of your report is set?

Thank you.

it is Interpretation

Hello.

Please, send us a report template with data or a working project which reproduces the issue.

Thank you.