Reporting tool and data analytics tools for creating reports and dashboards in ASP.NET, ASP.NET MVC, .NET Core, Blazor, Angular, PHP, Python, WPF, JavaScript, and Java applications.
https://forum.stimulsoft.com/
Code: Select all
if (gid != null)
{
var valuesList = string.Join(",", gid);
foreach (var ds in report.Dictionary.DataSources)
{
var sqlSrc = ds as StiSqlSource;
var sql = sqlSrc.SqlCommand;
sqlSrc.SqlCommand = sql.Replace(":varName:", valuesList);
}
}
Problem appears here:WHERE (dc.IdWorkflow=3 OR dc.IdWorkflow=4) AND (dc.Status=1 OR dc.Status=11) AND
doc.IssueDate>=@FromDate AND doc.IssueDate<=@ToDate AND
ptc.IdOrgGroup=@grpID AND doc.IdDocumentKind IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16) AND
COALESCE(dc.Sender,@EmptyStr) LIKE @Sender
ORDER BY doc.IssueDate DESC
',@grpID=1,@FromDate='2009-12-01',@ToDate='2013-12-20',@usrID=1,@Sender='%gj%',@EmptyStr=' '
select @p1
I don't know what is going on here.WHERE (dc.IdWorkflow=3 OR dc.IdWorkflow=4) AND (dc.Status=1 OR dc.Status=11) AND
doc.IssueDate>=@FromDate AND doc.IssueDate<=@ToDate AND
ptc.IdOrgGroup=@grpID AND doc.IdDocumentKind IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16) AND
COALESCE(dc.Sender,@EmptyStr) LIKE @Sender
ORDER BY doc.IssueDate DESC
',@grpID=1,@FromDate='2009-12-01',@ToDate='2013-12-20',@usrID=1,@Sender='%%',@EmptyStr=' '
select @p1