I got the desired results by adding variable in detailSection for displaying sum in Pagefooter. However, I added the variable in Pagefooter and placed the variable in Report Footer I am not getting the value. Am I doing anything wrong here. My variable has the properties as Value Expr : Revenue amount + $SumRev and Rest Expr :InvItem.Item Class Description.
Can you please help me understand where I am going wrong?
I tried it through sub report still not retrieving the item and its total.
In the detail section it is as below:
Item Desc Amt
I1 InvItem1 10000.00
I2 InvItem1 10000.00
I3 InvItem1 $999.00
I4 InvItem2 $10,000.00
Further, I need to display in the Report section as:
InvItem1 $20,999.00 ($RevenueAmt).
InvItem2 $10,000.00
Total: $30,9999.00
. How to achieve this?
Best answer by WillH
Hi @SujaFMS - What exactly are you wanting to display? Do you have a sketch of the report and how things should sit together ideally?
In terms of “am I doing something wrong”, the most annoying setting for me was always ProcessOrder, which isn’t very intuitive to wrap your head around. If a variable isn’t calculating the way I want I’d usually look there.
Also check your variable collection, specifically for: ProcessOrder & ResetGroup
If the ResetGroup is hitting earlier than you expect then you can end up with some problems with variables becoming clear, which it sounds like might be the case for your expression if it works in PageFooter, but not ReportFooter.
Questions:
Can you sketch up something showing what you expect where?
Can you see the values you want at any time?
If you aren’t seeing what you want, what are you seeing?
Hi @SujaFMS - What exactly are you wanting to display? Do you have a sketch of the report and how things should sit together ideally?
In terms of “am I doing something wrong”, the most annoying setting for me was always ProcessOrder, which isn’t very intuitive to wrap your head around. If a variable isn’t calculating the way I want I’d usually look there.
Also check your variable collection, specifically for: ProcessOrder & ResetGroup
If the ResetGroup is hitting earlier than you expect then you can end up with some problems with variables becoming clear, which it sounds like might be the case for your expression if it works in PageFooter, but not ReportFooter.
Questions:
Can you sketch up something showing what you expect where?
Can you see the values you want at any time?
If you aren’t seeing what you want, what are you seeing?
