Creating reports and dashboards | Stimulsoft community forum

Posted: **Tue Feb 15, 2011 11:35 am**

Hi!

How should these functions be used...

For example, I have a table (lets say MachineStatus), in MachineStatus i have two columns (LogDt = Logdate (1 every minute), Status ("1" if up running)).

So now I would like to print in a report how many Minutes in a day the machine has been up running
(I know there is 1440 minuts per day so it would be simpel as Count(Status = 1)/60 + ":" + Count(Status = 1)%60)...

But I cant get the Count function to work, how shuold I implement this

And the Min/Max function I cant get to function as I expect them (the column holding the status varible is a charchar, so do I need to tryPrase it like {Max(TryParseDouble(A7A3_Drift.Status))})...???

Best Regards

Edmund

Posted: **Wed Feb 16, 2011 6:28 am**

Any working example?

Posted: **Wed Feb 16, 2011 9:34 am**

Hello,

We need some additional time to check the issue.

Thank you.

Posted: **Fri Feb 18, 2011 12:37 am**

Any luck? :dreamer:

Posted: **Mon Feb 28, 2011 6:56 am**

Hi guys!

Have you had any time to check on my problem?

Any new build/realse scheduled?

Regards Edmund

Posted: **Wed Mar 02, 2011 2:16 am**

Hello,

We have added a new conditional functions like CountIf, SumIf, AvgIf. Now you can use the following expression, for example:

Code: Select all

{(int)(CountIf(MachineStatus.Status = 1)/60) + ":" +  CountIf(MachineStatus.Status = 1)%60}

Another examples:

Code: Select all

{CountIf(DataBand1, DataSource1.Field == true)}
{SumIf(DataBand1, DataSource1.FieldForSum, DataSource1.FieldForCheck == 1)}

The patch will be available in the prerelease build from 1-Mar-2011.

Thank you.

Posted: **Wed Mar 02, 2011 3:11 am**

Thanks Ivan!

I´ll be looking foward to this...

Regards

Edmund

Posted: **Wed Mar 02, 2011 7:51 am**

Hello,

Let us know if you have additional questions.

Thank you.

Posted: **Wed Mar 16, 2011 1:08 pm**

Have the function been added?

I´ve downloaded the prerelease from yesterday (2011.03.15) but I can´t see them in the function list or get it to work...

Regards Edmund

Posted: **Thu Mar 17, 2011 2:06 am**

Hello, Edmund

The specified functions should work in the latest prerelease build. At this moment did not added a list of functions in the expressions editor, we will add it in the next prerelease build.

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Internal Functions (Count, Min, Max...)

Internal Functions (Count, Min, Max...)

Internal Functions (Count, Min, Max...)

Internal Functions (Count, Min, Max...)

Internal Functions (Count, Min, Max...)

Internal Functions (Count, Min, Max...)

Internal Functions (Count, Min, Max...)

Internal Functions (Count, Min, Max...)

Internal Functions (Count, Min, Max...)

Internal Functions (Count, Min, Max...)

Internal Functions (Count, Min, Max...)