Joined: 23 Jul 2008
Location: United Arab Emirates
Online Status: Offline
Posts: 6
Topic: Report Total in the Report Header Posted: 23 Jul 2008 at 12:53am
I have a simple print form of a Purchase Order, which has the Purchase Order Value printed in the Report Footer. The 'total' field being a formula which adds invidual PO Line amounts. Line amount is basically a computation of Qty with Price.
The requirement is to maintain the PO Total in the Report Header section in addition to the standard footer total. Whats the simplest way out ?
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 23 Jul 2008 at 1:33pm
From your post we know you're using the Report Header section but what other sections are you using in your report? Are you grouping in any way?
If your outermost group is the Purchase Order Number, then I would move all of the header information out of the report header and into that group. If you don't already have it, create a formula for the extended amount, which is the quantity times the price. Then create a "Summary" (click on the Sigma [large E] button) that is the sum of this formula for the Purchase Order group. Move this summary from the group footer to the group header. Your value should now appear in the header information for the report.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 24 Jul 2008 at 7:01am
There are a couple of ways you can do this. The easiest is to probably put a suppression formula on the total object. Right-click on the total and select Properties. DO NOT click on the check-box for Suppress, instead click on the button to the right of it and enter the following formula:
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
