Page 2 of 2

Re: Stored Procedure Sending For StiReport

Posted: Thu Feb 15, 2018 5:10 pm
by IskandarAir
Dear stimulsoft team,

We almost succeeded at sending parameters. No errors is being thrown. But no result is being returned from stored procedure. In order to debug, we Run Profiler, to see upcoming sql commands. There, we san that empty params are being sent to sql server. I have attached screenshot. We are doing everything from code purely, nothing depends on from designer file (in terms of data source). HERE is our code.


Code: Select all


                var dataSource = (StiSqlSource)report.DataSources[0];


                // Set new query
                dataSource.SqlCommand = "sp_TL_Rep_PayPeriod";// query;
                dataSource.Type = StiSqlSourceType.StoredProcedure;
                var rParams = new StiDataParametersCollection();

                var pFromDate = new StiDataParameter("@pFromDate", (int)SqlDbType.DateTime, 0);
                pFromDate.ParameterValue = parameters.Date.ToSqlValue();
                rParams.Add(pFromDate);
                var pToDate = new StiDataParameter("@pToDate", (int)SqlDbType.DateTime, 0);
                pToDate.ParameterValue = parameters.Date.ToSqlValue();
                rParams.Add(pToDate);
                var pFromGroup = new StiDataParameter("@pFromGroup", (int)SqlDbType.NVarChar,10);
                pFromGroup.ParameterValue = parameters.EmployeeGroupFrom;
                rParams.Add(pFromGroup);
                var pToGroup = new StiDataParameter("@pToGroup", (int)SqlDbType.NVarChar, 10);
                pToGroup.ParameterValue = parameters.EmployeeGroupTo;
                rParams.Add(pToGroup);
                var pFromAgree = new StiDataParameter("@pFromAgree", (int)SqlDbType.NVarChar,8);
                pFromAgree.ParameterValue = parameters.AgreeFrom;
                rParams.Add(pFromAgree);
                var pToAgree = new StiDataParameter("@pToAgree", (int)SqlDbType.NVarChar, 8);
                pToAgree.ParameterValue = parameters.AgreeTo;
                rParams.Add(pToAgree);
                var inOrder = new StiDataParameter("@inOrder", (int)SqlDbType.NVarChar, 200);
                inOrder.ParameterValue = parameters.InOrder;
                rParams.Add(inOrder);
                var pBreakOrder = new StiDataParameter("@BreakOrder", (int)SqlDbType.SmallInt, 0);
                pBreakOrder.ParameterValue = (parameters.PageBreak == 2).ToSqlValue();
                rParams.Add(pBreakOrder);
                var pGetDataFrom = new StiDataParameter("@pGetDataFrom", (int)SqlDbType.SmallInt, 0);
                pGetDataFrom.ParameterValue = parameters.GetDataFrom;
                rParams.Add(pGetDataFrom);
                var pPeriodType = new StiDataParameter("@pPeriodType", (int)SqlDbType.SmallInt, 0);
                pPeriodType.ParameterValue = parameters.PeriodType;
                rParams.Add(pPeriodType);
                var pActive = new StiDataParameter("@pActive", (int)SqlDbType.SmallInt, 0);
                pActive.ParameterValue = parameters.Active.ToSqlValue();
                rParams.Add(pActive);
                var pxByParm = new StiDataParameter("@xByParm", (int)SqlDbType.VarChar, 3);
                pxByParm.ParameterValue = parameters.ByParam;
                rParams.Add(pxByParm);
                var pxEmpDepList = new StiDataParameter("@xEmpDepList", (int)SqlDbType.VarChar, 50);
                pxEmpDepList.ParameterValue = parameters.EmployeeDepartmentList;
                rParams.Add(pxEmpDepList);
                var pinSelect = new StiDataParameter("@inSelect", (int)SqlDbType.VarChar, -1);
                pinSelect.ParameterValue = "";
                rParams.Add(pinSelect);
                dataSource.UpdateParameters();
                dataSource.Parameters = rParams;
... [Later some we build\compile it]


Can you please clarify what error is occuring here and what can be done about it?


Regards,
Iskandar

Re: Stored Procedure Sending For StiReport

Posted: Sun Feb 18, 2018 8:42 pm
by Alex K.
Hello,

We couldn't reproduce this issue on our samples.
We need a sample project to reproduce the issue.

Thank you.