Creating reports and dashboards | Stimulsoft community forum

Hi
I have been going crazy with this problem since the past 2 days well its like when i run the project in debug mode the report loads and everything works great but as soon as i publish my project on my local IIS the report starts giving this error

error CS2001: Source file 'C:\windows\TEMP\loamdxkp.0.cs' could not be founderror CS2008: No inputs specified

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.Exception: error CS2001: Source file 'C:\windows\TEMP\loamdxkp.0.cs' could not be founderror CS2008: No inputs specified

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:


[Exception: error CS2001: Source file 'C:\windows\TEMP\loamdxkp.0.cs' could not be founderror CS2008: No inputs specified]
Stimulsoft.Report.StiReport.Compile(String path, Stream stream, StiOutputType outputType, Boolean autoCreate, Object standaloneReportType) +1993
Stimulsoft.Report.StiReport.Compile() +21
Stimulsoft.Report.Engine.StiReportV2Builder.RenderSingleReport(StiReport masterReport, StiRenderState renderState) +847
Stimulsoft.Report.StiReport.RenderReport(StiRenderState renderState) +1588
Stimulsoft.Report.StiReport.Render(StiRenderState renderState, StiGuiMode guiMode) +952
Stimulsoft.Report.StiReport.Render(Boolean showProgress) +53
Stimulsoft.Report.Web.StiWebViewer.RenderReport(StiReport report) +120
Stimulsoft.Report.Web.StiWebViewer.ProcessReport() +1250
Stimulsoft.Report.Web.StiWebViewer.set_Report(StiReport value) +3190
Printing.Page_Load(Object sender, EventArgs e) +1039
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

it seems it is looking for some weird file i dont get it :-S i have tried just about everything i can but still no use :-S

here is the code

Dim _requestNum As String = Request.Params("RN")
Dim _consultationTransHdrID As String = Request.Params("CID")
Dim _mrn As String = Request.Params("MRN")
Dim _customFormID As String = Request.Params("CFID")
Dim _transHdrID As String = Request.Params("TID")
Dim _lang As String = Request.Params("LANG")

Dim Rep As StiReport = StiWebReport1.GetReport()

Rep.Load(Root + "UCAF.mrt")
Rep.Compile()
Rep.CompiledReport.DataSources("sp_CustomForms_UCAF").Parameters("@RequestNum").ParameterValue = Int32.Parse(_requestNum)
Rep.CompiledReport.DataSources("sp_CustomForms_UCAF").Parameters("@ConsultationTransHdrID").ParameterValue = Int32.Parse(_consultationTransHdrID)
Rep.CompiledReport.DataSources("sp_CustomForms_UCAF").Parameters("@MRN").ParameterValue = Int32.Parse(_mrn)
Rep.CompiledReport.DataSources("sp_CustomForms_UCAF").Parameters("@CustomFormID").ParameterValue = Int32.Parse(_customFormID)
Rep.CompiledReport.DataSources("sp_CustomForms_UCAF").Parameters("@TransHdrID").ParameterValue = Int32.Parse(_transHdrID)
Rep.CompiledReport.DataSources("sp_CustomForms_UCAF").Parameters("@Lang").ParameterValue = Int32.Parse(_lang)
Rep.Render()

Me.StiWebViewer1.Report = Rep

PLEASE HELP ASAP !
And my IIS version is 7.5 something

Hello.

If a medium trust environment is set on your server then the compilation is forbidden.
You should set the Calculation Mode of the report to Interpretation and set next option: Thank you.

Cant find the calculation mode option where can it be found ??

Thanks Alot u guys just moved a huge bolder off my shoulders well we might be buying Stimulsoft reports ultimate soon

Hello.

shakeeb ahmed wrote:Cant find the calculation mode option where can it be found ??

It could be found in the Designer. It's a property of the report. Maybe you should switch to the Professional mode of the property grid. Thank you.

Done that And Thanks to you guys the report is working and i moved on to make other reports work and 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

Hello.

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

Thank you.