$BEFORE_TIT2Grouping bill details$AFTER_TIT2
The general report generation algorithm and its appearance are similar to the standard bill. The part presenting bill details has been modified - bill details are now grouped. The report is being generated dynamically, its content is determined at the DB level.
Group quantity is determined by the DETAIL_GROUP_TYPES table data and their order - by the DETAIL_GROUP_TYPES.N_ORDER field. It is possible to specify details for each report group. Each group can include bill details from the BILL_DETAILS groups as well as sub-groups can contain details. Maximum nesting level is two, i.e. external group can contain sub-group but sub-group cannot include more sub-sub-groups.
If external group contains sub-group, then the external group details can be always opened (the external group details are sub-groups and details which directly reference the external group). The sub-group detail settings determine whether to open the sub-group.
The report group name is taken from the SHORT_NAME_R (SHORT_NAME_E) field.
Rules of the volume field generation are as follows: if reference to a record in the DETAIL_FORMAT table is set in DETAIL_GROUPS, then the record of DETAIL_FORMAT table determines the volume generation algorithm, otherwise the volume is not generated.
Total amount is not shown for the volume field.
This version of report does not use parameter which determines whether to print detail "Foreign operator roaming services".
Regulated by existing reference to the group (details having no reference to the group are not shown in the report and their amounts are not considered).
The report form example is given below (the 2nd page of the bill):
Charged for the period: ----------------------- Monthly fee calculator Telephony service 150.00 NC 5.00 Roaming service 150.00 NC 5.00 Mobile communication services Outgoing local 20 min 30sec 300.00 NC 10.00 Outgoing long distance 15 min 20sec 600.00 NC 20.00 Incoming 10 min 30sec 150.00 NC 5.00 Roaming National roaming 0.00 NC 0.00 Internationsl roaming 0.00 NC 0.00 Additional services GPRS Internet 120.00 Μα 250.00 NC 8.00 GPRS Wap 100.00 Μα 200.00 NC 7.50 Others 0.00 NC 0.00 Adjustment 0.00 NC 0.00 -------------------------------------------------------------- Total: 1250.00 NC VAT included: 250.00 NC Total, VAT not included 1000.00 NC
In the report appendix «Charges list by subscribers» the details order follow order of the 2nd page (but details and groups with zero amounts are not shown). $BILLING_BACK