How to Sum Total in GroupFootBand and ReportFootBand？

[RickyHuang]

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

[Jan]

Hello,

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

Please use following expressions:

txSumText1:

Code: Select all

{Sum(IIF(DS.Type == "True",DS.Cash*1,DS.Cash*-1))}

txSumText2:

Code: Select all

{Sum(DS.Check - DS.DisCount)}

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

Same expressions:

txSumText1:

Code: Select all

{Sum(IIF(DS.Type == "True",DS.Cash*1,DS.Cash*-1))}

txSumText2:

Code: Select all

{Sum(DS.Check - DS.DisCount)}

Thank you.

[RickyHuang]

Thanks for your help..

[Andrew]

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

Thank you.

[RickyHuang]

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
　

[Jan]

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.

[RickyHuang]

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

[Jan]

Hello,

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:

Code: Select all

IIF(DS.Type == "True",DS.Cash*1,DS.Cash*-1)

second variable MyVar2 with following expression:

Code: Select all

DS.Check - DS.DisCount

After then you can use following expression in txSumText1:

Code: Select all

{Sum(MyVar1)}

in txSumText2:

Code: Select all

{Sum(MyVar2)}

to sum both values:

Code: Select all

{Sum(MyVar1 + MyVar2)}

Thank you.

[RickyHuang]

thanks for your help..:feelgood:

[Andrew]

Always ready to help!

Thank you.