Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed Nov 25, 2015 2:19 pm**

hello guys, im trying to put in one text box, which will sum up the qsdok.mnozstvi for substring(qsdok.pracoviste)1,2 lower than 3 (i have pracoviste 1, 2 and 3)
(without substring the pracoviste is like M1, M2, M3)
but i still get error in my code..

{SumIf(qsdok.MNOZSTVI, substring(qsdok.pracoviste)1,2 < 3}

What is right interpretation of my condition?

Or the other solution could be, if I can somehow make one of the group headers with data condition substring(qsdok.pracoviste)1,2 < 3

Posted: **Thu Nov 26, 2015 7:21 am**

Hello,

Please try to use the following expression:

Code: Select all

{SumIf(qsdok.MNOZSTVI, int.Parse(Substring(qsdok.pracoviste,1,2)) < 3)}

Thank you.

Posted: **Thu Nov 26, 2015 10:17 am**

Thank you so much, this is it!

Posted: **Thu Nov 26, 2015 10:50 am**

Hello,

We are always glad to help you!

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Help with condition in Report summary totals

Help with condition in Report summary totals

Re: Help with condition in Report summary totals

Re: Help with condition in Report summary totals

Re: Help with condition in Report summary totals