How do I send parameters to Stimulsoft?

Question

    public virtual ActionResult GetReportSnapshot()
    {
       var data = (ComparativeBalanceReportDS) TempData["ComparativeSession"];


        StiReport report = new StiReport();
        report.Load(Server.MapPath("~/Content/StimulReports/SampleReport.mrt"));

        report.Compile();

        report["fromDocumentNumber"] = "1";
        report["toDocumentNumber"] = "85";
        return StiMvcViewer.GetReportSnapshotResult(HttpContext, report);
   }

I have stored procedure and execute in designer but I do not send parameters to it and when run App, I get the following error:

Error:SqlCommand.Prepare method requires all variable length parameters to have an explicitly set non-zero Size.

What do I do?

score 10 · Accepted Answer · edited Dec 29 '13 at 11:30

My problem was solved with the following code :

       public virtual ActionResult GetReportSnapshot()
        {
         var data = (ComparativeBalanceReportDS) TempData["ComparativeSession"];       
          StiReport report = new StiReport();
         report.Dictionary.DataStore.Clear();
         report.Load(Server.MapPath("~/Content/StimulReports/SampleReport.mrt"));
         report["@enterpriseId"] = data.EnterpriseId;
         report["@toDocumentNumber"] = data.NumberFilter.FromDocumentDocumentNumber;
         report["@fromDocumentNumber"] = data.NumberFilter.ToDocumentDocumentNumber;
         report["@fromDate"] = data.DateFilter.FromDocumentDate.Value;
         report["@toDate"] = data.DateFilter.ToDocumentDate.Value;
         return StiMvcViewer.GetReportSnapshotResult(HttpContext, report);

        }

score 4 · Answer 2 · answered Oct 29 '13 at 08:27

You can use the following code before compile report:

report.Dictionary.DataSources["DataSourceName"].Parameters["ParameterName"].Value = ""

Also you can use the additional variables in the parameters expression. In this case you should set the variable's value before render report.

How do I send parameters to Stimulsoft?

2 Answers2