How to create a geographical breakdown by country and region (audit system only)

The default format for the geographical breakdown  in QuickFill's 'Qualified circulation', 'Publisher's statement', and 'Audit issue galley' reports is U.S. state/region and Canadian province. However, if you wish to produce a breakdown on a country and region basis instead, you can do so by defining an ASCII table, QFWFORGN.TAB, with the country/region breakdowns you would like to use. As long as QFWFORGN.TAB is in your database directory, QuickFill will provide breakdowns for the countries and regions in this table whenever you run the 'Qualified circulation', 'Publisher's statement', or 'Audit issue galley' reports.

 

QFWFORGN.TAB should have the following format:

 

[regions]

RegionName1=

COUNTRYCODE1

COUNTRYCODE2

COUNTRYCODE3

 

RegionName2=

COUNTRYCODE4

COUNTRYCODE5

COUNTRYCODE6

 

Sample QFWFORGN.TAB: 

 

[regions]

Latin America/Caribbean=

ANGU

ANT

ARG

.

.

VEN

 

Africa=

BOT

NIGA

SAFR

 

Asia=

AFG

ALB

ARM

.

.

.

 

General rules for QFWFORGN.TAB:

  1. Blank lines are ignored.

  2. Lines beginning with ";" are ignored.

  3. Country codes must be entered in UPPERCASE.

  4. Enter the regions and countries in the order that you want them to appear in the report.

  5. Commands such as "[regions]" and "RegionName1=" must be entered as shown above.

  6. If a country is assigned to more than one region, it is listed under each region to which it has been assigned, but data for that country is only be reported in the first region.

  7. QFWFORGN.TAB is ignored if a file named QFWCNTY.TAB (the ASCII table for creating a geographical breakdown by county/region) also exists in your database directory.

 

Click here for details on creating a geographical breakdown by county and region.