baan999
5th October 2011, 08:12
i want to print the grand total in after report layout.

detail line supprresed in the report
after field (1 line order no,amount,rate )printing by customer wise

ex.
1 order ,rate,amount ( total all for the single custome... ZZZZZZZ)printing
2.order,rate,amoun t ( total all for the single custome... xxxxxxx) prniting

now i want the both total amount(1 line ) to be printed in after report

refer below report script . it is not printing. what is wrong or what new script to written. pl give with example code




declaration:
extern domain tcamnt grand.tot

before.prnt.seqn.1:
before.layout:
grand.tot = 0
detail.1:
before.layout:
grand.tot = grand.tot + (amt111/1.24)

mark_h
5th October 2011, 16:49
How did you suppress the printing of the detail layout? Is there actually a detail layout? I will have to go dig thru my reports to find an example, but I know for totals I had to actually include the detail layout.

bdittmar
5th October 2011, 19:51
i want to print the grand total in after report layout.

detail line supprresed in the report
after field (1 line order no,amount,rate )printing by customer wise

ex.
1 order ,rate,amount ( total all for the single custome... ZZZZZZZ)printing
2.order,rate,amoun t ( total all for the single custome... xxxxxxx) prniting

now i want the both total amount(1 line ) to be printed in after report

refer below report script . it is not printing. what is wrong or what new script to written. pl give with example code




declaration:
extern domain tcamnt grand.tot

before.prnt.seqn.1:
before.layout:
grand.tot = 0
detail.1:
before.layout:
grand.tot = grand.tot + (amt111/1.24)

Hello,
pay attention at the report flow and increase the variable at the right place.
(Maybe it is reseted to 0 at ....seqn.1 an so never reaches the after.report section? )
Maybe it would be better to increase in after.layout ?

BEFORE.REPORT
HEADER.x
BEFORE.FIELD.1
BEFORE.FIELD.2 .....
DETAIL.1
DETAIL.2 .....
AFTER.FIELD. .....
AFTER.REPORT

Regards

Hitesh Shah
6th October 2011, 11:25
You just need to define the field as total in after report section with appropriate aggregate expression . Coding is report script is required only when u need to do derive % or proportions on aggregates.

In ur report script u have initialized grand.tot in before.field section . It must be before.report and u need to increment the variable in after.receive.data or detail in appropriate condition.