Creating reports and dashboards | Stimulsoft community forum

Posted: **Tue Nov 14, 2006 10:41 pm**

Hi Savin,

We are using StimulReport.
Now , we are developing one report with conditions based total.

Short Term=if( Age>=12)
e.Value=" "+(dtReport2.PLOT_UNITS * (dtReport2.DET_TRADES_PURCH_REDEEM_PRICE -decimal.Parse(dtReport2.cindexed_cost)));
else
e.Value="0";

Long Term=if( Age>=12)
e.Value="0";
else
e.Value=" "+(dtReport2.PLOT_UNITS * (dtReport2.DET_TRADES_PURCH_REDEEM_PRICE -decimal.Parse(dtReport2.cindexed_cost)));

Page 1

Short Term Long Term

Databand1

1234
221
12
-----------
Footer 14 6 7

Page 2

Short Term Long Term

Databand1
1234
221
12
-----------
Footer 14 6 7

Page 3

Short Term Long Term

Databand1
1234 9
221 11
12
----------- -------------
Footer 14 6 7 20

How to do? How is solve this Problem?

I am try colSum() also.

Please Provide quick solution or use other way.

Thanks of Advance.

Regards,
KMarimuthu.
Acsys.

Posted: **Wed Nov 15, 2006 2:48 am**

Please declare string variable VariableTotals and add to it values in BeforePrint Event of the StiText Component

Code: Select all

VariableTotals = VariableTotals + ToString((dtReport2.PLOT_UNITS * (dtReport2.DET_TRADES_PURCH_REDEEM_PRICE -decimal.Parse(dtReport2.cindexed_cost))));

In the Footer Band of the Report you should place StiText with the following expression:

Code: Select all

{VariableTotals} {SumDIf((dtReport2.PLOT_UNITS * (dtReport2.DET_TRADES_PURCH_REDEEM_PRICE -decimal.Parse(dtReport2.cindexed_cost))),Age>12)}

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Sum with condition in Footer Band

Sum with condition in Footer Band

Sum with condition in Footer Band