Creating reports and dashboards | Stimulsoft community forum

i ran into some problems when i was designing the reports
--In GroupHeaderBand BS.A--
　XXXXXX

--DataSourceBand DS--
　text1　{IIF(DS.Type == "True",DS.Cash*1,DS.Cash*-1)}
　text2　{DS.Check - DS.DisCount}

--In GroupFootBand--
　How to Summary text1 and text2 to txSumText1 and txSumText2

--In ReportFootBand--
　How to Summary txSumText1 and txSumText2

Hello,

--In GroupFootBand--
　How to Summary text1 and text2 to txSumText1 and txSumText2

Please use following expressions:

txSumText1: txSumText2:

--In ReportFootBand--
　How to Summary txSumText1 and txSumText2

Same expressions:

txSumText1: txSumText2: Thank you.

Thanks for your help..

Please let us know if we may be of any further assistance.

Thank you.

another question

Can we calculate Text in Report'?

ex：
Sum(GroupFootBand4,Text2)

Due to the problem that the same number comes with multi-columns ,there's one column data which will repeat itself once, hence I will filter it out by the group function , and I need to add up all the filtered datas from other groups.
ex：
--GroupHeaderBand1(CustomerID)--
　XXXXXXXX
--GroupHeaderBand2(DeliveryID)--
　A　100　20
　B　200　20
　C　300　20
--GroupFootBand1(DeliveryID)--
　　　　　20
--GroupFootBand2(CustomerID)--
　　　　　How to Sum GroutFootBand1's Column
　

Hello,

No this is not possible, but you can create varaible (As Function) which can return required value, which can be referenced from text expressions.

Thank you.

thanks

Can you me how to refernce text expression use variables(as function)?

I tried 『Sum(GroupFooterBand,Text.Text)』 in variables(as function),but it's not work

and

int i;
int n;
for(i=0,i<5,i++)
{
n += i;
};

it's not work too,and get error....
-----------------------------------------
If I got text expresstion ,can i process it and put it into another text?
or
Can i use sql script in report to process my dataset and put it into text?
------------------------------------------
I use customer function to finish it.....
Thanks a lot

Hello,

RickyHuang wrote:thanks

Can you me how to refernce text expression use variables(as function)?

Sorry you can't calculate Text expression in total function. Please create first variable MyVar1 (Function check box is true) with following expression:
second variable MyVar2 with following expression:
After then you can use following expression in txSumText1:
in txSumText2:
to sum both values:
Thank you.

thanks for your help..:feelgood:

Always ready to help!

Thank you.