
Hello Readers,
As mentioned in the heading today we will discuss below about Trans Header and Trans Footer. In which we need to print Carry Forwarded Amount at the Top of page and at the Bottom we used to display carry forwarded amount + Current Page amount Total.
We can achieve this functionality by these below functions.
RunningValue: Returns a running aggregate of all non-null numeric values specified by the expression, evaluated for the given scope in a paginated report.
ReportItems: ReportItems item can be used to display or calculate data from another field in the report.
syntax: ReportItems!<TextboxName.Value>
Example : =ReportItems!Textbox1.Value
Let’s move to Microsoft Builder and Add one new Textbox for Footer part to Summed up the value. Add mentioned Expression and rename the Textbox Name by TransFooterSum.
Now we need to add another Textbox for Header Part to Summed up the value. Add Expression in the textbox and rename as TransFooterSum.
Now we will Add Two Textbox in Header Part and Two Textbox in Footer Part to display
Now we will hide Trans Header Value on First Page and if you want Trans Footer Value on last page then use below expression in visibility.
Visibility Expression for Trans Header Textbox :
=IIF(Globals!PageNumber=1,true,false)
Visibility Expression for Trans Footer Textbox : =IIF(Globals!PageNumber=Globals!TotalPages,true,false)
Output First Page:
Output Second Page.
Hope you have understood pretty well about Trans Header and Trans footer.
Share your business Concerns with us on Contact@madhda.com!
Regards,
Madhda Team
Thanking you all.