How to sum another Group's Detail
-
- Posts: 68
- Joined: Tue Feb 09, 2010 3:16 am
- Location: Taiwan
How to sum another Group's Detail
hi
when i use the expression :Sum(GroupA,PRT150.MyAMT)
in GroupB,
but it is still Summary GroupB's MyAMT
How can i summary GroupA's detail in GroupB?
ex:
GroupA
---HeaderbandGroupB
------DetailA---Dataset.Amount / Sum(GroupA,Detaset.Amount)
------DetailB---Dataset.Amount / Sum(GroupA,Detaset.Amount)
---FootbandGroup
FootbandGroup
when i use the expression :Sum(GroupA,PRT150.MyAMT)
in GroupB,
but it is still Summary GroupB's MyAMT
How can i summary GroupA's detail in GroupB?
ex:
GroupA
---HeaderbandGroupB
------DetailA---Dataset.Amount / Sum(GroupA,Detaset.Amount)
------DetailB---Dataset.Amount / Sum(GroupA,Detaset.Amount)
---FootbandGroup
FootbandGroup
-
- Posts: 68
- Joined: Tue Feb 09, 2010 3:16 am
- Location: Taiwan
How to sum another Group's Detail
..^_^..
thanks a lot
thanks a lot
How to sum another Group's Detail
Have a nice day!!!
-
- Posts: 68
- Joined: Tue Feb 09, 2010 3:16 am
- Location: Taiwan
How to sum another Group's Detail
i got a problem.....
『Totals.Sum(GroupA,PRT150.MyAMT) 』 can summary GroupA
and
how can i summany all PRT150.MyAMT in GroupB ?
『Totals.Sum(GroupA,PRT150.MyAMT) 』 can summary GroupA
and
how can i summany all PRT150.MyAMT in GroupB ?
-
- Posts: 68
- Joined: Tue Feb 09, 2010 3:16 am
- Location: Taiwan
How to sum another Group's Detail
Thanks for your help
but,is it can summary all the report's PRT150.MyAMT ?
GroupA:Totals.Sum(GroupA,PRT150.MyAMT)
GroupB:Totals.Sum(GroupB,PRT150.MyAMT)
all PRT150.MyAMT:????
-
- Posts: 68
- Joined: Tue Feb 09, 2010 3:16 am
- Location: Taiwan
How to sum another Group's Detail
perfect...
thanks for your help..
-------------------------------------------------------
Is this error a bug??
I use the expression in ReportFootBand
{IIF(Sum(PRT150.PreAMT) != 0 ,Sum(PRT150.CurAMT) / Sum(PRT150.PreAMT),0))}
I got an error like "divide zero" (My language is Chinese,I dont know how to translate),
and , i use customer function to test this expression and show the message,i put the customer function:
{IIF(Sum(PRT150.PreAMT) != 0 ,MyFunction.ShowMessage(Sum(PRT150.PreAMT)),MyFunction.ShowMessage(Sum(PRT150.PreAMT)))}
the message is show 2 times,and his contents is 0,is it mean it run true and false ?
but if without Sum,it is work perfact:
{IIF(PRT150.PreAMT != 0 ,Sum(PRT150.CurAMT) / Sum(PRT150.PreAMT),0))}
and use customer function to test it ,the message is show 1 time。
-----------------------------------------
thanks......
thanks for your help..
-------------------------------------------------------
Is this error a bug??
I use the expression in ReportFootBand
{IIF(Sum(PRT150.PreAMT) != 0 ,Sum(PRT150.CurAMT) / Sum(PRT150.PreAMT),0))}
I got an error like "divide zero" (My language is Chinese,I dont know how to translate),
and , i use customer function to test this expression and show the message,i put the customer function:
{IIF(Sum(PRT150.PreAMT) != 0 ,MyFunction.ShowMessage(Sum(PRT150.PreAMT)),MyFunction.ShowMessage(Sum(PRT150.PreAMT)))}
the message is show 2 times,and his contents is 0,is it mean it run true and false ?
but if without Sum,it is work perfact:
{IIF(PRT150.PreAMT != 0 ,Sum(PRT150.CurAMT) / Sum(PRT150.PreAMT),0))}
and use customer function to test it ,the message is show 1 time。
-----------------------------------------
thanks......
How to sum another Group's Detail
Hello,
Thank you.
Try to use following expression:RickyHuang wrote:perfect...
thanks for your help..
Code: Select all
{IIF(Sum(PRT150.PreAMT) != 0 ,Div(Sum(PRT150.CurAMT) , Sum(PRT150.PreAMT)),0))}