$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